Monday, 31 January 2011

RMAN-20002: target database already registered in recovery catalog

Introduction:
We moved one the Oracle 10g database from one server to other server, and database was opened with "resetlogs" option. And when we tried to do the register the database it gave the following error
"RMAN-20002: target database already registered in recovery catalog"

Cookbook:

To resolve the issue we issued the following command on rman prompt and then every thing was fine. Following are the errors and command which we ran

----------
RMAN> register database;

starting full resync of recovery catalog
full resync complete
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 01/29/2011 22:00:48
RMAN-20002: target database already registered in recovery catalog

RMAN> reset database;

database incarnation already registered
----------