Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert into primary database from Active Data Guard standby

Mimi MiamiApr 10 2014 — edited Apr 10 2014

I am using Oracle EE 11.2.0.3.8 on Solaris 10.

I have been reading that it is possible to do an insert from my Active Data Guard standby database by redirecting the insert to happen on the primary via a DB link. I have GLOBAL_NAMES set to TRUE and it needs to stay this way. This means I cannot create a DB link that points back to my primary as such:

CREATE DATABASE LINK PROD.WORLD USING 'PROD_PRIM';

How can I get around this to be able to insert data into the primary from my ADG standby?

This post has been answered by mseberg on Apr 10 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2014

Added on Apr 10 2014

#data-guard, #database, #performance-availability

1 comment

1,233 views