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_ARCHIVELOG_DETAILS	`V$BACKUP_ARCHIVELOG_DETAILS`	Details about archived redo log backups for Enterprise Manager
RC_BACKUP_ARCHIVELOG_SUMMARY	`V$BACKUP_ARCHIVELOG_SUMMARY`	Summary of information about archived redo log backups for Enterprise Manager
RC_BACKUP_CONTROLFILE	`V$BACKUP_CONTROLFILE`	Control files backed up in backup sets
RC_BACKUP_CONTROLFILE_DETAILS	`V$BACKUP_CONTROLFILE_DETAILS`	Details about control file backups for Enterprise Manager
RC_BACKUP_CONTROLFILE_SUMMARY	`V$BACKUP_CONTROLFILE_SUMMARY`	Summary of information about control file backups for Enterprise Manager
RC_BACKUP_COPY_DETAILS	`V$BACKUP_COPY_DETAILS`	Details about datafile image copy backups for Enterprise Manager
RC_BACKUP_COPY_SUMMARY	`V$BACKUP_COPY_SUMMARY`	Summary of information about datafile image copy backups for Enterprise Manager
RC_BACKUP_CORRUPTION	`V$BACKUP_CORRUPTION`	Corrupt block ranges in datafile backups
RC_BACKUP_DATAFILE	`V$BACKUP_DATAFILE`	Datafiles in backup sets
RC_BACKUP_DATAFILE_DETAILS	`V$BACKUP_DATAFILE_DETAILS`	Details about datafile backups for Enterprise Manager
RC_BACKUP_DATAFILE_SUMMARY	`V$BACKUP_DATAFILE_SUMMARY`	Summary of information about datafile backups for Enterprise Manager
RC_BACKUP_FILES	`V$BACKUP_FILES`	RMAN backups and copies known to the repository.
RC_BACKUP_PIECE	`V$BACKUP_PIECE`	Backup pieces
RC_BACKUP_PIECE_DETAILS	`V$BACKUP_PIECE_DETAILS`	Details about backup pieces for Enterprise Manager
RC_BACKUP_REDOLOG	`V$BACKUP_REDOLOG`	Archived redo logs in backup sets
RC_BACKUP_SET	`V$BACKUP_SET`	Backup sets for all incarnations of databases registered in the catalog
RC_BACKUP_SET_DETAILS	`V$BACKUP_SET_DETAILS`	Details about backup sets for Enterprise Manager
RC_BACKUP_SET_SUMMARY	`V$BACKUP_SET_SUMMARY`	Summary of information about backup sets for Enterprise Manager
RC_BACKUP_SPFILE	`V$BACKUP_SPFILE`	Server parameter files in backups
RC_BACKUP_SPFILE_DETAILS	`V$BACKUP_SPFILE_DETAILS`	Details about SPFILE backups for Enterprise Manager
RC_BACKUP_SPFILE_SUMMARY	`V$BACKUP_SPFILE_SUMMARY`	Summary of information about SPFILE backups for Enterprise Manager
RC_CHECKPOINT	n/a	Deprecated in favor of RC_RESYNC
RC_CONTROLFILE_COPY	`V$CONTROLFILE_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_RMAN_OUTPUT	`V$RMAN_OUTPUT`	Output from RMAN commands for use in Enterprise Manager
RC_PROXY_ARCHIVEDLOG	`V$PROXY_ARCHIVEDLOG`	Archived log backups taken with the proxy copy functionality
RC_PROXY_ARCHIVELOG_DETAILS	`V$PROXY_ARCHIVELOG_DETAILS`	Details about proxy archived redo logs for Enterprise Manager
RC_PROXY_ARCHIVELOG_SUMMARY	`V$PROXY_ARCHIVELOG_SUMMARY`	Summary of information about proxy archived redo logs for Enterprise Manager
RC_PROXY_CONTROLFILE	`V$PROXY_CONTROLFILE`	Control file backups taken with the proxy copy functionality
RC_PROXY_COPY_DETAILS	`V$PROXY_COPY_DETAILS`	Details about datafile proxy copies for Enterprise Manager
RC_PROXY_COPY_SUMMARY	`V$PROXY_COPY_SUMMARY`	Summary of information about datafile proxy copies for Enterprise Manager
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_BACKUP_JOB_DETAILS	`V$RMAN_BACKUP_JOB_DETAILS`	Details about backup jobs for Enterprise Manager
RC_RMAN_BACKUP_SUBJOB_DETAILS	`V$RMAN_BACKUP_SUBJOB_DETAILS`	Details about backup subjobs for Enterprise Manager
RC_RMAN_BACKUP_TYPE	`V$BACKUP_TYPE`	Used internally by Enterprise Manager
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
RC_TEMPFILE	`V$TEMPFILE`	All tempfiles registered in the recovery catalog
RC_UNUSABLE_BACKUPFILE_DETAILS	`V$UNUSABLE_BACKUPFILE_DETAILS`	Unusable backup files registered in the recovery catalog