IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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 catalogCause: 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/
