Thinking Out Loud

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


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a free website or blog at

%d bloggers like this: