1.

What Are The Most Important Recovery Catalog Views?

Answer»

Below are some of the frequently used views:

  • RC_STORED_SCRIPT: INFORMATION about RMAN scripts stored in the recovery catalog.
  • RC_UNUSABLE_BACKUPFILE_DETAILS: Lists the unusable backup FILES recorded in the recovery catalog.
  • RC_RMAN_STATUS: Similar to 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: Information about persistent configuration settings.
  • RC_DATAFILE: Shows all DATAFILES registered in the recovery catalog.
  • RC_DATABASE: Shows the databases registered in the recovery catalog.
  • RC_ARCHIVED_LOG: Provides historical information on both archived as well as unarchived redo logs.

Below are some of the frequently used views:



Discussion

No Comment Found