Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 35 of 211


V$COPY_CORRUPTION

This view displays information about datafile copy corruptions from the control file.

Column  Datatype  Description 

RECID 

NUMBER 

Copy corruption record ID 

STAMP 

NUMBER 

Copy corruption record stamp 

COPY_RECID 

NUMBER 

Datafile copy record ID 

COPY_STAMP 

NUMBER 

Datafile copy record stamp 

FILE# 

NUMBER 

Datafile number 

BLOCK# 

NUMBER 

First block of the corrupted range 

BLOCKS 

NUMBER 

Number of contiguous blocks in the corrupted range 

CORRUPTION_CHANGE# 

NUMBER 

Change# at which the logical corruption was detected. Set to 0 to indicate media corruption. 

MARKED_CORRUPT 

VARCHAR2(3) 

(YES | NO) If set to YES the blocks were not marked corrupted in the datafile, but were detected and marked as corrupted while making the datafile copy 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback