Oracle Blog

Inside Oracle's Data Integration community

Thursday Jan 10, 2013

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.

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
team.

Can
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.

Can
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
Edition.

Is
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.

Can
GoldenGate be used in environments where a number of tables do not have
primary keys?

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.

Monday Dec 10, 2012

Oracle Database offers a variety of built-in and
optional products for maximum availability, and it is well known for its robust high
availability and disaster recovery solutions. With its heterogeneous, real-time, transactional data
movement capabilities, Oracle GoldenGate is a key part of the Maximum
Availability Architecture for Oracle Database.

This week on Thursday Dec. 13th
we will be presenting in a live webcast how Oracle GoldenGate fits into Oracle Database Maximum
Availability Architecture (MAA). Joe Meeks from the Oracle Database High
Availability team will discuss how Oracle GoldenGate complements other key products
within MAA such as Active Data Guard. Nick Wagner from GoldenGate PM team will present how to upgrade to latest Oracle Database release without any downtime.
Nick will also cover 2 new features of Oracle GoldenGate 11gR2: Integrated
Capture for Oracle Database and Automated Conflict Detection and Resolution. Nick
will provide in depth review of these new features with examples.

I'd like to invite you to join us on Thursday Dec. 13th 10am PT/1pm ET to hear from the product experts on how to use GoldenGate for maximizing database availability and to ask your questions. You can find the registration link below.