RMAN.DBMS_RCVCAT version 11.02.00.03 in RCVCAT database is not current

PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.03 in RCVCAT database is not current

PL/SQL package RMAN.DBMS_RCVMAN version 11.02.00.03 in RCVCAT database is not current

ISSUE

·         When we try to connect catalog database via RAM from target database, we get the below error. This is because of catalog version is lower than target database.

[oracle@rac127 ~]$ rman target sys/oracle@gisdb catalog rman/rman@catdb

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jun 25 08:47:55 2015

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

connected to target database: GISDB (DBID=3111725433)

connected to recovery catalog database

PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.03 in RCVCAT database is not current

PL/SQL package RMAN.DBMS_RCVMAN version 11.02.00.03 in RCVCAT database is not current

SYMPTOMS

Connect to the RMAN-catalog database via RMAN is reporting the following messages :

PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.03 in RCVCAT database is not current
PL/SQL package RMAN.DBMS_RCVMAN version 11.02.00.03 in RCVCAT database is not current

RMAN Catalog Version 11.2.0.3

PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.03 in RCVCAT database is not current
PL/SQL package RMAN.DBMS_RCVMAN version 11.01.00.03 in RCVCAT database is not current

Target Database Version : 11.2.0.4

SOLUTION

·         Upgrade the RMAN-CATALOG schema. Start the RMAN-executable from the ORACLE_HOME which has been upgraded/higher. There is only a connection to the CATALOG required.

[oracle@rac127 ~]$ rman catalog rman/rman@catdb

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jun 25 08:57:09 2015

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

connected to recovery catalog database

PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.03 in RCVCAT database is not current

PL/SQL package RMAN.DBMS_RCVMAN version 11.02.00.03 in RCVCAT database is not current

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

·         Now connect to target database and verify the result

[oracle@rac127 ~]$ rman target sys/oracle@GISDB CATALOG rman/rman@catdb

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jun 25 08:58:28 2015

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

connected to target database: GISDB (DBID=3111725433)

connected to recovery catalog database

RMAN> list incarnation  ;

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       2       CATDB    2430054658       CURRENT 1          06-JUL-15

·         Great, It’s done.  Now register target database to catalog database.

RMAN> register database ;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN> list incarnation  ;

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       2       CATDB    2430054658       CURRENT 1          06-JUL-15

261     276     GISDB    3111725433       PARENT  1          24-AUG-13

261     262     GISDB    3111725433       CURRENT 925702     23-JUN-15

Enjoy….. J