Unregister a database from old catalog and register to a new catalog

posted Sep 24, 2010, 11:36 AM by Sachchida Ojha
$ sqlplus rman/rman@rmand
sqlplus>select 'execute dbms_rcvcat.unregisterdatabase ('||db_key||','||dbid||');' from rc_database where name = 'PRODDB';

execute dbms_rcvcat.unregisterdatabase (1032389,3914890523);

sqlplus>execute dbms_rcvcat.unregisterdatabase (1032389,3914890523);
PL/SQL procedure successfully completed.

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

$rman target / catalog rman/rman@rman

Recovery Manager: Release - Production on Fri Sep 24 18:34:29 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: PRODDB (DBID=3914890523)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete