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

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

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

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.
Continue reading

July 17, 2012 Posted by | oracle | 7 Comments