Recovery Catalog Views

The below views are some helpful recovery catalog views.
They exist in the catalog schema.

RC_DATABASE (V$DATABASE)

lists basic information about each database registered in the catalog.

select DB_KEY, dbid, name,DBINC_KEY, RESETLOGS_CHANGE#, RESETLOGS_TIME
from rc_database;

RC_ARCHIVED_LOG (V$ARCHIVED_LOG in target db)

Holds information about archive logs that have been generated by target
databases

column name for a50
column completion_time for a25
alter session set nls_date_format='DD-MON-YYYY:HH24:MI:SS';
select name , sequence#, status, completion_time
from rc_archived_log;

RC_BACKUP_CONTROLFILE (V$BACKUP_CONTROLFILE)

Provides information on backups taken of your control file.

select file#, creation_time, resetlogs_time,
blocks, block_size, controlfile_type
from v$backup_datafile where file#=0;

column completion_time for a25
column autobackup_date for a25
select db_name, status, completion_time, controlfile_type,
autobackup_date from rc_backup_controlfile;

RC_BACKUP_CORRUPTION (V$BACKUP_CORRUPTION)

Lists the curruption that exists in datafile backups. It does not list corruptio
n in the database.

select db_name, piece#, file#, block#, blocks, corruption_type
from rc_backup_CORRUPTION;

RC_BACKUP_DATAFILE (V$BACKUP_DATAFILE)

shows information about datafiles that exist in backup sets

select rcbd.DB_NAME, rcbd.FILE#, name, rcbd.BS_KEY
from RC_BACKUP_DATAFILE rcbd, rc_datafile rcd
where rcbd.db_key = rcd.db_key and rcbd.FILE# = rcd.FILE#
order by rcbd.BS_KEY;

RC_BACKUP_PIECE (V$BACKUP_PIECE)

information about specific backup pieces that have been created by a normal back
up.

RC_BACKUP_REDOLOG (V$BACKUP_REDOLOG)

This view holds information about archived logs that have been backed up, not re
do logs (cause we dont backup redo logs).

alter session set nls_date_format='DD-MON-YYYY:HH24:MI:SS';
select db_name, bs_key, sequence#, thread#, first_change#, status
from rc_backup_redolog;

RC_BACKUP_SPFILE (V$BACKUP_SPFILE)

Spfile backups that exist in backupset


RC_DATABASE_BLOCK_CORRUPTION (V$DATABASE_BLOCK_CORRUPTION)

This view provides the corruption list that is populated when a backup or backup
validate operation is performed.
the corrupt blocks are in the database and not in the backups.

select file#, block#, corruption_type
from RC_DATABASE_BLOCK_CORRUPTION;

RC_DATABASE_INCARNATION (V$DATABASE_INCARNATION)

Contains a record for each incarnation of each database registered in he catalog
.

select dbid, name, dbinc_key, resetlogs_time, current_incarnation
from rc_database_incarnation;

RC_OFFLINE_RANGE (V$OFFLINE_RANGE)

Offline ranges set the parameters for when a datafile went offline or read-only,
and when it came back online or read-write.
It is important to know when a datafile went offline and back online again.

RC_RESYNC

Provides information for each catalog resync operation that occurs

select db_name, controlfile_time, controlfile_sequence#,
resync_type, resync_time
from rc_resync;

RC_RMAN_CONFIGURATION (V$_RMAN_CONFIGURATION)

holds each cofiguration parameter that is set for a target database.
Same as the show all command.

select db_key, name, value
from RC_RMAN_CONFIGURATION;

******************************************
keywords: catalog rc
******************************************
rdbms version: 11g
******************************************