Database Backup and Recovery Reference
ContentsOpens a new window
Opens a new window
Page 87 of 152

5 Recovery Catalog Views

This chapter contains descriptions of recovery catalog views. You can only access these views if you have created a recovery catalog (see CREATE CATALOGOpens a new window). For a summary of the recovery catalog views, refer to "Summary of RMAN Recovery Catalog Views"Opens a new window.

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.

5.1 Summary of RMAN Recovery Catalog Views

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

Note:

The data type of some recovery catalog view columns is listed as VARCHAR2(4000). This length for VARCHAR2 columns is applicable when the initialization parameter VARCHAR2_MAX_SIZE is set to LEGACY. If you set the value of VARCHAR2_MAX_SIZE to 32767, the columns with data type listed as VARCHAR2(4000) will be VARCHAR2(32767).

Table 5-1 Recovery Catalog Views

Recovery Catalog View Corresponding V$ View Catalog View Description

RC_ARCHIVED_LOGOpens a new window

V$ARCHIVED_LOGOpens a new window

Archived and unarchived redo log files

RC_BACKUP_ARCHIVELOG_DETAILSOpens a new window

V$BACKUP_ARCHIVELOG_DETAILSOpens a new window

Details about archived redo log backups for Enterprise Manager

RC_BACKUP_ARCHIVELOG_SUMMARYOpens a new window

V$BACKUP_ARCHIVELOG_SUMMARYOpens a new window

Summary of information about archived redo log backups for Enterprise Manager

RC_BACKUP_CONTROLFILEOpens a new window

V$BACKUP_DATAFILEOpens a new window

Control files backed up in backup sets

RC_BACKUP_CONTROLFILE_DETAILSOpens a new window

V$BACKUP_CONTROLFILE_DETAILSOpens a new window

Details about control file backups for Enterprise Manager

RC_BACKUP_CONTROLFILE_SUMMARYOpens a new window

V$BACKUP_CONTROLFILE_SUMMARYOpens a new window

Summary of information about control file backups for Enterprise Manager

RC_BACKUP_COPY_DETAILSOpens a new window

V$BACKUP_COPY_DETAILSOpens a new window

Details about data file image copy backups for Enterprise Manager

RC_BACKUP_COPY_SUMMARYOpens a new window

V$BACKUP_COPY_SUMMARYOpens a new window

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

RC_BACKUP_CORRUPTIONOpens a new window

V$BACKUP_CORRUPTIONOpens a new window

Corrupt block ranges in data file backups

RC_BACKUP_DATAFILEOpens a new window

V$BACKUP_DATAFILEOpens a new window

Data files in backup sets

RC_BACKUP_DATAFILE_DETAILSOpens a new window

V$BACKUP_DATAFILE_DETAILSOpens a new window

Details about data file backups for Enterprise Manager

RC_BACKUP_DATAFILE_SUMMARYOpens a new window

V$BACKUP_DATAFILE_SUMMARYOpens a new window

Summary of information about data file backups for Enterprise Manager

RC_BACKUP_FILESOpens a new window

V$BACKUP_FILESOpens a new window

RMAN backups and copies known to the repository.

RC_BACKUP_PIECEOpens a new window

V$BACKUP_PIECEOpens a new window

Backup pieces

RC_BACKUP_PIECE_DETAILSOpens a new window

V$BACKUP_PIECE_DETAILSOpens a new window

Details about backup pieces for Enterprise Manager

RC_BACKUP_REDOLOGOpens a new window

V$BACKUP_REDOLOGOpens a new window

Archived redo log files in backup sets

RC_BACKUP_SETOpens a new window

V$BACKUP_SETOpens a new window

Backup sets for all incarnations of databases registered in the catalog

RC_BACKUP_SET_DETAILSOpens a new window

V$BACKUP_SET_DETAILSOpens a new window

Details about backup sets for Enterprise Manager

RC_BACKUP_SET_SUMMARYOpens a new window

V$BACKUP_SET_SUMMARYOpens a new window

Summary of information about backup sets for Enterprise Manager

RC_BACKUP_SPFILEOpens a new window

V$BACKUP_SPFILEOpens a new window

Server parameter files in backups

RC_BACKUP_SPFILE_DETAILSOpens a new window

V$BACKUP_SPFILE_DETAILSOpens a new window

Details about server parameter file backups for Enterprise Manager

RC_BACKUP_SPFILE_SUMMARYOpens a new window

V$BACKUP_SPFILE_SUMMARYOpens a new window

Summary of information about server parameter file backups for Enterprise Manager

RC_CHECKPOINTOpens a new window

n/a

Deprecated in favor of RC_RESYNCOpens a new window

RC_CONTROLFILE_COPYOpens a new window

V$DATAFILE_COPYOpens a new window

Control file copies on disk

RC_COPY_CORRUPTIONOpens a new window

V$COPY_CORRUPTIONOpens a new window

Corrupt block ranges in data file copies

RC_DATABASEOpens a new window

V$DATABASEOpens a new window

Databases registered in the recovery catalog

RC_DATABASE_BLOCK_CORRUPTIONOpens a new window

V$DATABASE_BLOCK_CORRUPTIONOpens a new window

Database blocks marked as corrupted in the most recent RMAN backup or copy

RC_DATABASE_INCARNATIONOpens a new window

V$DATABASE_INCARNATIONOpens a new window

Database incarnations registered in the recovery catalog

RC_DATAFILEOpens a new window

V$DATAFILEOpens a new window

Data files registered in the recovery catalog

RC_DATAFILE_COPYOpens a new window

V$DATAFILE_COPYOpens a new window

Data file copies on disk

RC_DISK_RESTORE_RANGEOpens a new window

V$DISK_RESTORE_RANGE

Details about the restore range of the database for backup data stored on disk

RC_LOG_HISTORYOpens a new window

V$LOG_HISTORYOpens a new window

Online redo log history indicating when log switches occurred

RC_OFFLINE_RANGEOpens a new window

V$OFFLINE_RANGEOpens a new window

Offline ranges for data files

RC_PDBSOpens a new window

V$PDBSOpens a new window

Pluggable databases (PDBs) registered in the recovery catalog

RC_PLUGGABLE_DATABASE_INCOpens a new window

V$PDB_INCARNATION

PDB incarnations registered in the recovery catalog

RC_PROXY_ARCHIVEDLOGOpens a new window

V$PROXY_ARCHIVEDLOGOpens a new window

Archived log backups taken with the proxy copy functionality

RC_PROXY_ARCHIVELOG_DETAILSOpens a new window

V$PROXY_ARCHIVELOG_DETAILSOpens a new window

Details about proxy archived redo log files for Enterprise Manager

RC_PROXY_ARCHIVELOG_SUMMARYOpens a new window

V$PROXY_ARCHIVELOG_SUMMARYOpens a new window

Summary of information about proxy archived redo log files for Enterprise Manager

RC_PROXY_CONTROLFILEOpens a new window

V$PROXY_DATAFILEOpens a new window

Control file backups taken with the proxy copy functionality

RC_PROXY_COPY_DETAILSOpens a new window

V$PROXY_COPY_DETAILSOpens a new window

Details about data file proxy copies for Enterprise Manager

RC_PROXY_COPY_SUMMARYOpens a new window

V$PROXY_COPY_SUMMARYOpens a new window

Summary of information about data file proxy copies for Enterprise Manager

RC_PROXY_DATAFILEOpens a new window

V$PROXY_DATAFILEOpens a new window

Data file backups that were taken using the proxy copy functionality

RC_REDO_LOGOpens a new window

V$LOGOpens a new window and V$LOGFILEOpens a new window

Online redo logs for all incarnations of the database since the last catalog resynchronization

RC_REDO_THREADOpens a new window

V$THREADOpens a new window

All redo threads for all incarnations of the database since the last catalog resynchronization

RC_RESTORE_POINTOpens a new window

V$RESTORE_POINTOpens a new window

All restore points for all incarnations of the database since the last catalog resynchronization

RC_RESTORE_RANGEOpens a new window

V$RESTORE_RANGE

Details about the restore range of databases registered in the recovery catalog

RC_RESYNCOpens a new window

n/a

Recovery catalog resynchronizations

RC_RMAN_BACKUP_JOB_DETAILSOpens a new window

V$RMAN_BACKUP_JOB_DETAILSOpens a new window

Details about backup jobs for Enterprise Manager

RC_RMAN_BACKUP_SUBJOB_DETAILSOpens a new window

V$RMAN_BACKUP_SUBJOB_DETAILSOpens a new window

Details about backup subjobs for Enterprise Manager

RC_RMAN_BACKUP_TYPEOpens a new window

V$RMAN_BACKUP_TYPEOpens a new window

Used internally by Enterprise Manager

RC_RMAN_CONFIGURATIONOpens a new window

V$RMAN_CONFIGURATIONOpens a new window

RMAN configuration settings

RC_RMAN_OUTPUTOpens a new window

V$RMAN_OUTPUTOpens a new window

Output from RMAN commands for use in Enterprise Manager

RC_RMAN_STATUSOpens a new window

V$RMAN_STATUSOpens a new window

Historical status information about RMAN operations.

RC_SBT_RESTORE_RANGEOpens a new window

V$SBT_RESTORE_RANGE

Details about the restore range of the database for backup data stored on tape

RC_SITEOpens a new window

n/a

Databases in a Data Guard environment

RC_STORED_SCRIPTOpens a new window

n/a

Names of scripts stored in the recovery catalog

RC_STORED_SCRIPT_LINEOpens a new window

n/a

Contents of the scripts stored in the recovery catalog

RC_TABLESPACEOpens a new window

V$TABLESPACEOpens a new window

All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations

RC_TEMPFILEOpens a new window

V$TEMPFILEOpens a new window

All temp files registered in the recovery catalog

RC_UNUSABLE_BACKUPFILE_DETAILSOpens a new window

V$UNUSABLE_BACKUPFILE_DETAILSOpens a new window

Unusable backup files registered in the recovery catalog