Querying Recovery Catalog:

Recovery Catalog Performance Views :–

 There are many views that provide backup-related information. The most commonly used ones are the following dynamic performance views in the target database to obtain information about your backups:

• V$BACKUP_SET: Backup sets created
• V$BACKUP_PIECE: Backup pieces that exist
• V$DATAFILE_COPY: Copies of data files on disk
• V$BACKUP_FILES: Information about all files created when creating backups

If you are using a recovery catalog, you can query corresponding views that contain the same information for each target database registered in the recovery catalog database. The corresponding views have the same name, except that the “V$” is replaced with “RC_”. Also, they are in the schema owned by the recovery catalog owner.

For example, the corresponding views in the recovery catalog, showing the information shown above are:

RC_BACKUP_SET,  RC_BACKUP_PIECE, RC_DATAFILE_COPY, and RC_BACKUP_FILES.

The following are brief descriptions of the most important recovery catalog views:

RC_STORED_SCRIPT: This view lists information about RMAN scripts stored in the recovery catalog.

RC_UNUSABLE_BACKUPFILE_DETAILS: This view shows the unusable backup files recorded in the recovery catalog.

RC_RMAN_STATUS: This view is similar to the V$RMAN_STATUS view and shows the status of all RMAN operations.  This view doesn’t contain information about any operations that are currently executing.

RC_RMAN_CONFIGURATION: This view provides information about persistent configuration settings.

RC_DATAFILE: This view shows all data files registered in the recovery catalog.

RC_DATABASE: This view shows the databases registered in the recovery catalog.

RC_ARCHIVED_LOG: This view provides historical information on both archived as well as unarchived redo logs.

In order to query the RC_BACKUP_FILES view, you must first execute the following in the recovery catalog database ( i.e. catdb):

[oracle@airyhost ~]$ . oraenv

ORACLE_SID = [ORCL] ? catdb

[oracle@airyhost ~]$ sqlplus / as sysdba

 SQL> CALL DBMS_RCVMAN.SETDATABASE(null,null,null,<dbid>);

SQL> CALL DBMS_RCVMAN.SETDATABASE(null,null,null, 1417825656);

 where <dbid> is the database ID of a target database (ORCL).

 SQL> connect cat/cat;

Connected.

SQL> desc RC_BACKUP_PIECE;

 Name                         Null?                     Type

 ----------------------------------------- -------- ----------------------------  

 DB_KEY                       NOT NULL                  NUMBER

 DB_ID                        NOT NULL                  NUMBER

 BP_KEY                       NOT NULL                  NUMBER

 RECID                        NOT NULL                  NUMBER

 STAMP                        NOT NULL                  NUMBER

 BS_KEY                       NOT NULL                  NUMBER

 SET_STAMP                    NOT NULL                  NUMBER

 SET_COUNT                    NOT NULL                  NUMBER

 BACKUP_TYPE                                            VARCHAR2(1)

 INCREMENTAL_LEVEL                                      NUMBER

 PIECE#                       NOT NULL                  NUMBER

 COPY#                        NOT NULL                  NUMBER

 DEVICE_TYPE                  NOT NULL                  VARCHAR2(255)

 HANDLE                       NOT NULL                  VARCHAR2(1024)

 COMMENTS                                               VARCHAR2(255)

 MEDIA                                                  VARCHAR2(80)

 MEDIA_POOL                                             NUMBER

 CONCUR                                                 VARCHAR2(3)

 TAG                                                    VARCHAR2(32)

 START_TIME                   NOT NULL                  DATE

 COMPLETION_TIME              NOT NULL                  DATE

 ELAPSED_SECONDS                                        NUMBER

 STATUS                       NOT NULL                 VARCHAR2(1)

 BYTES                                                  NUMBER

 IS_RECOVERY_DEST_FILE        NOT NULL                  VARCHAR2(3)

 RSR_KEY                                                NUMBER

 COMPRESSED                                             VARCHAR2(3)

 SITE_KEY                                               NUMBER

 ENCRYPTED                                              VARCHAR2(3)

 BACKED_BY_OSB                                          VARCHAR2(3)

Thank you for Reading…This is Airy… Enjoy 

Also Read Related Links:

1: What is RMAN Recovery Catalog

2: RMAN Base Recovery Catalog Creation 

#dbms_rcvman