Recovery Catalog   «Prev  Next»

Lesson 3 Re-create the recovery catalog
Objective Re-create your recovery catalog.

Re-create the Recovery Catalog

In this lesson, you will discover several ways to re-create or rebuild your recovery catalog. The recovery catalog is stored as a database and is susceptible to the same problems as any other database. You could lose the recovery catalog because of hardware or software problems.

First steps

These are the first steps in re-creating your recovery catalog:
  1. Create a database to store the recovery catalog. For our examples, the recovery catalog is on local database orc1.
  2. Create a schema to own the recovery catalog; in our examples, it will be rman.
  3. Grant connect and resource privileges to rman.
  4. Grant recovery_catalog_owner to rman.
  5. Run the catrman.sql script as the user rman.
When this is complete, you will have two options.


One option to rebuild your recovery catalog is to issue a series of catalog commands to recatalog all your archived logs, control files, and data files.

rman80 target system/manager


The resync command is another option to consider when rebuilding your recovery catalog. In this case, you would issue the resync command to restore from a backup control file. The command might look like this:

resync catalog from backup controlfile 

This will restore your catalog based on the information stored in this control file. Hence, the restore may not be complete if the control file does not reflect the last state of your database. During a resynchronization, you may add records for backup files that do not exist. You will need to check and use the change delete command to remove them.
If you have a current export of the catalog owner, rman in this case, you can use import to restore this information. You would then run a resync command to synchronize the recovery catalog with your target database.
If you are using backup sets, you can use only the resync command. The catalog command does not understand backup sets or backup pieces.
In the next lesson, you will learn how to use the report command to analyze a recovery catalog.

Recreating Recovery Catalog

Click the link below to read about the re-creation of your recovery catalog.
Recreating Recovery Catalog