Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 27, 2012 8:35 PM by
Possible? PDG->GG plus DDL
Mar 27, 2012 5:29 PM
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..
This content has been marked as final.
Show 1 reply
Re: Possible? PDG->GG plus DDL
Mar 27, 2012 8:35 PM
in response to
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 :-(
11g - no mention of that limitation
Edited by: Daryl E. on Mar 27, 2012 6:35 PM