3
Recovery Catalog Views

This chapter contains descriptions of recovery catalog views. You can only access these views if you have created a recovery catalog. For a summary of the recovery catalog views, refer to "Summary of RMAN Recove ry Catalog Views".

Note:

These views are not normalized, but are optimized for RMAN usage. Hence, most catalog views have redundant values that result from joining of several underlying tables.< /p>

Summary of RMAN Recovery Catalog Views

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

Table 3-1 Recovery Catalog Views

< td class="Formal">

Corrupt block ranges in datafile copies

V$DATABASE

RC_DATAFILE

Recovery Catalog View	Corresponding V$ View	Catalog View Describes ...
RC_ARCHIVED_LOG	`V$ARCHIVED_LOG`	Archived and unarchived redo logs
RC_BACKUP_CONTROLFILE	`V$BA CKUP_DATAFILE`	Control files in backup sets
RC_BACKU P_CORRUPTION	`V$BACKUP_CORRUPTION`	Corrupt block ranges in datafile backups
RC_BACKUP_DATAFILE	`V$BACKUP_DATAFILE`	< p class="TB">Datafiles in backup sets
RC_BACKUP_FILES	`V$BACKUP_FILES`	RMAN backups and copies known to the repo sitory.
RC_BACKUP_PIECE	`V$BACKUP_PIECE`	Backup pieces
RC_BACKUP_REDOLOG	`V$BACKUP_REDOLOG`	Archived redo logs in backup sets
RC_BACKUP_SET	`V$BACKUP_SET`	Backup sets for all incarnations of the database
RC_BACKUP_SPFILE	`V$BACKUP_SPFILE`	Server parameter files in backups
RC_CHECKPOINT	Deprecated in favor of RC_RESYNC
RC_CONTROLFILE_COPY	`V$DATAFILE_COPY`	Control file copies on disk
RC_COPY_CORRUPTION	`V$COPY_CORRUPTION`
RC_DATABASE	Databases registered in the recovery catalog
< a name="77662"> 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
`V$DATAFILE`	Datafiles regis tered in the recovery catalog
RC_DATAFILE_COPY	`V$DATAFILE_COPY`	Datafile copies on disk
RC_LOG_HIS TORY	`V$LOG_HISTORY`	Online redo log history indicating when log switches occurred
RC_OFFLINE_RANGE	`V$OFFLINE_RANGE`	Offline ranges for datafiles
RC_PROXY_ARCHIVEDLOG	`V$PROXY_ARCHIVEDLOG`	Archived log backups t aken with the proxy copy functionality
RC_PROXY_CONTROLFILE	`V$PROXY_DATAFILE`	Control file backups taken with the proxy copy functionality
RC_PROXY_DATAFILE	`V$PROXY_DATAFILE`	Datafile backups that were taken using the pr oxy 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 incarn ations of the database since the last catalog resynchronization
RC_RESYNC	n/a	Recovery catalog resynchronizations
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 c atalog
RC_STORED_SCRIPT_LINE	n/a	Contents of the scripts stored in the recovery catalog
RC_TABLESPACE < /td>	`V$TABLESPACE`	All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old inca rnations

3 Recovery Catalog Views

Summary of RMAN Recovery Catalog Views

Table 3-1 Recovery Catalog Views

3
Recovery Catalog Views