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?