Summary of RMAN Recovery Catalog Views

5.1 Summary of RMAN Recovery Catalog Views

RMAN recovery catalog views store information about backups of all databases that are registered with the recovery catalog.

Note:

A multitenant container database is the only supported architecture in Oracle Database 21c and later releases. While the documentation is being revised, legacy terminology may persist. In most cases, "database" and "non-CDB" refer to a CDB or PDB, depending on context. In some contexts, such as upgrades, "non-CDB" refers to a non-CDB from a previous release.

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_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_CMD_STATISTICS`	n/a	Historical information about a recovery catalog upgrade
`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_DISK_RESTORE_RANGE`	`V$DISK_RESTORE_RANGE`	Details about the restore range of the database for backup data stored 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_PDBS`	`V$PDBS`	Pluggable databases (PDBs) registered in the recovery catalog
`RC_PLUGGABLE_DATABASE_INC`	`V$PDB_INCARNATION`	PDB incarnations registered in the recovery catalog
`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_RESTORE_RANGE`	`V$RESTORE_RANGE`	Details about the restore range of databases registered in the recovery catalog
`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_SBT_RESTORE_RANGE`	`V$SBT_RESTORE_RANGE`	Details about the restore range of the database for backup data stored on tape
`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