12
Recovery Catalog Views

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.  

AL_KEY  

NUMBER  

NOT NULL  

The primary key of the archived redo log 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.  

RECID  

NUMBER  

NOT NULL  

The archived redo log RECID from V$ARCHIVED_LOG. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.  

STAMP  

NUMBER  

NOT NULL  

The archived redo log stamp from V$ARCHIVED_LOG. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.  

THREAD#  

NUMBER  

NOT NULL  

The number of the redo thread.  

SEQUENCE#  

NUMBER  

NOT NULL  

The log sequence number.  

RESETLOGS_CHANGE#  

NUMBER  

NOT NULL  

The SCN of the most recent RESETLOGS when the record was created.  

RESETLOGS_TIME  

DATE  

NOT NULL  

The timestamp of the most recent RESETLOGS when the record was created.  

FIRST_CHANGE#  

NUMBER  

NOT NULL  

The SCN generated when Oracle switched into the redo log.  

FIRST_TIME  

DATE  

NOT NULL  

The time when Oracle switched into the redo log.  

NEXT_CHANGE#  

NUMBER  

NOT NULL  

The first SCN of the next redo log in the thread.  

NEXT_TIME  

DATE  

The first timestamp of the next redo log in the thread.  

BLOCKS  

NUMBER  

NOT NULL  

The number of blocks written (also the size of the archived log when the copy was made).  

BLOCK_SIZE  

NUMBER  

NOT NULL  

The size of the block in bytes.  

COMPLETION_TIME  

DATE  

NOT NULL  

The time when the redo log was archived or copied.  

ARCHIVED  

VARCHAR2(3)  

Indicates whether the log was archived: YES (archived redo log) or NO (inspected online redo log). When Oracle inspects online logs, it looks at the file headers and adds an archived log record for each online log. Oracle sets ARCHIVED to NO to prevent online logs from being backed up.  

STATUS  

VARCHAR2(1)  

NOT NULL  

The status of the archived redo log: A (available), U (unavailable), or D (deleted).  

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.  

BCF_KEY  

NUMBER  

NOT NULL  

The primary key of the control file backup 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.  

RECID  

NUMBER  

NOT NULL  

The RECID from V$BACKUP_DATAFILE. 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$BACKUP_DATAFILE. 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.  

RESETLOGS_CHANGE#  

NUMBER  

NOT NULL  

The SCN of the most recent RESETLOGS when the record was created.  

RESETLOGS_TIME  

DATE  

NOT NULL  

The timestamp of the most recent RESETLOGS when the record was created.  

CHECKPOINT_CHANGE#  

NUMBER  

NOT NULL  

The control file checkpoint SCN.  

CHECKPOINT_TIME  

DATE  

NOT NULL  

The control file checkpoint time.  

CREATION_TIME#  

DATE  

NOT NULL  

The control file creation time.  

BLOCK_SIZE  

NUMBER  

NOT NULL  

The size of the blocks in bytes.  

OLDEST_OFFLINE_RANGE  

NUMBER  

NOT NULL  

Internal use only.  

STATUS  

VARCHAR2(1)  

NOT NULL  

The status of the backup set: A (available), U (unavailable), or D (deleted).  

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.  

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.  

BDF_KEY  

NUMBER  

NOT NULL  

The primary key of the datafile backup 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.  

RECID  

NUMBER  

NOT NULL  

The backup datafile RECID from V$BACKUP_DATAFILE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.  

STAMP  

NUMBER  

NOT NULL  

The backup datafile stamp from V$BACKUP_DATAFILE. 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.  

BS_RECID  

NUMBER  

NOT NULL  

The RECID from V$BACKUP_SET.  

BS_STAMP  

NUMBER  

NOT NULL  

The STAMP from V$BACKUP_SET.  

BACKUP_TYPE  

VARCHAR2(1)  

NOT NULL  

The type of the backup: D (full or level 0 incremental) or I (incremental level 1 or higher).  

INCREMENTAL_LEVEL  

NUMBER  

The level of the incremental backup: NULL or 0 - 4.  

COMPLETION_TIME  

DATE  

The completion time of the backup.  

FILE#  

NUMBER  

NOT NULL  

The absolute file number of the datafile.  

CREATION_CHANGE#  

NUMBER  

NOT NULL  

The SCN at the creation of the backup.  

RESETLOGS_CHANGE#  

NUMBER  

NOT NULL  

The SCN of the most recent RESETLOGS in the datafile header.  

RESETLOGS_TIME  

DATE  

NOT NULL  

The timestamp of the most recent RESETLOGS in the datafile header.  

INCREMENTAL_CHANGE#  

NUMBER  

NOT NULL  

The SCN that determines whether a block will be included in the incremental backup. A block is only included if the SCN in the block header is greater than or equal to INCREMENTAL_CHANGE#.

The range of redo covered by the incremental backup begins with INCREMENTAL_CHANGE# and ends with CHECKPOINT_CHANGE#.  

CHECKPOINT_CHANGE#  

NUMBER  

NOT NULL  

The SCN of the most recent datafile checkpoint.  

CHECKPOINT_TIME  

DATE  

NOT NULL  

The time of the last datafile checkpoint.  

ABSOLUTE_FUZZY_CHANGE#  

NUMBER  

The absolute fuzzy SCN.  

DATAFILE_BLOCKS  

NUMBER  

NOT NULL  

The number of data blocks in the datafile.  

BLOCKS  

NUMBER  

NOT NULL  

The number of data blocks written to the backup.  

BLOCK_SIZE  

NUMBER  

NOT NULL  

The size of the data blocks in bytes.  

STATUS  

VARCHAR2(1)  

NOT NULL  

The status of the backup set: A (all pieces available), D (all pieces deleted), O (some pieces are available but others are not, so the backup set is unusable).  

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.  

DB_ID  

NUMBER  

NOT NULL  

The database identifier.  

BP_KEY  

NUMBER  

NOT NULL  

The primary key for the backup piece 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.  

RECID  

NUMBER  

NOT NULL  

The backup piece RECID from V$BACKUP_PIECE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.  

STAMP  

NUMBER  

NOT NULL  

The backup piece stamp propagated from V$BACKUP_PIECE. 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.  

BACKUP_TYPE  

VARCHAR2(1)  

NOT NULL  

The type of the backup: D (full or level 0 incremental), I (incremental level 1 or higher), L (archived redo log).  

INCREMENTAL_LEVEL  

NUMBER  

The level of the incremental backup: NULL or 0 - 4.  

PIECE#  

NUMBER  

NOT NULL  

The number of the backup piece. The first piece has the value of 1.  

COPY#  

NUMBER  

NOT NULL  

The copy number of the backup piece.  

DEVICE_TYPE  

VARCHAR2(255)  

NOT NULL  

The type of backup device: DISK or SBT_TAPE (sequential media).  

HANDLE  

VARCHAR2(1024)  

NOT NULL  

The filename of the backup piece. It is the value that RMAN passes to the OSD layer that identifies the file.  

COMMENTS  

VARCHAR2(255)  

Comments about the backup piece.  

MEDIA  

VARCHAR2(80)  

A comment that contains further information about the media manager that created this backup.  

MEDIA_POOL  

NUMBER  

The number of the media pool in which the backup is stored.  

CONCUR  

VARCHAR2(3)  

Specifies whether backup media supports concurrent access: YES or NO.  

TAG  

VARCHAR2(32)  

The user-specified tag for the backup piece.  

START_TIME  

DATE  

NOT NULL  

The time when RMAN started to write the backup piece.  

COMPLETION_TIME  

DATE  

NOT NULL  

The time when the backup piece was completed.  

ELAPSED_SECONDS  

NUMBER  

The duration of the creation of the backup piece.  

STATUS  

VARCHAR2(1)  

NOT NULL  

The status of the backup piece: A (available), U (unavailable), D (deleted), or X (expired).  

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.  

BRL_KEY  

NUMBER  

NOT NULL  

The primary key of the archived redo log 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.  

RECID  

NUMBER  

NOT NULL  

The record identifier propagated from V$BACKUP_REDOLOG. 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$BACKUP_REDOLOG. 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.  

BACKUP_TYPE  

VARCHAR2(1)  

NOT NULL  

The type of the backup: L (archived redo log).  

COMPLETION_TIME  

DATE  

NOT NULL  

The time when the backup completed.  

THREAD#  

NUMBER  

NOT NULL  

The thread number of the redo log.  

SEQUENCE#  

NUMBER  

NOT NULL  

The log sequence number.  

RESETLOGS_CHANGE#  

NUMBER  

NOT NULL  

The SCN of the most recent RESETLOGS when the record was created.  

RESETLOGS_TIME  

DATE  

NOT NULL  

The timestamp of the most recent RESETLOGS when the record was created.  

FIRST_CHANGE#  

NUMBER  

NOT NULL  

The SCN generated when Oracle switched into the redo log.  

FIRST_TIME  

DATE  

NOT NULL  

The time when Oracle switched into the redo log.  

NEXT_CHANGE#  

NUMBER  

NOT NULL  

The first SCN of the next redo log in the thread.  

NEXT_TIME  

DATE  

NOT NULL  

The first timestamp of the next redo log in the thread.  

BLOCKS  

NUMBER  

NOT NULL  

The number of blocks written to the backup.  

STATUS  

VARCHAR2(1)  

NOT NULL  

The status of the backup set: A (all pieces available), D (all pieces deleted), O (some pieces are available but others are not, so the backup set is unusable).  

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.  

DB_ID  

NUMBER  

NOT NULL  

The unique database identifier.  

BS_KEY  

NUMBER  

NOT NULL  

The primary key of the backup set 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.  

RECID  

NUMBER  

NOT NULL  

The backup set RECID from V$BACKUP_SET. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. Use either RECID and STAMP or SET_STAMP and SET_COUNT to access V$BACKUP_SET.  

STAMP  

NUMBER  

NOT NULL  

The backup set STAMP from V$BACKUP_SET. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. Use either RECID and STAMP or SET_STAMP and SET_COUNT to access V$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 this record in the target database control file. Use either RECID and STAMP or SET_STAMP and SET_COUNT to access V$BACKUP_SET.  

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 this record in the target database control file. Use either RECID and STAMP or SET_STAMP and SET_COUNT to access V$BACKUP_SET.  

BACKUP_TYPE  

VARCHAR2(1)  

NOT NULL  

The type of the backup: D (full or level 0 incremental), I (incremental level 1 or higher), L (archived redo log).  

INCREMENTAL_LEVEL  

NUMBER  

NOT NULL  

The level of the incremental backup: NULL or 0 - 4.  

PIECES  

NUMBER  

NOT NULL  

The number of backup pieces in the backup set.  

START_TIME  

DATE  

NOT NULL  

The time when the backup began.  

COMPLETION_TIME  

DATE  

NOT NULL  

The time when the backup completed.  

ELAPSED_SECONDS  

NUMBER  

The duration of the backup in seconds.  

STATUS  

VARCHAR2(1)  

NOT NULL  

The status of the backup set: A (all pieces available), D (all pieces deleted), O (some pieces are available but others are not, so the backup set is unusable).  

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.  

CKP_KEY  

NUMBER  

NOT NULL  

The primary key for the checkpoint.  

CKP_SCN  

NUMBER  

NOT NULL  

The control file checkpoint SCN.  

CKP_CF_SEQ  

NUMBER  

NOT NULL  

The control file sequence number.  

CKP_TIME  

DATE  

The time at which the catalog was checkpointed.  

CKP_TYPE  

VARCHAR2(7)  

NOT NULL  

The type of resynchronization: FULL or PARTIAL.  

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.  

CCF_KEY  

NUMBER  

NOT NULL  

The primary key of the control file 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.  

RECID  

NUMBER  

NOT NULL  

The record identifier from V$DATAFILE_COPY. 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$DATAFILE_COPY. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.  

NAME  

VARCHAR2(1024)  

NOT NULL  

The control file copy filename.  

TAG  

VARCHAR2(32)  

The tag of the control file copy. NULL if no tag used.  

RESETLOGS_CHANGE#  

NUMBER  

NOT NULL  

The SCN of the most recent RESETLOGS when the record was created.  

RESETLOGS_TIME  

DATE  

NOT NULL  

The timestamp of the most recent RESETLOGS when the record was created.  

CHECKPOINT_CHANGE#  

NUMBER  

NOT NULL  

The control file checkpoint SCN.  

CHECKPOINT_TIME  

DATE  

NOT NULL  

The control file checkpoint time.  

CREATION_TIME  

DATE  

NOT NULL  

The control file creation time.  

BLOCK_SIZE  

NUMBER  

NOT NULL  

The block size in bytes.  

MIN_OFFR_RECID  

NUMBER  

NOT NULL  

Internal use only.  

OLDEST_OFFLINE_RANGE  

NUMBER  

NOT NULL  

Internal use only.  

COMPLETION_TIME  

DATE  

NOT NULL  

The time when the copy was generated.  

STATUS  

VARCHAR2(1)  

NOT NULL  

The status of the copy: A (available), U (unavailable), or D (deleted).  

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 Oracle or NO if it was already known by Oracle.  

DB_KEY  

NUMBER  

NOT NULL  

The primary key for the database. Use this column to form a join with almost any other catalog view.  

DBINC_KEY  

NUMBER  

The primary key for the current incarnation. Use this column to form a join with RC_DATABASE_INCARNATION.  

DBID  

NUMBER  

NOT NULL  

Unique identifier for the database obtained from V$DATABASE.  

NAME  

VARCHAR2(8)  

NOT NULL  

The DB_NAME of the database for the current incarnation.  

RESETLOGS_CHANGE#  

NUMBER  

NOT NULL  

The SCN of the most recent RESETLOGS operation when the record was created.  

RESETLOGS_TIME  

DATE  

NOT NULL  

The timestamp of the most recent RESETLOGS operation when the record was created.  

DB_KEY  

NUMBER  

NOT NULL  

The primary key for the database. Use this column to form a join with almost any other catalog view.  

DBID  

NUMBER  

NOT NULL  

Unique identifier for the database.  

DBINC_KEY  

NUMBER  

NOT NULL  

The primary key for the incarnation.  

NAME  

VARCHAR2(8)  

NOT NULL  

The DB_NAME for the database at the time of the RESETLOGS operation.  

RESETLOGS_CHANGE#  

NUMBER  

NOT NULL  

The SCN of the RESETLOGS operation that created this incarnation.  

RESETLOGS_TIME  

DATE  

NOT NULL  

The timestamp of the RESETLOGS operation that created this incarnation.  

CURRENT_INCARNATION  

VARCHAR2(3)  

YES if it is the current incarnation; NO if it is not.  

PARENT_DBINC_KEY  

NUMBER  

The DBINC_KEY of the previous incarnation for this database. The value is NULL if it is the first incarnation recorded for the database.  

DB_KEY  

NUMBER  

NOT NULL  

The primary key for the target database.  

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.  

TS#  

NUMBER  

NOT NULL  

The tablespace identifier in the target database. The TS# may exist multiple times in the same incarnation if the tablespace is dropped and re-created.  

TABLESPACE_NAME  

VARCHAR2(30)  

NOT NULL  

The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created.  

FILE#  

NUMBER  

NOT NULL  

The absolute file number of the datafile. The same datafile number may exist multiple times in the same incarnation if the datafile is dropped and re-created.  

CREATION_CHANGE#  

NUMBER  

NOT NULL  

The SCN at datafile creation.  

CREATION_TIME  

DATE  

The time of datafile creation.  

DROP_CHANGE#  

NUMBER  

The SCN recorded when the datafile was dropped. If a new datafile with the same file number is discovered then the DROP_CHANGE# is set to CREATION_CHANGE# for the datafile; otherwise the value is set to RC_CHECKPOINT.CKP_SCN.  

DROP_TIME  

DATE  

The time when the datafile was dropped. If a new datafile with the same file number is discovered then the DROP_TIME is set to CREATION_TIME for the datafile; otherwise the value is set to RC_CHECKPOINT.CKP_TIME.  

BYTES  

NUMBER  

The size of the datafile in bytes.  

BLOCKS  

NUMBER  

The number of blocks in the datafile.  

BLOCK_SIZE  

NUMBER  

NOT NULL  

The size of the data blocks.  

NAME  

VARCHAR2(1024)  

The datafile filename.  

STOP_CHANGE#  

NUMBER  

SCN for datafile if offline normal or read-only.  

READ_ONLY  

NUMBER  

NOT NULL  

1 if STOP_CHANGE# is read-only; otherwise 0.