Catalog Maintenance   «Prev  Next»

Lesson 1

Oracle Recovery Catalog Maintenance Basics

The basic concepts of (RMAN) Recovery Manager and how to create a recovery catalog were previously discussed.
This lesson will discuss the commands you will encounter when performing basic maintenance on your recovery catalog. Furthermore, you will learn how to start Recovery Manager with and without a recovery catalog and basic maintenance commands that you can use on the recovery catalog.
In the module, you will learn to:

  1. Issue the command to start RMAN
  2. Demonstrate how to start RMAN without a recovery catalog
  3. Register a target database into your recovery catalog
  4. Discuss the use of the reset command
  5. Demonstrate how to resynchronize a target database using the resynch command
  6. Identify other situations where the resynch command is needed
  7. Use the change command to alter the information in your recovery catalog
  8. Use the delete command to remove data from your recovery catalog and the validate command to check the validity of your recovery catalog

You will find that the information presented in this module will be used infrequently. Some commands will be executed once or twice, while others not at all. You need to know this information for those infrequent times, and you will be tested on this information during the database administrator Oracle certification exams. In the next lesson, you will learn about starting RMAN with a recovery catalog.

Recovery Catalog Maintenance

Use of the recovery catalog involves some additional maintenance activities, which include upgrading the catalog during a database upgrade or migration, manually resetting the database incarnation, and resynchronizing the recovery catalog after certain database operations. This section describes those activities, as well as other maintenance considerations, including removing a database from the recovery catalog and using the Oracle EXP/IMP utilities to back up the recovery catalog. Finally, this section reviews the different recovery catalog views and what they are used for.

Unregistering a Database in RMAN

Prior to Oracle Database 10g, unregistering a database from the recovery catalog was a manual process. Now, Oracle makes removing a database from the recovery catalog as easy as issuing the command unregister database. Here is an example:
RMAN> Unregister database mydb;
When this command is executed, the metadata for the database in the recovery catalog is removed completely. Also, any metadata older than CONTROL_FILE_RECORD_KEEP time is removed from the control file. All local scripts for that database will also be removed from the recovery catalog.