Search This Blog

Tuesday, 1 February 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 ----------

No comments:

APEX ADMIN account locked for workspace INTERNAL - password change procedure

 If APEX ADMIN account has locked  for INTERNAL workspace or need to change the password, use the following procedure, please test it first ...