3.1 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