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$BACKUP_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 propagated from V$BACKUP_CORRUPTION. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
BS_KEY |
NUMBER |
NOT NULL |
The primary key of the backup set to which this record belongs in the recovery catalog. Use this column to form a join with RC_BACKUP_SET. |
SET_STAMP |
NUMBER |
NOT NULL |
The SET_STAMP value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup set to which this record belongs in the target database control file. |
SET_COUNT |
NUMBER |
NOT NULL |
The SET_COUNT value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup set to which this record belongs in the target database control file. |
PIECE# |
NUMBER |
NOT NULL |
The backup piece to which the block belongs. |
BDF_KEY |
NUMBER |
NOT NULL |
The primary key for the datafile backup or copy in the recovery catalog. Use this key to join with RC_BACKUP_DATAFILE. If you issue the list command while connected to the recovery catalog, this value appears in the KEY column of the output. |
BDF_RECID |
NUMBER |
NOT NULL |
The RECID value from V$BACKUP_DATAFILE. |
BDF_STAMP |
NUMBER |
NOT NULL |
The STAMP value from V$BACKUP_DATAFILE. |
FILE# |
NUMBER |
NOT NULL |
The absolute file number for the datafile. |
CREATION_CHANGE# |
NUMBER |
NOT NULL |
The SCN at backup creation. |
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 Oracle or NO if it was already known by Oracle. |