12
Recovery Catalog Views

This chapter contains descriptions of recovery catalog views. You can only access these views if you have created a recovery catalog.

Note:
These views are not normalized, but are optimized for RMAN usage. Hence, most catalog views have redundant values that proceed from the join of several tables.

RC_ARCHIVED_LOG

This view lists historical information about all archived redo logs. It corresponds to the V$ARCHIVED_LOG dynamic performance view in the control file.

An archived redo log record is inserted after the online redo log is successfully archived or cleared (NAME column is NULL if the log was cleared). If the log is archived multiple times (the maximum is 5), there will be multiple archived log records with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name. An archived log record is also inserted when an archived log is restored from a backup set or a copy.

Note that an archived redo log can have no log history record if its log history record is written over in the control file or after a RESETLOGS operation.

Column	Datatype	NULL	Description
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).

RC_BACKUP_CONTROLFILE

This view lists information about control files in backup sets. Note that a backup datafile record with file number 0 represents the backup control file in the V$BACKUP_DATAFILE dynamic performance view.

Column	Datatype	NULL	Description
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).

RC_BACKUP_CORRUPTION

This view lists corrupt block ranges in datafile backups. It corresponds to the V$BACKUP_CORRUPTION dynamic performance view in the control file. Note that corruptions are not tolerated in control file and archived redo log backups.

Column	Datatype	NULL	Description
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.

RC_BACKUP_DATAFILE

This view lists information about datafiles in backup sets. It corresponds to the V$BACKUP_DATAFILE dynamic performance view. A backup datafile is uniquely identified by BDF_KEY.

Column	Datatype	NULL	Description
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).

RC_BACKUP_PIECE

This view lists information about backup pieces. This view corresponds to the V$BACKUP_PIECE dynamic performance view. Each backup set contains one or more backup pieces.

Multiple copies of the same backup piece can exist, but each copy will have its own record in the control file and its own row in the view.

Column	Datatype	NULL	Description
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).

RC_BACKUP_REDOLOG

This view lists information about archived redo logs in backup sets. It corresponds to the V$BACKUP_REDOLOG dynamic performance view in the control file.

You cannot back up online logs directly; you must first archive them to disk and then back them up. An archived log backup set contains one or more archived logs.

Column	Datatype	NULL	Description
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).

RC_BACKUP_SET

This view lists information about backup sets for all incarnations of the database. It corresponds to the V$BACKUP_SET dynamic performance view. A backup set record is inserted after the backup has successfully completed.

Column	Datatype	NULL	Description
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).

RC_CHECKPOINT

This view lists recovery catalog resynchronization information. It does not give information about database checkpoints. In most cases, you should use RC_RESYNC instead.

Column	Datatype	NULL	Description
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.

RC_CONTROLFILE_COPY

This view lists information about control file copies on disk. Note that a datafile copy record with a file number of 0 is used to represent the control file copy in the V$DATAFILE_COPY dynamic performance view.

Column	Datatype	NULL	Description
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).

RC_COPY_CORRUPTION

This view lists corrupt block ranges in datafile copies. It corresponds to the V$COPY_CORRUPTION dynamic performance view.

Column	Datatype	NULL	Description
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.

RC_DATABASE

This view gives information about the databases registered in the recovery catalog.

Column Datatype NULL Description

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.

Column	Datatype	NULL	Description
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.

RC_DATABASE_INCARNATION

This view lists information about all database incarnations registered in the recovery catalog. Oracle creates a new incarnation whenever you open a database with the RESETLOGS option.

Column Datatype NULL Description

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.

Column	Datatype	NULL	Description
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.

RC_DATAFILE

This view lists information about all datafiles registered in the recovery catalog. It corresponds to the V$DATAFILE dynamic performance view. A datafile is shown as dropped if its tablespace was dropped.

Column Datatype NULL Description

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.

Column	Datatype	NULL	Description
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.

RC_DATAFILE_COPY

This view lists information about datafile copies on disk. It corresponds to the V$DATAFILE_COPY dynamic performance view.

Column	Datatype	NULL	Description
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.
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.
RECID	NUMBER	NOT NULL	The datafile copy record 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 datafile copy 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 filename of the datafile copy.
TAG	VARCHAR2(32)		The tag for the datafile copy.
FILE#	NUMBER	NOT NULL	The absolute file number for the datafile.
CREATION_CHANGE#	NUMBER	NOT NULL	The SCN for the datafile copy creation.
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_LEVEL	NUMBER		The incremental level of the copy: 0 or NULL.
CHECKPOINT_CHANGE#	NUMBER	NOT NULL	The SCN of the most recent datafile checkpoint.
CHECKPOINT_TIME	DATE	NOT NULL	The time of the most recent datafile checkpoint.
ABSOLUTE_FUZZY_CHANGE#	NUMBER		The highest SCN in any block of the file, if known.
RECOVERY_FUZZY_CHANGE#	NUMBER		The SCN to which recovery must proceed for the file to become not fuzzy. If not NULL, this file must be recovered at least to the specified SCN before the database can be opened with this file.
RECOVERY_FUZZY_TIME	DATE		The time to which recovery must proceed for the file to become not fuzzy. If not NULL, this file must be recovered at least to the specified time before the database can be opened with this file.
ONLINE_FUZZY	VARCHAR2(3)		YES/NO. If set to YES, this copy was made after a crash or OFFLINE IMMEDATE (or is a copy of a copy that was taken improperly while the database was open). Recovery will need to apply all redo up to the next crash recovery marker to make the file consistent.
BACKUP_FUZZY	VARCHAR2(3)		YES/NO. If set to YES, this is a copy taken using the BEGIN BACKUP/END BACKUP technique. To make this copy consistent, Recovery will need to apply all redo up to the marker that is placed in the redo stream when the ALTER TABLESPACE END BACKUP command is used.
BLOCKS	NUMBER	NOT NULL	The number of blocks in the datafile copy (also the size of the datafile when the copy was made).
BLOCK_SIZE	NUMBER	NOT NULL	The size of the blocks in bytes.
COMPLETION_TIME			The time when the copy completed.
STATUS	VARCHAR2(1)	NOT NULL	The status of the copy: A (available), U (unavailable), or D (deleted).

RC_LOG_HISTORY

This view lists historical information about the online redo logs. It corresponds to the V$LOG_HISTORY dynamic performance view.

Column	Datatype	NULL	Description
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 redo log history RECID from V$LOG_HISTORY. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
STAMP	NUMBER	NOT NULL	The redo log history stamp from V$LOG_HISTORY. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
THREAD#	NUMBER	NOT NULL	The thread number of the online redo log.
SEQUENCE#	NUMBER	NOT NULL	The log sequence number of the redo log.
FIRST_CHANGE#	NUMBER	NOT NULL	The SCN generated when switching into the redo log.
FIRST_TIME	DATE	NOT NULL	The timestamp when switching into the redo log.
NEXT_CHANGE#	NUMBER	NOT NULL	The first SCN of the next redo log in the thread.
CLEARED	VARCHAR2(3)		'?' if the redo log was cleared with the ALTER DATABASE CLEAR LOGFILE statement; otherwise, NULL. This statement allows a log to be dropped without archiving it first.

RC_OFFLINE_RANGE

This view lists the offline ranges for datafiles. It corresponds to the V$OFFLINE_RANGE dynamic performance view.

An offline range is created for a datafile when its tablespace is first altered to be offline normal or read-only, and then subsequently altered to be online or read-write. Note that no offline range is created if the datafile itself is altered to be offline or if the tablespace is altered to be offline immediate.

Column	Datatype	NULL	Description
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 for the offline range from V$OFFLINE_RANGE. 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 for the offline range from V$OFFLINE_RANGE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
FILE#	NUMBER	NOT NULL	The absolute file number of the datafile.
CREATION_CHANGE#	NUMBER	NOT NULL	The SCN at datafile creation.
OFFLINE_CHANGE#	NUMBER	NOT NULL	The SCN taken when the datafile was taken offline.
ONLINE_CHANGE#	NUMBER	NOT NULL	The online checkpoint SCN.
ONLINE_TIME	DATE	NOT NULL	The online checkpoint time.
CF_CREATE_TIME	DATE		The time of control file creation.

RC_PROXY_CONTROLFILE

This view contains descriptions of control file backups that were taken with proxy copy. In a proxy copy, the media manager takes over the operations of backing up and restoring data. Each row represents a backup of one control file. This view corresponds to V$PROXY_DATAFILE.

Column	Datatype	NULL	Description
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.
XDF_KEY	NUMBER	NOT NULL	The proxy copy primary key 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 proxy copy record identifier from V$PROXY_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 proxy copy stamp from V$PROXY_DATAFILE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
TAG	VARCHAR2(32)		The tag for the proxy copy.
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	Checkpoint SCN when the copy was made.
CHECKPOINT_TIME	DATE	NOT NULL	Checkpoint time when the copy was made.
CREATION_TIME	DATE	NOT NULL	The control file creation time.
BLOCK_SIZE	NUMBER	NOT NULL	The block size for the copy in bytes.
MIN_OFFR_RECID	NUMBER	NOT NULL	Internal use only.
OLDEST_OFFLINE_RANGE	NUMBER	NOT NULL	Internal use only.
DEVICE_TYPE	VARCHAR2(255)	NOT NULL	The type of sequential media device.
HANDLE	VARCHAR2(1024)	NOT NULL	The filename for the proxy copy. It is the value that RMAN passes to the OSD layer that identifies the file.
COMMENTS	VARCHAR2(255)		Comments about the proxy copy.
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 proxy copy is stored.
START_TIME	DATE	NOT NULL	The time when proxy copy was initiated.
COMPLETION_TIME	DATE	NOT NULL	The time when the proxy copy was completed.
ELAPSED_SECONDS	NUMBER		The duration of the proxy copy.
STATUS	VARCHAR2(1)	NOT NULL	The status of the backup set: A (available), U (unavailable), X (expired), or D (deleted).

RC_PROXY_DATAFILE

This view contains descriptions of datafile backups that were taken with proxy copy. It corresponds to the V$PROXY_DATAFILE dynamic performance view. In a proxy copy, the media manager takes over the operations of backing up and restoring data. Each row represents a backup of one database file.

Column	Datatype	NULL	Description
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.
XDF_KEY	NUMBER	NOT NULL	The proxy copy primary key 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 proxy copy record identifier from V$PROXY_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 proxy copy stamp from V$PROXY_DATAFILE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
TAG	VARCHAR2(32)		The tag for the proxy copy.
FILE#	NUMBER	NOT NULL	The absolute file number of the datafile that is proxy copied.
CREATION_CHANGE#	NUMBER	NOT NULL	The datafile creation SCN.
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_LEVEL	NUMBER		0 if this copy is part of an incremental backup strategy, otherwise NULL.
CHECKPOINT_CHANGE#	NUMBER	NOT NULL	Checkpoint SCN when the copy was made.
CHECKPOINT_TIME	DATE	NOT NULL	Checkpoint time when the copy was made.
ABSOLUTE_FUZZY_CHANGE#	NUMBER		The highest SCN in any block of the file, if known.
RECOVERY_FUZZY_CHANGE#	NUMBER		The SCN to which recovery must proceed for the file to become not fuzzy. If not NULL, this file must be recovered at least to the specified SCN before the database can be opened with this file.
RECOVERY_FUZZY_TIME	DATE		The timestamp to which recovery must proceed for the file to become not fuzzy. If not NULL, this file must be recovered at least to the specified time before the database can be opened with this file.
ONLINE_FUZZY	VARCHAR2(3)		YES/NO. If set to YES, this copy was made after a crash or offline immediate (or is a copy of a copy which was taken improperly while the database was open). Recovery will need to apply all redo up to the next crash recovery marker to make the file consistent.
BACKUP_FUZZY	VARCHAR2(3)		YES/NO. If set to YES, this is a copy taken using the BEGIN BACKUP/END BACKUP technique. To make this copy consistent, Recovery will need to apply all redo up to the marker that is placed in the redo stream when the ALTER TABLESPACE END BACKUP command is used.
BLOCKS	NUMBER	NOT NULL	Size of the datafile copy in blocks (also the size of the datafile when the copy was made).
BLOCK_SIZE	NUMBER	NOT NULL	The block size for the copy in bytes.
DEVICE_TYPE	VARCHAR2(255)	NOT NULL	The type of sequential media device.
HANDLE	VARCHAR2(1024)	NOT NULL	The filename for the proxy copy. It is the value that RMAN passes to the OSD layer that identifies the file.
COMMENTS	VARCHAR2(255)		Comments about the proxy copy.
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 proxy copy is stored.
START_TIME	DATE	NOT NULL	The time when proxy copy was initiated.
COMPLETION_TIME	DATE	NOT NULL	The time when the proxy copy was completed.
ELAPSED_SECONDS	NUMBER		The duration of the proxy copy.
STATUS	VARCHAR2(1)	NOT NULL	The status of the backup set: A (available), U (unavailable), X (expired), or D (deleted).

RC_REDO_LOG

This view lists information about the online redo logs for all incarnations of the database.

Column	Datatype	NULL	Description
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.
THREAD#	NUMBER	NOT NULL	The number of the redo thread.
GROUP#	NUMBER	NOT NULL	The number of the online redo log group.
NAME	VARCHAR2(1024)	NOT NULL	The name of the online redo log file.

RC_REDO_THREAD

This view lists data about all redo threads for all incarnations of the database.

Column	Datatype	NULL	Description
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.
THREAD#	NUMBER	NOT NULL	The redo thread number for the database incarnation.
STATUS	VARCHAR2(1)	NOT NULL	The status of the redo thread: D (disabled), E (enabled), or O (open).
SEQUENCE#	NUMBER	NOT NULL	The last allocated log sequence number.
ENABLE_CHANGE#	NUMBER		The SCN at which this thread was enabled.
ENABLE_TIME	DATE		The time at which this thread was enabled.
DISABLE_CHANGE#	NUMBER		The SCN of the last disabled thread.
DISABLE_TIME	DATE		The time of the last disabled thread.

RC_RESYNC

This view lists information about recovery catalog resynchronizations. Every full resynchronization takes a snapshot of the target database control file and resynchronizes the recovery catalog from the snapshot.

Column	Datatype	NULL	Description
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.
RESYNC_KEY	NUMBER	NOT NULL	The primary key for the resynchronization.
CONTROLFILE_CHANGE#	NUMBER	NOT NULL	The control file checkpoint SCN from which the catalog was resynchronized.
CONTROLFILE_TIME	DATE		The control file checkpoint timestamp from which the catalog was resynchronized.
CONTROLFILE_SEQUENCE#	NUMBER	NOT NULL	The control file sequence number.
CONTROLFILE_VERSION	DATE	NOT NULL	The creation time for the version of the control file from which the catalog was resynchronized.
RESYNC_TYPE	VARCHAR2(7)	NOT NULL	The type of resynchronization: FULL or PARTIAL.
DB_STATUS	VARCHAR2(7)		The status of the target database: OPEN or MOUNTED.
RESYNC_TIME	DATE	NOT NULL	The time of the resynchronization.

RC_STORED_SCRIPT

This view lists information about scripts stored in the recovery catalog. The view contains one row for each stored script.

Column Datatype NULL Description

DB_KEY

NUMBER

NOT NULL

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

DB_NAME

VARCHAR2(8)

NOT NULL

The DB_NAME of the database incarnation to which this record belongs.

SCRIPT_NAME

VARCHAR2(100)

NOT NULL

The name of the script.

Column	Datatype	NULL	Description
DB_KEY	NUMBER	NOT NULL	The primary key for the database that owns this script. Use this column to form a join with almost any other catalog view.
DB_NAME	VARCHAR2(8)	NOT NULL	The DB_NAME of the database incarnation to which this record belongs.
SCRIPT_NAME	VARCHAR2(100)	NOT NULL	The name of the script.

RC_STORED_SCRIPT_LINE

This view lists information about lines of the scripts stored in the recovery catalog. The view contains one row for each line of each stored script.

Column Datatype NULL Description

DB_KEY

NUMBER

NOT NULL

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

SCRIPT_NAME

VARCHAR2(100)

NOT NULL

The name of the stored script.

LINE

NUMBER

NOT NULL

The number of the line in the script. The line of a script is uniquely identified by SCRIPT_NAME and LINE.

TEXT

VARCHAR2(1024)

NOT NULL

The text of the line of the script.

Column	Datatype	NULL	Description
DB_KEY	NUMBER	NOT NULL	The primary key for the database that owns this script. Use this column to form a join with almost any other catalog view.
SCRIPT_NAME	VARCHAR2(100)	NOT NULL	The name of the stored script.
LINE	NUMBER	NOT NULL	The number of the line in the script. The line of a script is uniquely identified by SCRIPT_NAME and LINE.
TEXT	VARCHAR2(1024)	NOT NULL	The text of the line of the script.

RC_TABLESPACE

This view lists information about all tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old database incarnations. It corresponds to the V$TABLESPACE dynamic performance view. The current value is shown for tablespace attributes.

12Recovery Catalog Views