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’;

———————— ———-
COSPSWDM 371053283

Connect Target Database:

SQL> select name, dbid from v$database;

——— ———-
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


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;



PL/SQL procedure successfully completed.

Register database:
uspuh23p2:COSPSWDM> rman target /
Recovery Manager: Release – 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

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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.