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..
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..
Comments
Post a Comment