Sunday, April 15, 2018

ORA-19909: datafile 1 belongs to an orphan incarnation

Symptom:

Our physical Standby DB MRP is aborted and error code is:

ORA-19909: datafile 1 belongs to an orphan incarnation

Reasons:

 Due to some APPS issues, we did flashback(1am)  and resetlogs on Primary DB while MRP was running
 The standby has been applied archivelogs to timestamp (2am) well after we exec the flashback(1am)

 See note link which well documents the scenario

Solutions:

2 options:
1. Flashback standby DB to 1am and start MRP
2. Restore standby datafiles backup before 1am and start MRP ( no need to restore controlfiles on standby db)

In 12c, if flashback is enabled in standby DB, the dg broker can automatically flashback DB for you to 1am


No comments: