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

The Oracle Recovery Manager (RMAN) provides a set of Data Dictionary Views that are crucial for managing and monitoring backup and recovery operations. The 20 most commonly used Data Dictionary Views in RMAN are:
  1. V$BACKUP_SET: Provides details about backup sets, including their creation times and statuses.
  2. V$BACKUP_PIECE: Contains information about individual backup pieces, such as their sizes and locations.
  3. V$BACKUP_DATAFILE: Shows details about datafile backups, including file numbers and backup times.
  4. V$BACKUP_REDOLOG: Displays information about the backup of redo log files.
  5. V$ARCHIVED_LOG: Lists details of archived redo logs, including their sequence numbers and destinations.
  6. V$BACKUP_CORRUPTION: Reports any corruptions detected during RMAN operations.
  7. V$DATAFILE: Contains data about all datafiles in the database, useful for verifying backups.
  8. V$RECOVERY_FILE_DEST: Provides information on the Fast Recovery Area, including space usage and limits.
  9. V$RMAN_BACKUP_JOB_DETAILS: Offers comprehensive details on RMAN backup jobs.
  10. V$RMAN_STATUS: Shows the status of RMAN operations, useful for monitoring and troubleshooting.
  11. V$RMAN_CONFIGURATION: Displays RMAN configuration settings.
  12. V$RMAN_OUTPUT: Contains output messages from RMAN sessions.
  13. V$DATABASE: Provides general information about the database, relevant for understanding the backup context.
  14. V$RECOVER_FILE: Lists files that need recovery.
  15. V$RMAN_BACKUP_TYPE: Describes the types of backups taken (full, incremental, etc.).
  16. V$LOG_HISTORY: Records the history of log switches, important for understanding redo log backups.
  17. V$PROXY_ARCHIVEDLOG: Gives details about proxy archived logs, if used in the backup strategy.
  18. V$BACKUP_FILES: Shows information about all RMAN backup files.
  19. V$RMAN_BACKUP_SUBJOB_DETAILS: Provides subjob-level details of RMAN backup jobs.
  20. V$CONTROLFILE_RECORD_SECTION: Offers insight into control file records, essential for backup integrity.
These views are integral to the administration of RMAN and provide vital insights into the backup and recovery processes, aiding in efficient database management and ensuring data safety.
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

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

SEMrush Software