Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Database + Options
This discussion is archived
on Mar 28, 2012 1:35 AM by Daryl E.
Possible? PDG->GG plus DDL
Mar 27, 2012 10: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..
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Possible? PDG->GG plus DDL
Mar 28, 2012 1:35 AM
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