PROBLEM:

While registering database to rman catalog, getting below error.

RMAN> register database;

RMAN-00571: ================================================
RMAN-00569: ========== ERROR MESSAGE STACK FOLLOWS ==========
RMAN-00571: ================================================
RMAN-03009: failure of register command on default channel at 12/08/2010 13:03:21
RMAN-20002: target database already registered in recovery catalog

 

SOLUTION:

1. Check dbid of the database.

2. Connect to catalog and check whether same db is present or not

We can see another database CONTEST is already present in the catalog with the same dbid.
so adding new database to catalog with same DBid is failing.

So fix it, we have two options now.
OPTION – 1: ( UNREGISTER EXISTING DBID ENTRY)
If the database, for which same dbid exists in the catalog repository, it not in use , then we can remove the entry and try to register.

OPTION 2 (CHANGE THE DBID of the database:)

Use nid utility to change the dbid and try to register.

START DATABASE IN MOUNT STAGE

NID TOOL TO CHANGE DBID:

OPEN DATABASE IN RESETLOGS:

Now try to register: