Tag Archives: unregister in rman catalog

Resolving RMAN-03014: Recovery Catalog Errors

RMAN-03014: implicit resync of recovery catalog failed

1. Connect the RMAN catalog with target database

rman catalog username\password@catalogdb  target \

2. Then try to register the database if you get the error “RMAN-03014” then it’s mean database is already register with same name but different DBID. Then you need to check the catalog for already register database If its same database you are working then you can unregistered database from catalog.

#Connect with target database
RMAN> unregister database;

Note: Problem occurred during refresh activity of database, same name but different DBID caused the problem. To avoid such thing you can use set DBID in RMAN during refresh activity.

rman> register database

Unregistered database with following command
Note: First check if same name database is working and backup regularly if not then you only fire the following command to unregistered the existing database from RMAN catalog database.

RMAN> unregister database;

Register the new database in RMAN catalog database

RMAN>register database;