Site icon IT Tutorial

RMAN-20002: target database already registered in recovery catalog

Hi,

Sometimes You can get “RMAN-20002: target database already registered in recovery catalog ” error.

 

Details of error are as follows.

RMAN-20002: target database already registered in recovery catalog
Cause: target database is already registered in the recovery catalog
Action: if the target database is really registered, there is no need to register it again.
Note that the recovery catalog enforces that all databases have a unique DBID.
If the new database was created by copying files from an existing database,
it will have the same DBID as the original database and cannot be registered in the same recovery catalog.

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 29/04/2020 14:40:48
RMAN-20002: target database already registered in recovery catalog

This error is related with the catalog database, to solve this error, reset database as follows.

 

RMAN> reset database;

database incarnation already registered

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

Exit mobile version