Yesterday morning we had two launch webcasts for Oracle
GoldenGate 11g Release 2. I had the pleasure to
present, as well as moderate the Q&A
panels in both of these webcasts. Both
events had hundreds of live attendees, sending us over 150 questions. Even
though we left 30 minutes for Q&A, it was not nearly enough time to address for
all the insightful questions our audience sent. Our product management team and I really
appreciate the interaction we had yesterday and we are starting to respond back with outstanding questions today. Oracle GoldenGate’s new release launch also had great welcome from the media. You can find the links for various articles on the new release below:
DBTA, Real-Time Data Integration: Oracle GoldenGate 11g Release 2 Now Available
CBR Oracle unveils
GoldenGate 11g Release 2 real-time data integration application
In this blog, I want to address some of the
frequently asked questions that came up during the webcasts. You can find the top questions and their answers
along with related resources below. We will continue to address frequently asked questions via future blogs.
Q: Will the new Integrated Capture for Oracle
Database replace the Classic Capture? If not, which one do I use when?
A: No, Classic Capture will be around for long time. Core platform specific features, bug fixes, and patches will be available for both Capture processes.Oracle Database specific features will be only available in the Integrated Capture. The Integrated Capture for Oracle Database
is an option for users that need to capture data from compressed tables or need
support for XML data types, XA on RAC. Users who don’t leverage these features should continue to use our
For more information on Oracle GoldenGate 11g Release 2 I
recommend to check out the White
paper: Oracle GoldenGate 11gR2 New Features as well as other
technical white papers we have on
those of you coming to OpenWorld, please attend the related session:
Extracting Data in Oracle GoldenGate
Integrated Capture Mode, Monday Oct 1st 1:45pm Moscone South – 102
more about this new feature.
Q: What is new in Conflict Detection and Resolution? And how does it work?
A: There are now pre-built functions
to identify the conditions under which an error occurs and how to handle the
record when the condition occurs. Error conditions handled include inserts into
a target table where the row already exists, updates or
deletes to target table rows that exist, but the original source data (before
columns) do not match the existing data in the target row, and updates or deletes where the row does
not exist in the target database table.For
each of these conditions a method to handle the error is specified.
Please check out our recent blog on
this topic and the White
paper: Oracle GoldenGate 11gR2 New Features white paper.
Also, for those attending OpenWorld please attend the session:
Best Practices for Conflict Detection and Resolution in Oracle GoldenGate for Active/Active- Wednesday Oct 3rd 3:30pm Mascone 3000
Q: Does Oracle GoldenGate Veridata and the Management Pack require additional
licenses, or is it incorporated with the GoldenGate license?
A: Oracle GoldenGate Veridata and Oracle Management Pack
for Oracle GoldenGate are additional products and require separate licenses. Please check out Oracle's price list here.
Q: Does GoldenGate - Oracle Enterprise
Manager Plug-in require additional license?
A: Oracle Enterprise Manager Plug-in is included in the Oracle Management
Pack for Oracle GoldenGate license, which is separate from Oracle GoldenGate
license. There is no separate license for the Enterprise Manager Plug-in by
itself. Oracle GoldenGate Monitor, Oracle GoldenGate Director, and Enterprise Manager Plug-in are included in the Management Pack for Oracle GoldenGate license. Please check out Management Pack for Oracle GoldenGate data sheet for more info on this product bundle.
Q: Is Oracle GoldenGate replacing Oracle Streams product?
A: Oracle GoldenGate is the strategic data replication
product. Therefore, Oracle Streams will continue to be supported, but will not
be actively enhanced. Rather, the best elements of Oracle Streams will be added
to Oracle GoldenGate. Conflict management is one of them and with the latest
release Oracle GoldenGate has a more advanced conflict management offering. Current
customers depending on Oracle Streams will continue to be fully supported.
Q: How is Oracle GoldenGate different
than Oracle Data Integrator?
Data Integrator is designed for fast bulk data movement and transformation
between heterogeneous systems, while GoldenGate is designed for real-time movement
of transactions between heterogeneous systems. These two products are completely
complementary where GoldenGate provides low-impact real-time change data capture and delivery
to a staging area on the target. And Oracle Data Integrator transforms this
data and loads the DW tables. In fact, Oracle Data Integrator integrates with
GoldenGate to use GoldenGate’s Capture process as one option for its CDC
mechanism. We have several customers that deployed GoldenGate and ODI together
to feed real-time data to their data warehousing solutions. Please also check out Oracle Data Integrator Changed Data Capture with Oracle GoldenGate Data Sheet (PDF).
you again very much for welcoming Oracle GoldenGate 11g Release 2 and stay in
touch with us for more exciting news, updates, and events.