Thinking Out Loud

May 28, 2009

the three sexy skills of data geeks

Filed under: Uncategorized — mdinh @ 12:00 pm

I saw this post and thought it was interesting –

May 19, 2009

Activate Physical Standby for Read/Write

Filed under: Uncategorized — mdinh @ 5:47 pm

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

Create a free website or blog at