Upgrading the Recovery Catalog Schema OR Database

The catalog schema must support the highest target version it supports.  Therefore, when a target database is upgraded, you need to also upgrade the RMAN catalog schema.  Connect to RMAN from the target database (with highest version) and connect to the catalog schema to upgrade the schema version.  



Oracle Production DB Version  11.2.0.4
Oracle Catalog DB Version      10.2.0.4


Upgrade Catalog Schema

Production DB:


bash-4.1$ ./rman target / catalog rman/xxxxxxxx@catsserp


Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 9 17:02:43 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SSAERP (DBID=3389811866)
connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 10.02.00.04 in RCVCAT database is too old

RMAN> upgrade catalog;

recovery catalog owner is RMAN

enter UPGRADE CATALOG command again to confirm catalog upgrade



RMAN> upgrade catalog;

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




Catalog DB

SQL> conn rman/xxxxxxx
Connected.


SQL> select * from rcver;

VERSION
------------
11.02.00.04



SQL> conn / as sysdba
Connected.


SQL> grant create type to rman;

Grant succeeded.