Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)

E10643-07
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 data file image copy backups for Enterprise Manager

RC_BACKUP_COPY_SUMMARY

V$BACKUP_COPY_SUMMARY

Summary of information about data file image copy backups for Enterprise Manager

RC_BACKUP_CORRUPTION

V$BACKUP_CORRUPTION

Corrupt block ranges in data file backups

RC_BACKUP_DATAFILE

V$BACKUP_DATAFILE

Data files in backup sets

RC_BACKUP_DATAFILE_DETAILS

V$BACKUP_DATAFILE_DETAILS

Details about data file backups for Enterprise Manager

RC_BACKUP_DATAFILE_SUMMARY

V$BACKUP_DATAFILE_SUMMARY

Summary of information about data file 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 data file 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

Data files registered in the recovery catalog

RC_DATAFILE_COPY

V$DATAFILE_COPY

Data file 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 data files

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 data file proxy copies for Enterprise Manager

RC_PROXY_COPY_SUMMARY

V$PROXY_COPY_SUMMARY

Summary of information about data file proxy copies for Enterprise Manager

RC_PROXY_DATAFILE

V$PROXY_DATAFILE

Data file 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 temp files registered in the recovery catalog

RC_UNUSABLE_BACKUPFILE_DETAILS

V$UNUSABLE_BACKUPFILE_DETAILS

Unusable backup files registered in the recovery catalog