Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

h8dk97 : member's tip(s)


   Found 203 tips, Displaying 201 - 203 
 
Sort by 
 
 Reset database to a specific incarnation.
When trying to backup a database that was previously restored the backup will fail unless this procedure has been applied to rman catalog. $ . oraenv $ORACLE_SID $ rman target / catalog user/passwd@CATDB RMAN> reset database; RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID ...
 More...
09/23/05
 
 
Category : Databases > Oracle > RMAN
 
 
 Unregister database from recovery catalog
Login as rman catalog owner. SQLPLUS> select * from rc_database where dbid = DBID; SQLPLUS> exec dbms_rcvcat.unregisterdatabase(DBKEY, DBID);
     
More...

09/23/05
 
 
Category : Databases > Oracle > RMAN
 
 
 Reset DBID
Reset database id so that it can be backed up if the same DBID already exists in RMAN catalog for a different database. SVRMGR> alter database backup controlfile to trace resetlogs; SVRMGR> shutdown immediate; SVRMGR> startup mount; SVRMGR> select dbid , name from v$database ; DBID NAME ---------- --------- 673658548 ...
 More...
09/23/05
 
 
Category : Databases > Oracle
 
 


<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | Page 21

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com