Database Administration (MOSC)

MOSC Banner

Can I configure dataguard and golden gate on same database?

I plan to set up three data centers with the following roles:

  • DC1: Primary (read/write)
  • DC2: Read-only
  • DC3: Read/write

Is it possible to use Oracle Data Guard and Oracle GoldenGate together on the same database to achieve this architecture? Specifically:

  • Use Data Guard for replication from DC1 to DC2 (read-only standby)
  • Use GoldenGate for replication from DC1 to DC3 (active read/write)

Is this approach supported for production use, and are there any limitations or considerations I should be aware of?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center