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.
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..
Found this in 10g .. looking for the 11g docs now..
"The extraction and replication of DDL are not supported in ALO mode."
That's a big drawback :-( edit
11g - no mention of that limitation
Edited by: Daryl E. on Mar 27, 2012 6:35 PM