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