Recovery Catalog   «Prev  Next»

Recovery Catalog Data Dictionary Views

Lesson 8Recovery catalog data dictionary views
ObjectiveUse 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_databaseInformation 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.
  1. rc_database
  2. rc_tablespace
  3. 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