| | 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 | | | | |
|
|
|