ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-19909: during duplication


-------------------------------------------------------------------------------------------------------
RMAN > CONNECTED TO TARGET AND AUXILIARY
                 DUPLICATE TARGET DATABASE TO DB2'

........................
........................
.........................
starting media recovery

archived log for thread 1 with sequence 934 is already on disk as file /erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-934_T-1_A-760035616_3ump3je0
archived log for thread 1 with sequence 935 is already on disk as file /erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-935_T-1_A-760035616_4mmp3r0u
archived log for thread 2 with sequence 1368 is already on disk as file /erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-1368_T-2_A-760035616_49mp3jfm
archived log for thread 2 with sequence 1369 is already on disk as file /erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-1369_T-2_A-760035616_4bmp3jgq
archived log for thread 2 with sequence 1370 is already on disk as file /erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-1370_T-2_A-760035616_4emp3jhr
archived log file name=/erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-934_T-1_A-760035616_3ump3je0 thread=1 sequence=934
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/14/2011 21:08:53
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 '/erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-934_T-1_A-760035616_3ump3je0'
ORA-00283: recovery session canceled due to errors
ORA-19906: recovery target incarnation changed during recovery

RMAN> exit


Recovery Manager complete.
[server1:+ASM1:oracle] sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Oct 14 21:38:15 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DB2/DB2/datafile/system.274.764540307'


SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '+DB2/DB2/datafile/system.274.764540307'


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[server1:+ASM1:oracle] ls -ltr /erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-934_T-1_A-760035616_3ump3je0
-rw-r-----   1 oracle   oinstall 285634048 Oct 14 17:49 /erpinstall/rman/arc_arch_D-DB1_id-1844823682_S-934_T-1_A-760035616_3ump3je0
[server1:+ASM1:oracle] rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Fri Oct 14 21:44:40 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: DB2 (DBID=1844823682, not open)

RMAN> list incarnatin;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "all, archivelog, backup, backuppiece, backupset, backed, completed, copy, controlfilecopy, datafilecopy, device, db_unique_name, expired, failure, foreign, global, incarnation, like, proxy, recoverable, restore, script, tag"
RMAN-01008: the bad identifier was: incarnatin
RMAN-01007: at line 1 column 6 file: standard input

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       DB2   1844823682       PARENT  5539943343956 24-AUG-11
2       2       DB2   1844823682       CURRENT 5545713781531 20-SEP-11

RMAN> reset database to incarnation 1;

database reset to incarnation 1

RMAN> list incarnatin;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "all, archivelog, backup, backuppiece, backupset, backed, completed, copy, controlfilecopy, datafilecopy, device, db_unique_name, expired, failure, foreign, global, incarnation, like, proxy, recoverable, restore, script, tag"
RMAN-01008: the bad identifier was: incarnatin
RMAN-01007: at line 1 column 6 file: standard input

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       DB2   1844823682       CURRENT 5539943343956 24-AUG-11
2       2       DB2   1844823682       ORPHAN  5545713781531 20-SEP-11

RMAN> exit

start recovery

sql> recover database using backup controlfile;
and provide all the archivelogs and open resetlogs;