Recover original primary after switchover and flashback failed
Hi all
What is the correct procedure to recreate a primary database after a switchover. Let me explain:
1. I did a switchover, now primary is standby and standby primary.
2. After some operation on the new standby we did a flashback database. Primary flashack completed but new standby could flashaback the database, because some missing archivelog need it and we were not able to recover from tape. So in this scenario my original primary need a restore database from my new primary.
What is the correct procedure to recover my new standby database and then switchoverto get the original scenario.
Explained in more details.