4 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 and Enterprise Manager usage. Hence, most catalog views have redundant values that result from joining of several underlying tables.

The views intended for use by Enterprise Manager are generally less useful for direct querying than the other views.

Summary of RMAN Recovery Catalog Views

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

Table 4-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 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$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_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_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$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