Thursday, 20 December 2012

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



Problem:
       when  i tride to connect RMAN with catalog mode and  take backups i found the following error.





$ rman target / catalog rman/rman@RMAN1

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 18 12:28:40 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: EXE57 (DBID=4220035703)

connected to recovery catalog database


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


RMAN> list backup summary;


DBGSQL:     RCVCAT> begin dbms_rcvcat.dumpPkgState('RCVCAT after sqlerror');end;
DBGSQL:        sqlcode = 6550

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 12/18/2012 12:28:56
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog.


This issue is because, recently we have upgraded the target database and the information is not know to catalog database.

Solution:
    To Resolve this issue we need to upgrade the catalog schema as shown below.
note:you need to connect the catalog from the target database rman utility.