This discussion is archived
1 Reply Latest reply: Mar 27, 2012 6:35 PM by Daryl E. RSS

Possible? PDG->GG plus DDL

Daryl E. Explorer
Currently Being Moderated
Trying to find whitepaper or some confirmation on how to set up this scenario...

Source DB ->(firewalls/distance/etc) ->(DR) Physical Dataguard (Active) -> Replica DB (via goldengate) -> many LDG readonly databases.

Linux 11Gr1

From readings I see they call this ALO mode . where GG reads from archive logs off the Physical DG database.
How does the DDL make it over to the replica db? Do we capture DDL from the Source db?

Any pointers to docs?

Alternative is one very complex Dataguard scenario where the Source db has many legs over into the DR landscape.

Google let me down .. hoping someone has seen something like this before..

Daryl.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points