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	Catalog View Describes ...
RC_ARCHIVED_LOG	`V$ARCHIVED_LOG`	Archived and unarchived redo logs
RC_BACKUP_CONTROLFILE	`V$BACKUP_DATAFILE`	Control files in backup sets
RC_BACKUP_CORRUPTION	`V$BACKUP_CORRUPTION`	Corrupt block ranges in datafile backups
RC_BACKUP_DATAFILE	`V$BACKUP_DATAFILE`	Datafiles in backup sets
RC_BACKUP_FILES	`V$BACKUP_FILES`	RMAN backups and copies known to the repository.
RC_BACKUP_PIECE	`V$BACKUP_PIECE`	Backup pieces
RC_BACKUP_REDOLOG	`V$BACKUP_REDOLOG`	Archived redo logs in backup sets
RC_BACKUP_SET	`V$BACKUP_SET`	Backup sets for all incarnations of the database
RC_BACKUP_SPFILE	`V$BACKUP_SPFILE`	Server parameter files in backups
RC_CHECKPOINT		Deprecated in favor of RC_RESYNC
RC_CONTROLFILE_COPY	`V$DATAFILE_COPY`	Control file copies on disk
RC_COPY_CORRUPTION	`V$COPY_CORRUPTION`	Corrupt block ranges in datafile copies
RC_DATABASE	`V$DATABASE`	Databases registered in the recovery catalog
RC_DATABASE_BLOCK_CORRUPTION	`V$DATABASE_BLOCK_CORRUPTION`	Database blocks marked as corrupted in the most recent RMAN backup or copy
RC_DATABASE_INCARNATION	`V$DATABASE_INCARNATION`	Database incarnations registered in the recovery catalog
RC_DATAFILE	`V$DATAFILE`	Datafiles registered in the recovery catalog
RC_DATAFILE_COPY	`V$DATAFILE_COPY`	Datafile copies on disk
RC_LOG_HISTORY	`V$LOG_HISTORY`	Online redo log history indicating when log switches occurred
RC_OFFLINE_RANGE	`V$OFFLINE_RANGE`	Offline ranges for datafiles
RC_PROXY_ARCHIVEDLOG	`V$PROXY_ARCHIVEDLOG`	Archived log backups taken with the proxy copy functionality
RC_PROXY_CONTROLFILE	`V$PROXY_DATAFILE`	Control file backups taken with the proxy copy functionality
RC_PROXY_DATAFILE	`V$PROXY_DATAFILE`	Datafile backups that were taken using the proxy copy functionality
RC_REDO_LOG	`V$LOG` and `V$LOGFILE`	Online redo logs for all incarnations of the database since the last catalog resynchronization
RC_REDO_THREAD	`V$THREAD`	All redo threads for all incarnations of the database since the last catalog resynchronization
RC_RESYNC	n/a	Recovery catalog resynchronizations
RC_RMAN_CONFIGURATION	`V$RMAN_CONFIGURATION`	RMAN configuration settings
RC_RMAN_STATUS	`V$RMAN_STATUS`	Historical status information about RMAN operations.
RC_STORED_SCRIPT	n/a	Names of scripts stored in the recovery catalog
RC_STORED_SCRIPT_LINE	n/a	Contents of the scripts stored in the recovery catalog
RC_TABLESPACE	`V$TABLESPACE`	All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations