Recovery Manager Command Syntax

reset

Syntax

Purpose

To create a new database incarnation record in the recovery catalog. RMAN considers the new incarnation as the current incarnation of the database. All subsequent backups and redo log archiving operations performed by the target database will be associated with the new database incarnation.

Requirements

Execute reset database only at the RMAN prompt.
You must be using a recovery catalog.
You must issue a reset database command before you can use RMAN with a target database that has been opened with the RESETLOGS option. If you do not, then RMAN refuses to access the recovery catalog, since RMAN cannot distinguish between a RESETLOGS and an accidental restore of an old control file. The reset database command gives confirmation to RMAN that you issued a RESETLOGS command.

Keywords and Parameters

to incarnation primary_key

changes the incarnation that RMAN considers to be current to an older incarnation. This option is useful in the rare circumstance in which you want to undo the effects of a RESETLOGS by restoring backups of a prior incarnation of the database.
Specify the primary key of the DBINC record for the database incarnation. Obtain the key value using the list incarnation of database command. After you issue the reset database to incarnation command, issue restore and recover commands to restore the database files from the prior incarnation and recover them.

Examples

Resetting a Database After RESETLOGS

The following example resets a database after performing incomplete media recovery:

run {  
     allocate channel dev1 type disk;  
     set until logseq 1234 thread 1;
     restore database skip tablespace readonly;  
     recover database;  
     sql "ALTER DATABASE OPEN RESETLOGS";
     release channel dev1;
}
reset database;

Resetting an Old Incarnation

The following command makes an old incarnation of database PROD1 current again:

# obtain primary key of old incarnation
list incarnation of database prod1;

List of Database Incarnations
DB Key  Inc Key   DB Name   DB ID       CUR    Reset SCN    Reset Time
------- -------   -------   ------      ---    ----------   ----------
1       2         PROD1     1224038686  NO     1            02-JUL-98
1       582       PROD1     1224038686  YES    59727        10-JUL-98

shutdown immediate;
# reset database to old incarnation
reset database to incarnation 2;
# recover it
run {  
     allocate channel dev1 type disk;
     restore controlfile;
     startup mount;
     restore database;
     recover database;
     sql "ALTER DATABASE OPEN RESETLOGS";
     release channel dev1;
}