Database Reference
In-Depth Information
The only other operations that might be needed are modification of the service for the
new recovery catalog database, if that has changed. Otherwise, once the export is complete
you can simply import that dump file into a newly created schema that has been granted
the RECOVERY_CATALOG_OWNER privilege.
Backing Up the Recovery Catalog
You can actually back up the recovery catalog using RMAN. You would simply use the
control file of the recovery catalog to store the backup-related information. You can do
online or offline backups and complete or point-in-time restores as your needs dictate.
You can also use Oracle's flashback features (see Chapter 8, “Understanding Flashback
Technology,” for more on Oracle Flashback Database) on the recovery catalog.
Why Resync the Catalog?
You might be asking yourself, “If RMAN resynchronizes the catalog automatically after
a backup, why would I ever need to use the RESYNC CATALOG command?” That's a fair
question.
One place where one of us was employed had a large number of databases and used
RMAN and the recovery catalog. As more and more records were added to the recovery
catalog, we found our backups were taking longer. This ended up being because of a bug
in RMAN. To work around the problem until Oracle could give us a fix, we did our backups
without connecting to the recovery catalog. These made the backups perform much faster.
We would then connect to the recovery catalog in a different operation and resync the con-
trol file to the recovery catalog.
This corrected the performance problem while still allowing us to use the recovery catalog
to store our database backup metadata.
Recreating an Unrecoverable Recovery Catalog
What do you do if you have lost your recovery catalog and you don't have a backup of it.
First of all, don't worry too much if you still have the database control file for the target data-
bases. If you do, then a large majority of the information in the recovery catalog will still be
intact. Let's look at what needs to be done to recreate an unrecoverable recovery catalog.
Search WWH ::




Custom Search