Summary of RMAN Recovery Catalog Views

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

Table 5-1 Recovery Catalog Views

Recovery Catalog View	Corresponding V$ View	Catalog View Describes ...
`RC_ARCHIVED_LOG`	`V$ARCHIVED_LOG`	Archived and unarchived redo log files
`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_DATAFILE`	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 log files 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 server parameter file backups for Enterprise Manager
`RC_BACKUP_SPFILE_SUMMARY`	`V$BACKUP_SPFILE_SUMMARY`	Summary of information about server parameter file backups for Enterprise Manager
`RC_CHECKPOINT`	n/a	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_ARCHIVELOG_DETAILS`	`V$PROXY_ARCHIVELOG_DETAILS`	Details about proxy archived redo log files for Enterprise Manager
`RC_PROXY_ARCHIVELOG_SUMMARY`	`V$PROXY_ARCHIVELOG_SUMMARY`	Summary of information about proxy archived redo log files for Enterprise Manager
`RC_PROXY_CONTROLFILE`	`V$PROXY_DATAFILE`	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_RESTORE_POINT`	`V$RESTORE_POINT`	All restore points 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$RMAN_BACKUP_TYPE`	Used internally by Enterprise Manager
`RC_RMAN_CONFIGURATION`	`V$RMAN_CONFIGURATION`	RMAN configuration settings
`RC_RMAN_OUTPUT`	`V$RMAN_OUTPUT`	Output from RMAN commands for use in Enterprise Manager
`RC_RMAN_STATUS`	`V$RMAN_STATUS`	Historical status information about RMAN operations.
`RC_SITE`	n/a	Databases in a Data Guard environment
`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