11 Backup and Recovery Views

The following table describes views you can use to query the RMAN repository. The V$ views reflect the RMAN repository as stored in the database control file, and the recovery catalog views reflect the RMAN repository as stored in the recovery catalog.

Refer to the Oracle Database Reference for details on V$ views, and Oracle Database Backup and Recovery Reference for details on recovery catalog views.

Control File V$ View	Recovery Catalog View	View Describes
`V$ARCHIVED_LOG`	`RC_ARCHIVED_LOG`	Archived and unarchived redo logs
`V$BACKUP_DATAFILE`	`RC_BACKUP_CONTROLFILE`	Control files in backup sets
`V$BACKUP_CORRUPTION`	`RC_BACKUP_CORRUPTION`	Corrupt block ranges in datafile backups
`V$BACKUP_DATAFILE`	`RC_BACKUP_DATAFILE`	Datafiles in backup sets
`V$BACKUP_FILES`	`RC_BACKUP_FILES`	RMAN backups and copies in the repository.
`V$BACKUP_PIECE`	`RC_BACKUP_PIECE`	Backup pieces
`V$BACKUP_REDOLOG`	`RC_BACKUP_REDOLOG`	Archived logs in backups
`V$BACKUP_SET`	`RC_BACKUP_SET`	Backup sets
`V$BACKUP_SPFILE`	`RC_BACKUP_SPFILE`	Server parameter files in backup sets
`V$DATAFILE_COPY`	`RC_CONTROLFILE_COPY`	Control file copies on disk
`V$COPY_CORRUPTION`	`RC_COPY_CORRUPTION`	Information about datafile copy corruptions
`V$DATABASE`	`RC_DATABASE`	Databases registered in the recovery catalog (`RC_DATABASE`) or information about the currently mounted database (`V$DATABASE)`
`V$DATABASE_BLOCK_CORRUPTION`	`RC_DATABASE_BLOCK_CORRUPTION`	Database blocks marked as corrupt in the most recent RMAN backup or copy
`V$DATABASE_INCARNATION`	`RC_DATABASE_INCARNATION`	All database incarnations registered in the catalog
`V$DATAFILE`	`RC_DATAFILE`	All datafiles registered in the recovery catalog
`V$DATAFILE_COPY`	`RC_DATAFILE_COPY`	Datafile image copies
`V$LOG_HISTORY`	`RC_LOG_HISTORY`	Historical information about online redo logs
`V$OFFLINE_RANGE`	`RC_OFFLINE_RANGE`	Offline ranges for datafiles
`V$PROXY_ARCHIVEDLOG`	`RC_PROXY_ARCHIVEDLOG`	Archived log backups created by proxy copy
`V$PROXY_CONTROLFILE`	`RC_PROXY_CONTROLFILE`	Control file backups created by proxy copy
`V$PROXY_DATAFILE`	`RC_PROXY_DATAFILE`	Datafile backups created by proxy copy
`V$LOG` and `V$LOGFILE`	`RC_REDO_LOG`	Online redo logs for all incarnations of the database since the last catalog resynchronization
`V$THREAD`	`RC_REDO_THREAD`	All redo threads for all incarnations of the database since the last catalog resynchronization
n/a	`RC_RESYNC`	Recovery catalog resynchronizations
`V$RMAN_CONFIGURATION`	`RC_RMAN_CONFIGURATION`	RMAN persistent configuration settings
`V$TABLESPACE`	`RC_TABLESPACE`	All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations