I have a primary and a standby database. Both two node RAC database.

As some testing had to be done in standby database, I had to open it in read-write mode.

I cancelled the recovery in standby and activated standby database and opened the two node database in read-write mode.

Now, the DR is broken. And to make the standby as a proper physical standby, full reconfiguration of DR is required?

If not, help me out in setting up my standby back in track!

1 Answer 1


If you had flashback enabled or created a restore point before activating the standby database, you can flashback the database to that point/SCN, and the standby database can continue from there like nothing happened.

You can do this manually, or if you have Data Guard Broker configured, you can use the REINSTATE DATABASE command to do this.

In case you have not prepared for this, you will need to rebuild (duplicate/restore) the standby database.

Next time do not do this, there is a feature called Snapshot Standby designed for testing tasks like this, that works just as I described above.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.