Skip Headers
Oracle® Database Recovery Manager Reference
10g Release 2 (10.2)

Part Number B14194-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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