Home
 
 Login
 
 Knowledge Base
 
Search:
 
 

Knowledge base: RECOVERY MANAGER 

Question: Unregister/Register DBID for RMAN ?

Steps to Unregister from Catalog:
1)Connect to Catalog as rman user.
2)SQL>Select db_key,db_id from rc_database;
3)SQL>execute dbms_rcvcat.unregisterdatabase (db_key, db_id);
4)Remove backup sets from catalog
SQL> select handle from rc_backup_piece where db_id =<>;
RMAN> list backupset of database;
RMAN> allocate channel for delete type disk;
RMAN> change backupset XXX delete;

Steps to Register with Recovery Catalog:
RMAN>connect target / ;
RMAN>Connect catalog rman/@;
RMAN>Register database;
RMAN>reset database;


RECOVERY MANAGER
      a.  Unregister/Register DBID for RMAN ?

© 2015: Welcome2solutions