DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, June 27, 2013

11g RMAN PL/SQL package CATALOG.DBMS_RCVCAT version 11.02.00.02 in GIS database is not current.

PL/SQL package RCAT.DBMS_RCVCAT version 11.02.00.02 in RCVCAT database is not current.

when we are trying to connect the Rman catalog database we are getting  the error it is cause because The particular version of the source database catalog is not sync with the current catalog.

The Cause of this Error is due to the recover catalog database or the target database must be upgraded .. or the recover catalog database is changed.

1.[oracle@dbprod02 obk]$ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jun 27 07:43:06 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


RMAN> connect target /
connected to target database: GIS (DBID=2213204443)

RMAN> connect catalog catalog/catalog@pascat
connected to recovery catalog database
PL/SQL package CATALOG.DBMS_RCVCAT version 11.02.00.02 in RCVCAT database is not current
PL/SQL package CATALOG.DBMS_RCVMAN version 11.02.00.02 in RCVCAT database is not current


2. For check the issue if we give the Register database or Resync catalog thou will get the below error message

RMAN> register database;

DBGSQL:     RCVCAT> begin dbms_rcvman.dumpPkgState('RCVMAN after sqlerror'); end;
DBGSQL:        sqlcode = 6550
DBGSQL:     RCVCAT> begin dbms_rcvcat.dumpPkgState('RCVCAT after sqlerror');end;
DBGSQL:        sqlcode = 6550
database registered in recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 0 on line 1655 column 12: Statement ignored
RMAN-10014: PL/SQL error 306 on line 1655 column 12: wrong number or types of arguments in call to 'CHECKTABLESPACE'


RMAN> resync catalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 06/27/2013 07:50:06
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 0 on line 1655 column 12: Statement ignored
RMAN-10014: PL/SQL error 306 on line 1655 column 12: wrong number or types of arguments in call to 'CHECKTABLESPACE'


3 We need to give the upgrade catalog command to sync the new change in the binaries to reflect in the catalog database

RMAN> upgrade catalog;
recovery catalog owner is CATALOG
enter UPGRADE CATALOG command again to confirm catalog upgrade


RMAN> upgrade catalog;
recovery catalog upgraded to version 11.02.00.03
DBMS_RCVMAN package upgraded to version 11.02.00.03
DBMS_RCVCAT package upgraded to version 11.02.00.03


4. Connect the target database with the rman and catalog now you can issue the command report schema

[oracle@dbprod02 obk]$ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jun 27 07:50:17 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


RMAN> connect target /
connected to target database: GIS (DBID=2213204443)


RMAN> connect catalog catalog/catalog@pascat
connected to recovery catalog database

RMAN> report schema;

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.