Recovery Catalog Data Dictionary Views

Lesson 8	Recovery catalog data dictionary views
Objective	Use the Oracle Supplied Data Dictionary Views

Use Oracle Supplied Data Dictionary Views

Those who have worked with Oracle databases for some time have come to expect a few useful views in the data dictionary for any feature of the Oracle database. So it comes as no surprise to learn that 22 views are related to Recovery Manager. These views are created by the catrman.sql script and are created in the recovery catalog owner's schema.The table below identifies all 21 views for you.

View	Description
rc_database	Information about databases and their current incarnations
rc_database_incarnations	Information about all incarnations registered in the recovery catalog
rc_resync	Information about recovery catalog resynchronizations
rc_tablespace	Information about all tablespaces registered in the recovery catalog
rc_datafile	Information about all data files registered in the recovery catalog
rc_redo_thread	Information about redo threads
rc_redo_log	Information about online redo logs
rc_log_history	Information about redo log history
rc_archived_log	Information about all archive logs
rc_backup_set	Information about backup sets
rc_backup_piece	Information about backup pieces
rc_backup_datafile	Information about data file backups (in backup sets)
rc_backup_controlfile	Information about backup control files in backup sets
rc_datafile_copy	Information about datafile copies on disk
rc_controlfile_copy	Information about controlfile copies on disk.
rc_backup_redolog	Information about about archived redo logs in backup sets.
rc_backup_corruption	Information about corrupt blocks in data file backups
rc_copy_corruption	Information about corrupt blocks in data file copies
c_offline_range	Information about offline ranges for data files
rc_stored_script	Information about stored scripts
rc_stored_script_line	Information about stored scripts

You will use only a few views during the course of your normal DBA day. Below are the three frequently used views and for the sake of illustration, you will be connecting to your recovery catalog as the user rman.

rc_database
rc_tablespace
rc_datafile

rc_database

SQL> select * from rc_database;
DB_KEY DBINC_KEY   DBID    NAME     RESETLOGS_CHANGE#   RESETLOGS
----   --------   -----   -----    -------------       ---------
1       2        1.018E+09 ORC1         22290           03-JAN-00

Oracle Backup Recovery

rc_tablespace

SQL> select db_key, dbinc_key, db_name, ts#, name from rc_tablespace;
DB_KEY  DBINC_KEY  DB_NAME   TS#   NAME
-----   ---------  -------   ----  ------------------
1            2     ORC1       6    RECOVER
1            2     ORC1       2    ROLLBACK_DATA
1            2     ORC1       0    SYSTEM
1            2     ORC1       3    TEMPORARY_DATA
1            2     ORC1       1    USER_DATA

rc_datafile

SQL> select  db_name, ts#, tablespace_name, file#, name from rc_datafile;
DB_NAME TS#  TABLESPACE_NAME FILE#     NAME
------  ---  --------------  --------  --------------------
ORC1    0    SYSTEM          1   C:\ORACLE8\DATABASE\SYS1ORC1.ORA
ORC1    1    USER_DATA       2   C:\ORACLE8\DATABASE\USR1ORC1.ORA
ORC1    2    ROLLBACK_DATA   3   C:\ORACLE8\DATABASE\RBS1ORC1.ORA
ORC1    3    TEMPORARY_DATA  4   C:\ORACLE8\DATABASE\TMP1ORC1.ORA
ORC1    6    RECOVER         5   C:\ORACLE8\DATABASE\RCVORC1.ORA