Last month we had a live webcast on a hot topic: Maximum
Availability with Oracle GoldenGate. The webcast presentation focused on how
Oracle GoldenGate can help achieve maximum availability for Oracle Database and
other major databases. This webcast was very useful in answering a frequently asked question around GoldenGate's role for Oracle Database Maximum Availability Architecture (MAA) and when to
use Oracle GoldenGate vs Active Data Guard. Product experts, Joe Meeks from Oracle
Database High Availability product management team and Nick Wagner from Oracle
GoldenGate product management team, addressed this question for us. Joe and
Nick presented GoldenGate’s
key solutions within MAA, and when to use which product along with Integrated Capture and Automated Conflict Management features of GoldenGate 11gR2. If you missed this
event I highly recommend watching it on demand via the following link.
Watch On Demand:Maximum
Availability with Oracle GoldenGate.
We also recorded a short podcast on this topic. Oracle
for Maximum Availability
In the live webcast we had a very interactive audience who
submitted over 100 questions during the event. Joe and Nick answered the
most commonly asked questions about GoldenGate’s use cases and technology. Here are a few of the questions that we did
not have time to answer during the event, along with the answers from the PM
I use the target database as warehouse for select only. If I were to allow
users to this target, are there steps to ensure both source and target
databases remain in sync?
Yes you can use the target for read only or select
only operations. Yes, we can do bi-directional active-active replication if you
want to allow users to make changes to the target system. We can replicate
those back to the source.
Integrated Capture be run on Oracle Database Standard Edition?
Yes, but all of the features that are only supported
by Integrated Capture are only available with Oracle Database Enterprise
it possible to capture database transactions from a source database using GoldenGate and
publish them as messages into a JMS queue?
Yes, GoldenGate can capture from and deliver to JMS queue. Please see our page for Java Adapter for more info.
GoldenGate be used in environments where a number of tables do not have
Yes. In tables without primary keys, we will use all non-LOB
columns in the where clause for updates and deletes and then use ROWNUM = 1.
- Is there a webinar that shows how to set up Oracle GoldenGate?
Oracle GoldenGate Youtube channels has many useful videos
and labs including “Oracle GoldenGate Fundamentals and How Oracle GoldenGate Works” and “Oracle
GoldenGate Deep Dive Hands-on Labs” in 3
part series. You can browse and watch them here. Please check out GoldenGate training sessions with Oracle University as well.
I highly recommend subscribing to GoldenGate’s Youtube
channel along with joining the GoldenGate Facebook
and Twitter communities to get regular updates on