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            CUR Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
10697   10698   DBNAME    1921873525       NO  37650      03-JUL-01
10697   12012   DBNAME    1921873525       YES 39457      03-AUG-01

RMAN> reset database to incarnation 10698;

RMAN> list incarnation;

DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
10697   10698   DBNAME    1921873525       YES 37650      03/07/2001 11:45:58
10697   12012   DBNAME    1921873525       NO  39457      03/08/2001 17:09:52

RMAN> list incarnation of database DBNAME;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
34109   34110   DBNAME     2492487887       NO  5231515755020 14-MAY-02
34109   35570   DBNAME     2492487887       YES 5231515763720 25-JUN-02