RMAN Catalog Views

Recovery Catalog View Corresponding V$ View Catalog View Describes
RC_ARCHIVED_LOG
V$ARCHIVED_LOG

Archived and unarchived redo logsRC_BACKUP_CONTROLFILE
V$BACKUP_DATAFILE

Control files in backup setsRC_BACKUP_CORRUPTION
V$BACKUP_CORRUPTION

Corrupt block ranges in datafile backupsRC_BACKUP_DATAFILE
V$BACKUP_DATAFILE

Datafiles in backup setsRC_BACKUP_FILES
V$BACKUP_FILES
 RMAN backups and copies in the repository.RC_BACKUP_PIECE
V$BACKUP_PIECE

Backup piecesRC_BACKUP_REDOLOG
V$BACKUP_REDOLOG

Archived logs in backups
RC_BACKUP_SET
V$BACKUP_SET

Backup sets
RC_BACKUP_SPFILE
V$BACKUP_SPFILE

Server parameter files in backup sets
RC_CONTROLFILE_COPY
V$DATAFILE_COPY

Control file copies on disk
RC_COPY_CORRUPTION
V$COPY_CORRUPTION

Control file copies on disk
RC_DATABASE
V$DATABASE

Databases registered in the recovery catalog (RC_DATABASE) or information about the currently
mounted database (V$DATABASE)
RC_DATABASE_BLOCK_CORRUPTION
V$DATABASE_BLOCK_CORRUPTION

Database blocks marked as corrupt in the most recent RMAN backup or copy
RC_DATABASE_INCARNATION
V$DATABASE_INCARNATION

All database incarnations registered in the catalog
RC_DATAFILE
V$DATAFILE

All datafiles registered in the recovery catalog
RC_DATAFILE_COPY
V$DATAFILE_COPY

Datafile image copies
RC_LOG_HISTORY
V$LOG_HISTORY

Historical information about online redo logs
RC_OFFLINE_RANGE
V$OFFLINE_RANGE

Offline ranges for datafiles
RC_PROXY_ARCHIVEDLOG
V$PROXY_ARCHIVEDLOG

Archived log backups created by proxy copy
RC_PROXY_CONTROLFILE
V$PROXY_DATAFILE

Control file backups created by proxy copy
RC_PROXY_DATAFILE
V$PROXY_DATAFILE

Datafile backups created by proxy copy
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_CONFIGURATION
V$RMAN_CONFIGURATION

RMAN persistent configuration settings
RC_TABLESPACE
V$TABLESPACE

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