Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration – Download

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration – Download

In the article you will have a look at an example for CDR implementation based on a balance and timestamp column in a bidirectional active-active OGG setup. I will build an active-active bidirectional OGG replication between two sites (RACD, RACDB) each having identical tables (test5.account, test5.seat_assignment). I will emphasize on the requirements for CDR implementation and will outline CDR concepts and illustrate a step-by step CDR implementation, testing and troubleshooting. I will cover two cases

  • Use delta method for account balance CDR – An initial balance of 1000 will be simultaneously credited 200 on site B and debited 100 on site A. The result will be 1100 on both site A and site B.
  • Use USEMIN timestamp method for seat booking CDR – a seat ‘2A’ will be booked 1st by John Smith on site A and at about the same time will be booked by Pier Cardin on site B. The result will be the first user on both site A and site B.

Starting with OGG 11gR2 there are build in options in the MAP replicat parameter, such as COMPARECOLS, RESOLVECONFLICT, and in the TABLE extract parameter, such as GETBEFORECOLS, allowing easy, automatic and OGG driven CDR compared to the methods involving SQL or PLSQL code invoked from SQLEXEC used for CDR in versions of OGG prior to 11gR2.

Read online from here or download Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration

November 8, 2012 - Posted by | oracle

2 Comments »

  1. [...] that will be used for replication and subsequent verification with Veridata comparison is described here. The article will briefly cover the following [...]

    Pingback by Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2 « Guenadi N Jilevski's Oracle BLOG | November 18, 2012 | Reply

  2. [...] will be used for replication and subsequent verification with Veridata comparison is described here. The article will briefly cover the following [...]

    Pingback by Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2 – Download « Guenadi N Jilevski's Oracle BLOG | November 18, 2012 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 778 other followers

%d bloggers like this: