Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-19909: datafile 29 belongs to an orphan incarnation

tennekNov 9 2015 — edited Nov 23 2015

Hi guys,

I got this error while trying to roll forward my standby database using an incremental backup of my primary database.

Managed Standby Recovery not using Real Time Apply

MRP0: Detected orphaned datafiles!

Recovery will possibly be retried after flashback...

Errors in file /u01/app/oracle/diag/rdbms/lapo_dr/lapo/trace/lapo_pr00_7597.trc:

ORA-19909: datafile 29 belongs to an orphan incarnation

ORA-01110: data file 29: '/u020/oradata/lapo/img01.dbf'

Slave exiting with ORA-19909 exception

Errors in file /u01/app/oracle/diag/rdbms/lapo_dr/lapo/trace/lapo_pr00_7597.trc:

ORA-19909: datafile 29 belongs to an orphan incarnation

ORA-01110: data file 29: '/u020/oradata/lapo/img01.dbf'

Recovery Slave PR00 previously exited with exception 19909

I have also tried to do a reset database to incarnation 2;

As incarnation 2 is the current incarnation on by primary database.

And that doesn't solve the problem. I still get that error message .

I need your help pls.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2015
Added on Nov 9 2015
25 comments
13,713 views