Migrate database from one RMAN catalog to another RMAN catalog

Migrate database from one RMAN catalog to another RMAN catalog

IMPORT CATALOG is a new feature of RMAN in Oracle 11g. We can move or merge schemas of different RECOVERY CATALOG of different databases into a centralized repository.

In a nut shell It is nothing but importing a CATALOG from one database to another, or in other words, "moving" or "migrating" CATALOG.

SOURCE DATABASE - CATDB1 

TARGET DATABASE - CATDB2


1)check the registred catalog databases in BOTH the catalog databases
CATDB1- select* from RMAN.RC_DATABASE;
CATDB2- select* from RMAN.RC_DATABASE;

2)Connect the TARGET CATALOG database and import the 1st CATALOG data
RMAN catalog rman/rman@catdb2
IMPORT catalog rman/rman@catdb1
list DB_UNIQUE_NAME all;

3)After that We can see GGDB1 is also registered to this CATALOG in CATDB2.

4)we can not see the CATALOG database after IMPORTING the data from CATDB1 to CATDB2
list DB_UNIQUE_NAME all;


5)On the Source Catalog, the database will be automatically Unregistered after the IMPORT CATALOG.
If you need to retain the catalog on the source side even after the import then a keyword should be added to the IMPORT CATALOG command.

Connect to the RMAN prompt and issue the IMPORT CATALOG command with the keyword NO UNREGISTER.,

RMAN catalog rman/rman@catdb2
IMPORT catalog rman/rman@catdb1 no unregister;


6)Now check both CATDB1 and CATDB2 whether the catalog database is registered or not
CATDB1 - list DB_UNIQUE_NAME all;
CATDB2 - list DB_UNIQUE_NAME all;


You can clearly see that the database is not Unregistered from the Source side.