Pages

Friday 18 October 2013

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

I got error as below while doing resync of the database with catalog.

connected to target database: TESTDB (DBID=2269473865)
connected to recovery catalog database
PL/SQL package RMAN_UINLUPP.DBMS_RCVCAT version 11.02.00.02 in RCVCAT database is not current
PL/SQL package RMAN_UINLUPP.DBMS_RCVMAN version 11.02.00.02 in RCVCAT database is not current

RMAN> RUN
2> {
3> RESYNC CATALOG;
4> REPORT SCHEMA;
5> }
6> LIST BACKUP SUMMARY;
7>
8>

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
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of resync command at 10/18/2013 02:01:30
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

Recovery Manager complete.

Reason:Database was not registered in the catalog. Register the target database and check it.

[oracle@uiddx4101 log]$ rman target / catalog rman_cat/rman_cat@rman

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 18 13:25:06 2013

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

connected to target database: TESTDB (DBID=2269473865)
connected to recovery catalog database

RMAN> RESYNC CATALOG;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of resync command at 10/18/2013 13:25:12
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog



RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog


full resync complete

RMAN>
RMAN>
RMAN> RESYNC CATALOG;

starting full resync of recovery catalog
full resync complete

RMAN> exit

No comments:

Post a Comment