Tuesday Feb 05, 2013

Deeper Look into Integrated Capture for Oracle Database

With Oracle GoldenGate 11gR2 we announced a new "Integrated Capture" process for the Oracle Database. In our launch webcast back in September'12 our product team presented this feature along with other key features such as intelligent conflict management, advanced encryption, global deployment support and more.  You can watch that webcast on demand here.

We now have a recorded presentation with more details on this new feature. You can watch the GoldenGate Integrated Capture screencast to get a deeper look into this feature.

Integrated Capture for Oracle Database is very unique in the industry. This feature enables a deeper integration into the database engine and serves as the foundation for new features GoldenGate for Oracle Database will be adding  in the future.

As we mentioned in our recent Maximum Availability with Oracle GoldenGate webcast, GoldenGate's Classic Capture is still available for both Oracle Database, as well as other non-Oracle databases GoldenGate supports. Below is an overview of supported Oracle Database versions and features for both Classic and Integrated Capture.

Also please make sure to check out our new resources on GoldenGate's continuous availability solutions to learn more about Integrated Capture feature and other key new features.

Thursday Sep 27, 2012

Everything You Need to Know About Monitoring Oracle GoldenGate

By Joe deBuzna

Having over 16 years of database replication experience with 6 of those split between complex Oracle GoldenGate installations across three continents and researching monitoring requirements for both GoldenGate core replication and the GoldenGate monitoring GUIs, I've seen GoldenGate used and monitored in every way conceivable. And definite patterns have emerged. Next week at OpenWorld, on Tuesday Oct 2nd at 5pm please come by to Moscone West-3005 for "Everything you need to know about Monitoring Oracle GoldenGate"session to hear me discuss how GoldenGate customers are monitoring their implementations today, common methods and tricks, what's new in the GUIs, and a what's on the roadmap ahead. As you may have seen in previous blog posts and in our launch webcast we have now Plug-in for Oracle Enterprise Manager in addition to the new Oracle GoldenGate Monitor product.

For those of you who won't be at OpenWorld, please check out our Management Pack for Oracle GoldenGate data sheet and Oracle GoldenGate 11gR2 New Features white paper to learn more about the new Oracle GoldenGate 11gR2 release.

In this latest release we also have enhanced conflict detection and resolution. It is a cornerstone of any Active-Active database replication solution. And in the latest release we just took ours to the next level with built in optimized resolution routines (no more dependency on sqlexec!). At OpenWorld we have a session CON8557 - Best Practice for Conflict Detection & resolution 3:30-4:30 on Wed Oct 3rd at Moscone West- 3005. Oracle Development Manager Bharath Aleti and I will highlight the most commonly used options and best practices gained from our interaction with numerous customers and consultants.

Hope you can join us next week.


Thursday Sep 20, 2012

Oracle GoldenGate 11g Release 2 Launch Webcast Replay Available

For those of you who missed Oracle GoldenGate 11g Release 2 launch webcasts last week, the replay is now available from the following url.

Harnessing the Power of the New Release of Oracle GoldenGate 11g

I would highly recommend watching the webcast to meet many new features of the new release and hear the product management team respond to the questions from the audience in a nice long Q&A section.

In my blog last week I listed the media coverage for this new release. There is a new article published by ITJungle talking about Oracle GoldenGate’s heterogeneity and support for DB2 for iSeries: Oracle Completes DB2/400 Support in Data Replication Tool

As mentioned in last week’s blog, we received over 150 questions from the audience and in this blog I'd like to continue to post some of the frequently asked,  questions and their answers:

Question: What are the fundamental differences between classic data capture and integrated data capture? Do both use the redo logs in the source database?

Answer: Yes, they both use redo logs. Classic capture parses the redo log data directly, whereas the Integrated Capture lets the Oracle database parse the redo log record using an internal API.

Question: Does GoldenGate version need to match Oracle Database version?

Answer: No, they are not directly linked. Oracle GoldenGate 11g Release 2 supports Oracle Database version 10gR2 as well. For Oracle Database version 10gR1 and Oracle Database version 9i you will need GoldenGate11g Release 1 or lower. And for Oracle Database 8i you need Oracle GoldenGate 10 or earlier versions.

Question: If I already use Data Guard, do I need GoldenGate?

Answer: Data Guard is designed as the best disaster recovery solution for Oracle Database. If you would like to implement a bidirectional Active-Active replication solution or need to move data between heterogeneous systems, you will need GoldenGate.

Question: On Compression and GoldenGate, if the source uses compression, is it required that the target also use compression?

Answer: No, the source and target do not need to have the same compression settings.

Question: Does GG support Advance Security Option on the Source database?

Answer: Yes it does.

Question: Can I use GoldenGate to upgrade the Oracle Database to 11g and do OS migration at the same time?

Answer: Yes, this is a very common project where GoldenGate can eliminate downtime, give flexibility to test the target as needed, and minimize risks with fail-back option to the old environment. For more information on database upgrades please check out the following white papers:

Best Practices for Migrating/Upgrading Oracle Database Using Oracle GoldenGate 11g

Zero-Downtime Database Upgrades Using Oracle GoldenGate

Question: Does GoldenGate create any trigger in the source database table level or row level to for real-time data integration?

Answer: No, GoldenGate does not create triggers.

Question: Can transformation be done after insert to destination table or need to be done before?

Answer: It can happen in the Capture (Extract) process, in the  Delivery (Replicat) process, or in the target database.

For more resources on Oracle GoldenGate 11gR2 please check out our Oracle GoldenGate 11gR2 resource kit as well.

Monday Sep 10, 2012

Get Ready to Meet Oracle GoldenGate 11gR2 at OpenWorld

 

Oracle GoldenGate 11g Release 2 could not come at a better time. At Oracle OpenWorld 2012 we have a great set of sessions and demos for Oracle GoldenGate users: deep dives into the new features of Oracle GoldenGate 11gR2, as well as great customer presentations from Comcast, Bank of America, Turk Telekom, Ticketmaster, St. Jude Medical Center, and more.

Here are 3 must-attend sessions for GoldenGate users and for those who want to get to know GoldenGate’s capabilities:

  • Real-World Zero-Downtime Operations with Oracle GoldenGate: Customer Panel Oct 1st 1:45 PM Moscone West – 3005
  • Oracle GoldenGate 11g Release 2 New Features Oct 1st 3:15 PM Moscone West – 3005
  • Real-World Operational Reporting with Oracle GoldenGate: Customer Panel Oct 2nd 11:45 AM Moscone West - 3005

For a full list of GoldenGate and data integration sessions, please check out our Focus-On for Data Integration.

Similar to last year, Hands-on-Labs will be available for those who want to experience the power of GoldenGate first hand. One of these instructor-led sessions provides “Deep Dive into Oracle GoldenGate will be held on Thursday Oct 4th 11:15am at Marriott Marquis - Salon ½. I expect the spots will fill out fast in this session.

Oracle GoldenGate Demos will be running Monday through Wednesday in Moscone South in both Oracle Database and Oracle Fusion Middleware sections of the Oracle demo grounds. We will be showcasing:

  • Monitoring Oracle GoldenGate for End-to-End Visibility
  • Oracle GoldenGate 11gR2 New Features
  • Oracle GoldenGate 11gR2: Real-Time, Transactional Database Replication
  • Oracle GoldenGate Veridata
  • Oracle Maximum Availability Architecture

If you are not able to attend OpenWorld, you should not miss this week’s live webcast introducing Oracle GoldenGate 11g Release 2. On Wednesday the webcast will present the new features of GoldenGate and attendees will have a long, live Q&A panel session with the PM team.  I also recommend checking out the resources for GoldenGate to download new white papers.

The whole team is looking forward to sharing with you the latest and greatest features of GoldenGate at the launch webcast and at OpenWorld.

Monday Aug 27, 2012

It was worth the wait… Welcome Oracle GoldenGate 11g Release 2

It certainly was worth the wait to meet Oracle GoldenGate 11gR2, because it is full of new features on multiple fronts. In fact, this release has the longest and strongest list of new features in Oracle GoldenGate’s history. The new release brings GoldenGate closer to the Oracle Database while expanding the support for global implementations and heterogeneous systems. It is more secure, more flexible, and faster.

We announced the availability of Oracle GoldenGate 11gR2 via a press release. If you haven’t seen it yet, please check it out. As covered in this announcement, there are a variety of improvements in the product:

  • Integrated Capture for Oracle Database: brings Oracle GoldenGate’s Capture process closer to the Oracle Database engine and enables support for Advanced Compression among other benefits.
  • Enhanced Conflict Detection & Resolution, speeds and simplifies the conflict detection and resolution process for Active-Active deployments.
  • Globalization, meaning Oracle GoldenGate can be deployed for databases that use multi-byte/Unicode character sets.
  • Security and Performance Improvements, includes support Federal Information Protection Standard (FIPS).
  • Increased Extensibility by kicking off actions based on an event record in the transaction log or in the Trail file.
  • Integration with Oracle Enterprise Manager 12c , in addition to the Oracle GoldenGate Monitor product.
  • Expanded Heterogeneity, including capture from IBM DB2 for i on iSeries (AS/400) and delivery to Postgres

We will explain these new features in more detail at our upcoming launch webcast:

(Sept 12 8am/10am PT)

In addition to learning more about these new features, the webcast will allow you to ask your questions to product management via live Q&A section. So, I hope you will not miss this opportunity to explore the new release of Oracle GoldenGate 11g and see how it can deliver enterprise-class real-time data integration solutions..

I look forward to a great webcast to unveil GoldenGate’s new capabilities.

About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today