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)
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.
Very informative post. Thanks
ReplyDeleteOh thank you just want I needed!
ReplyDelete