Incarnation Error in Recovery

Following error may thrown during recovery process if incarnation of live and backup databases are different..


An incarnation is a seperate ‘life path’ of an Oracle Database, which is created at the time when a RESETLOGS is issued.


ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1:


First check the incarnation of both the databases using rman.


RMAN> list incarnation


Check the current incarnation of the LIVE database and apply the same number to backup database.


RMAN> RESET DATABASE TO INCARNATION 4 ;


Then try to recover again..