Have not posted in a long time because I have been working with Data Guard and encountering various bugs.
Lately, I was asked to activate standy database for read write to test DR.
In 10gR2, this was possible using flash back.
Don’t forget to execute for primary and activated standby.
ALTER SYSTEM SET log_archive_dest_2=” SCOPE=BOTH;
Otherwise, you will get numerous errors.
ORA-16009: remote archive log destination must be a STANDBY database
Be sure to check Bug 4676659 – ORA-16009 in alert log with standby and LGWR ASYNC.
It was a success following the instructions from Alejandro Vargas’ Blog