3
Recovery Catalog Views

This chapter contains descriptions of recovery catalog views. You can only access these views if you have created a recovery catalog. For a summary of the recovery catalog views, refer to "Summary of RMAN Recovery Catalog Views".

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

Summary of RMAN Recovery Catalog Views

The following table provides a functional summary of RMAN recovery catalog views.

Table 3-1 Recovery Catalog Views

Recovery Catalog View	Corresponding V$ View	Description of Recovery Catalog View
RC_ARCHIVED_LOG	V$ARCHIVED_LOG	Contains historical information about archived and unarchived redo logs.
RC_BACKUP_CONTROLFILE	V$BACKUP_DATAFILE	Lists information about control files in backup sets.
RC_BACKUP_CORRUPTION	V$BACKUP_CORRUPTION	Lists corrupt block ranges in datafile backups.
RC_BACKUP_DATAFILE	V$BACKUP_DATAFILE	Lists information about datafiles in backup sets.
RC_BACKUP_PIECE	V$BACKUP_PIECE	Lists information about backup pieces.
RC_BACKUP_REDOLOG	V$BACKUP_REDOLOG	Lists information about archived redo logs in backup sets.
RC_BACKUP_SET	V$BACKUP_SET	Lists information about backup sets for all incarnations of the database.
RC_CHECKPOINT		Deprecated in favor of RC_RESYNC.
RC_CONTROLFILE_COPY	V$DATAFILE_COPY	Lists information about control file copies on disk.
RC_COPY_CORRUPTION	V$COPY_CORRUPTION	Lists information about control file copies on disk.
RC_DATABASE	V$DATABASE	Lists information about the databases registered in the recovery catalog.
RC_DATABASE_INCARNATION	V$DATABASE (contains only current incarnation and one previous incarnation)	Lists information about all database incarnations registered in the recovery catalog.
RC_DATAFILE	V$DATAFILE	Lists information about all datafiles registered in the recovery catalog.
RC_DATAFILE_COPY	V$DATAFILE_COPY	Lists information about datafile copies on disk.
RC_LOG_HISTORY	V$LOG_HISTORY	Lists historical information about the online redo logs.
RC_OFFLINE_RANGE	V$OFFLINE_RANGE	Lists the offline ranges for datafiles.
RC_PROXY_CONTROLFILE	V$PROXY_DATAFILE	Lists control file backups that were taken using the proxy copy functionality.
RC_PROXY_DATAFILE	V$PROXY_DATAFILE	Lists datafile backups that were taken using the proxy copy functionality.
RC_REDO_LOG	V$LOG and V$LOGFILE	Lists the online redo logs for all incarnations of the database since the last catalog resynchronization.
RC_REDO_THREAD	V$THREAD	Lists all redo threads for all incarnations of the database since the last catalog resynchronization.
RC_RESYNC	n/a	Lists information about recovery catalog resynchronizations.
RC_RMAN_CONFIGURATION	V$RMAN_CONFIGURATION	Lists information about RMAN persistent configuration settings.
RC_STORED_SCRIPT	n/a	Lists information about RMAN persistent configuration settings.
RC_STORED_SCRIPT_LINE	n/a	Lists information about lines of the scripts stored in the recovery catalog.
RC_TABLESPACE	V$TABLESPACE	Lists all tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations.