Database Reference
In-Depth Information
Dropping the Recovery Catalog
As you can add a recovery catalog you can drop a recovery catalog. To drop the recovery
catalog you simply log into the recovery catalog through RMAN, and then issue the
DROP
CATALOG RMAN
command. There is no need to connect to any target database.
Upgrading the Recovery Catalog
Whenever you upgrade a database, you should also check to see if the recovery catalog data-
base or schema needs to be updated. The recovery catalog database and recovery catalog
schema should always be at the highest version of any database supported by that recovery cat-
alog. You would upgrade the recovery catalog database just as you would any other database.
To upgrade the recovery catalog schema, you connect
RMAN
to a target database that is
equal to or greater than the highest version of the databases that are serviced by the recovery
catalog. Once you have connected to the recovery catalog you would run the UPGRADE
CATALOG command.
When issuing the
UPGRADE CATALOG
command, you must issue the command twice to
confirm that you want to perform the upgrade. Also, you must upgrade the entire recovery
catalog. Virtual private catalogs cannot be upgraded separately.
Typically, the recovery catalog schema should be at the same version as the highest data-
base (and RMAN client) version of the database that you will use to connect to the recovery
catalog. The Oracle Database Backup and Recovery Reference provides more detailed infor-
mation on compatibility of the RMAN client versions, the Oracle database version, and the
RMAN recovery catalog version.
Synchronizing the Recovery Catalog
Typically during an RMAN operation, the recovery catalog will be synchronized with the
control file. New records will be updated or added during this synchronization process.
There may be times when you will want to synchronize the recovery catalog yourself manu-
ally. You can use the
RESYNC CATALOG
command to perform manual catalog synchroniza-
tion. Here is an example of using the
RESYNC
command:
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
Export and Import the Recovery Catalog
The Oracle RMAN Recovery Catalog fully supports the use of the Oracle Data Pump Export
and Import tools. To export the recovery catalog you only need to back-up the recovery cata-
log schema from a user with sufficient privileges to export the recovery catalog schema. The
same is true with importing a Data Pump
dumpfile
into a new recovery catalog schema.
Search WWH ::
Custom Search