RMAN-03002 RMAN-11003 ORA-19906

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/19/2010 14:44:57
RMAN-03015: error occurred in stored script Memory Script
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile ‘/u02/oracle/oraarch/TOTEMD/archivelog/2010_05_19/o1_mf_1_26104_5z7ttqww_.arc’
ORA-00283: recovery session canceled due to errors
ORA-19906: recovery target incarnation changed during recovery

The database refresh failed during recovery. Restore went all good.
Cause:
The backup control file is picking up the wrong incarnation
Solution:
list incarnation;
#Change the database incarnation
RESET DATABASE TO INCARNATION <x>;
recover database until cancel using backup controlfile;
alter database open resetlogs;
Advertisements

About mpoojari
Oracle Database/Applications Administrator

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: