DB_KEY |
NUMBER |
NOT NULL |
The primary key for the target database. Use this column to form a join with almost any other catalog view. |
DBINC_KEY |
NUMBER |
NOT NULL |
The primary key for the incarnation of the target database. Use this column to form a join with RC_DATABASE_INCARNATION. |
DB_NAME |
VARCHAR2(8) |
NOT NULL |
The DB_NAME of the database incarnation to which this record belongs. |
RECID |
NUMBER |
NOT NULL |
The record identifier from V$COPY_CORRUPTION. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
STAMP |
NUMBER |
NOT NULL |
The stamp from V$COPY_CORRUPTION. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
CDF_KEY |
NUMBER |
NOT NULL |
The primary key of the datafile copy in the recovery catalog. If you issue the list command while connected to the recovery catalog, this value appears in the KEY column of the output. Use this column to form a join with RC_DATAFILE_COPY. |
COPY_RECID |
NUMBER |
NOT NULL |
The RECID from RC_DATAFILE_COPY. This value is propagated from the control file. |
COPY_STAMP |
NUMBER |
NOT NULL |
The STAMP from RC_DATAFILE_COPY. This value is propagated from the control file. |
FILE# |
NUMBER |
NOT NULL |
The absolute file number of the datafile. |
CREATION_CHANGE# |
NUMBER |
NOT NULL |
The SCN recorded at the creation of the copy. |
BLOCK# |
NUMBER |
NOT NULL |
The block number of the first corrupted block in the file. |
BLOCKS |
NUMBER |
NOT NULL |
The number of corrupted blocks found beginning with BLOCK#. |
CORRUPTION_CHANGE# |
NUMBER |
|
The SCN at which corruption was detected. |
MARKED_CORRUPT |
VARCHAR2(3) |
|
YES if this corruption was not previously detected by the database server or NO if it was already known by the database server. |