GoldenGate

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!

goldengate from physical standby with Active data guard or from logical standby - which is better?

984830Jan 14 2014 — edited Jan 19 2014

Hi,

We have Oracle 11.2.0.4 and are currently using Active Data Guard on a physical standby. My boss wants me to use Goldengate

to replicate several schema from Oracle to SqlSserver. She doesn't want to touch the Primary, which is in production. Would it be better

to setup a Logical standby for Goldendate to use, in addition to the Physical standby? Or will it be sufficient to use the Physical standby?

The application tables don't all have primary keys. I'm trying to decide if the Logical standby adds another layer of complexity or would

introduce delays in getting the data from Oracle to Sqlserver.

Thanks in advance,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2014

Added on Jan 14 2014

#goldengate

2 comments

1,443 views