0

If I have standby which is db role is PHYSICAL STANDBY and it is MOUNTED. So, when I open it read/write the standby will be destroyed. (I have DataGuard)

So, basically do I need to mount it again and start the recover process to fix it or does this envolve more steps?

1 Answer 1

1

It is not possible to do that with recovery only. The standby database that was opened in read/write mode must be flashed backed to a point before it was opened.

This concept is called "snapshot standby".

Managing a Snapshot Standby Database

A snapshot standby database is a fully updatable standby database. It receives and archives redo data from a primary database, but does not apply it.

Redo data received from the primary database is applied when a snapshot standby database is converted back into a physical standby database, after discarding all local updates to the snapshot standby database.

...

Flashback Database is used to convert a snapshot standby database back into a physical standby database. Any operation that cannot be reversed using Flashback Database technology prevents a snapshot standby from being converted back to a physical standby.

More details can be found in the documentation referenced above.

With broker:

Converting a Physical Standby to a Snapshot Standby

3
  • so basically only few commands, will restore my database to functional standby db again?
    – paganini
    Feb 19 at 15:34
  • @paganini Anything can be done with only a few commands that are wrappers for additional steps, but yes, that is the point of this. Feb 19 at 16:20
  • thanks for the info, I have 1 more additional questions, lets suppouse I have windows server which is my standby. Can I use configure the database to startup immediatly or do I need a small script which would start after every windows restart?
    – paganini
    Feb 19 at 19:35

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.