RMAN-03002,RMAN-06004,RMAN-20001

RMAN-03002: failure of configure command at 08/14/2013 19:00:13
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001:
target database not found in recovery catalog
====================================================================

Problem: The target has a different dbid as show below:

Connect Cataloge Database:
————————–
SQL> connect catalog rman/”************”@pcatdb
SQL> select name, dbid from rc_database
where name = ‘COSPSWDM’;

NAME DBID
———————— ———-
COSPSWDM 371053283

Connect Target Database:
————————

SQL> select name, dbid from v$database;

NAME DBID
——— ———-
COSPSWDM 373182751

Solution: Register this COSPSWDM (DBID=373182751) before we can make a backup with rman connected to a catalog.

Connect Cataloge Database for Unregister database:
————————————————–

SQL> connect rman/”*********”@pcatdb

Connected.

If you want to purge the COSPSWDM currently in, you need to run the following metaquery against the catalog:

SQL> select ‘EXEC DBMS_RCVCAT.UNREGISTERDATABASE(‘||DB_KEY||’,’||DBID||’);’||’ ‘||resetlogs_time
from rc_database
where dbid = 371053283;

‘EXECDBMS_RCVCAT.UNREGISTERDATABASE(‘||DB_KEY||’,’||DBID||’);’||”||RESETLOGS_TI
——————————————————————————–
EXEC DBMS_RCVCAT.UNREGISTERDATABASE(6064586,371053283); 24-JUL-13

SQL> EXEC DBMS_RCVCAT.UNREGISTERDATABASE(6064586,371053283);

PL/SQL procedure successfully completed.

Register database:
——————
uspuh23p2:COSPSWDM> rman target /
Recovery Manager: Release 11.2.0.3.0 – Production on Wed Aug 14 19:32:21 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: COSPSWDM (DBID=373182751)

RMAN> connect catalog rman/”pr0drm3n!”@pcatdb

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

Advertisements

About shanojkumar

* Has 12 years of experience in Planning, Implementing, Managing and Monitoring the Oracle Databases as an (Oracle 10g & 11g OCP) Certified Oracle Database Administrator.
This entry was posted in Oracle and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s