Guenadi N Jilevski's Oracle BLOG

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

Implement classic bi-directional DML and DDL replication between two Oracle RAC databases using OGG 11.2 – Download

Implement classic bi-directional DML and DDL replication between two Oracle RAC databases using OGG 11.2 – Download

In the article you will have a look at an example of how to build a classic bi-directional DML and DDL replication between two Oracle RAC databases. The environment consist of a two node Oracle 11.2.0.3 cluster running a source database RACD (11.2.0.3) and a target database RACDB (11.2.0.3) and is described here and here. Examples are based on OGG classic extract method and the data type limitations exist as described in the official OGG documentation here. Integrated extract method reduces data type limitations but requires Oracle database 11.2.0.3 and a database specific bundle patch for Integrated Extract 11.2.x (Doc ID 1411356.1).
For Exadata 11.2.0.3 databases, the EXADATA_11.2.0.3_BP3 patch (11.2.0.3.3) should be used. The patch is available from the support site referencing patch 13556853. For non-Exadata 11.2.0.3 database, you need to apply patch 13560925 which is available on the support site referencing the patch number.

Read online from here or download Implement bi-directional DML and DDL replication between two Oracle RAC 11.2.0.3 databases using OGG 11.2

July 17, 2012 - Posted by | oracle

3 Comments »

  1. […] In this article you will have a look at some basic fundamentals related to keys, supplemental logging and before and after images related to deploying OGG for transactional data replication using Oracle RDBMS as a source and/or target database. I will cover some OGG related concepts and you will glimpse at some practical test as an illustration. The concepts covered in the article apply to both CLASSIC and INTEGRATED capture, introduced in OGG 11gR2, once the specifics and nature of each capture methods are understood and taken into account. For information related to OGG setup look at here. […]

    Pingback by Oracle GoldenGate OGG 11gR2 with Oracle RDBMS – Fundamentals (PK/UK, substitute keys KEYCOLS, ADD TRANDATA, Before and After images and they how work together) « Guenadi N Jilevski's Oracle BLOG | October 15, 2012 | Reply

  2. […] In this article you will have a look at some basic fundamentals related to keys, supplemental logging and before and after images related to deploying OGG for transactional data replication using Oracle RDBMS as a source and/or target database. I will cover some OGG related concepts and you will glimpse at some practical test as an illustration. The concepts covered in the article apply to both CLASSIC and INTEGRATED capture, introduced in OGG 11gR2, once the specifics and nature of each capture methods are understood and taken into account. For information related to OGG setup look at here. […]

    Pingback by Oracle GoldenGate OGG 11gR2 with Oracle RDBMS – Fundamentals (PK/UK, substitute keys KEYCOLS, ADD TRANDATA, Before and After images and they how work together) – Download « Guenadi N Jilevski's Oracle BLOG | October 15, 2012 | Reply

  3. Later app these clean ideas within the writings could induce several enchantment inside write-ups. The facts are, these are too lazy to master the rules and think they’re able to get away with this by brushing punctuation off as unimportant.

    Comment by me | March 22, 2014 | 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

%d bloggers like this: