Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-02 |
|
|
View PDF |
If you use a version of the recovery catalog that is older than that required by the RMAN client, then you must upgrade it. For example, you must upgrade the catalog if you use a release 8.1 version of the RMAN client with a release 8.0 version of the recovery catalog.
You receive an error when issuing UPGRADE
CATALOG
if the recovery catalog is already at a version greater than that required by the RMAN client. RMAN permits the UPGRADE
CATALOG
command to be run if the recovery catalog is current and does not require upgrading, however, so that you can re-create packages at any time if necessary. Check the message log for error messages generated during the upgrade.
To upgrade the recovery catalog:
To install the new recovery catalog schema, the recovery catalog user must have TYPE privilege:
sqlplus> connect sys/oracle@catdb as sysdba; sqlplus> grant TYPE to rman;
Use RMAN to connect to the target and recovery catalog databases. For example, enter:
% rman TARGET / CATALOG rman/cat@catdb connected to recovery catalog database PL/SQL package rcat.DBMS_RCVCAT version 08.00.04 in RCVCAT database is too old
Issue the UPGRADE
CATALOG
command:
UPGRADE CATALOG; recovery catalog owner is rman enter UPGRADE CATALOG command again to confirm catalog upgrade
Enter the UPDATE
CATALOG
command again to confirm:
UPGRADE CATALOG; recovery catalog upgraded to version 09.02.00 DBMS_RCVMAN package upgraded to version 09.02.00 DBMS_RCVCAT package upgraded to version 09.02.00
See Also:
Oracle Database Backup and Recovery Reference for UPGRADE
CATALOG
command syntax
Oracle Database Backup and Recovery Reference for information about recovery catalog compatibility
Oracle Database Upgrade Guide for complete compatibility and migration information