Upgrade the recovery catalog

If you created the recovery catalog owner in a release before 10gR1, and if the RECOVERY_CATALOG_OWNER role did not include the CREATE TYPE privilege, then grant it.

1. For example, start SQL*Plus, You can then execute the following GRANT statement:

SQL> GRANT CREATE TYPE TO rman;

SQL> EXIT;

2. Start RMAN and connect RMAN to the recovery catalog database.

3. Run the UPGRADE CATALOG command:

 RMAN> UPGRADE CATALOG;

recovery catalog owner is rman enter UPGRADE CATALOG command again to confirm catalog upgrade

4. Run the UPDATE CATALOG command again to confirm:

RMAN> UPGRADE CATALOG;

recovery catalog upgraded to version 11.01.00 DBMS_RCVMAN package upgraded to version 11.01.00 DBMS_RCVCAT package upgraded to version 11.01.00