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 runningThe 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:
Post a Comment