ORA-19909 datafile 1 belongs to an orphan incarnation
Contributed by Martin
Friday, 22 May 2009
Last Updated Friday, 22 May 2009
Managed recovery aborts on a standby database. Messages in the alert log of a standby database such as:Fri May 22
08:00:32 2009
Warning: Recovery target destination is in a sibling branch
of the controlfile checkpoint. Recovery will only recover
changes to datafiles.
Datafile 1 (ckpscn 150505647373) is orphaned on incarnation#=2
MRP0: Background Media Recovery terminated with error 19909
Fri May 22 08:00:32 2009
Errors in file /u01/app/oracle/admin/prod/bdump/prod_mrp0_25696.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '+DATA/proddr/datafile/system.322.687442153'
Fri May 22 08:00:32 2009
SUCCESS: diskgroup DATA was dismounted
Fri May 22 08:00:32 2009
Errors in file /u01/app/oracle/admin/prod/bdump/prod_mrp0_25696.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation