upgrade oracle rman catalog

Upgrading the Recovery Catalog

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:

1. 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:

   • for UPGRADE CATALOG command syntax

% rman TARGET / CATALOG rman/cat@catdb

DROP CATALOG;

recovery catalog owner is rman
enter DROP CATALOG command again to confirm catalog removal

DROP CATALOG;