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
Online Tools:  Generate rename / copy datafiles script

 
 
 
 Found 4 tips, Displaying 1 - 4 
 
Sort by 
 
 Make backupset unavailable in RMAN
This may be useful when you want to restore archive logs which were backed up more than once. These archivelog files will be included in multiple backup sets in the RMAN catalog, by default it will attempt to restore from the latest backup. But what if at the moment you ...
     
More...

07/25/07
 
 
 How to register database with RMAN recovery catalog
Replace username/password with the actuall username and password for recovery catalog; and MYDB with the name of the recovery catalog database 1. Change SID to the database you want to register . oraenv ORACLE_SID 2. Connect to RMAN catalog database rman target / catalog username/password@MYDB 3. Register database RMAN> register database;
     
More...

11/23/05
 
 
 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
 
 
 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
 
 


Recent tips & tricks
Miscellaneous > Middleware > Oracle Fusion Middleware > Oracle SOA Suite : Cannot connect to database whe...
Databases > Oracle : How to identify semaphors and ...
Databases > Oracle > Oracle 10g : How to drop tablespace with da...
Databases > Oracle : How to move an index to anothe...

More categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Office Software | TipLib FAQ
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com