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

http://blogs.oracle.com/AlejandroVargas/2007/12/28/#a302

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: