Guenadi N Jilevski's Oracle BLOG

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

Installing Oracle GoldenGate (OGG) 11.2.1.0.1 in an Oracle cluster 11.2.0.3 (ACFS) and configuring a direct load and classic Change Data Capture (CDC) and Data Apply – Download

Installing Oracle GoldenGate (OGG) 11.2.1.0.1 in an Oracle cluster 11.2.0.3 (ACFS) and configuring a direct load and classic Change Data Capture (CDC) and Data Apply – Download

In the article you will have a look at the OGG 11.2.1.0.1 installation and an example of a classic CDC configuration, initial data load and Data apply. The environment is a two node Oracle RAC cluster running Oracle GI 11.2.0.3 and Oracle RAC RDBMS 11.2.0.3 and Oracle RAC RDBMS 10.2.0.5 described here and here. An ACFS mount point /u02 is created to host the OGG installation directory. The source schema and target schemas are as described in the following table. Both RACD and RACDB are two node databases using ASM. This article applies only to OGG using Oracle database as a target and source. For different databases the same OGG concept applies but setup and parameters are different.

You could read online from here or download Installing Oracle GoldenGate (OGG) 11.2.1.0.1 in a Oracle cluster 11.2.0.3 (ACFS) and configuring a direct load and Change Data Capture (CDC) and Data Apply


July 8, 2012 Posted by | oracle | 5 Comments

Installing Oracle GoldenGate (OGG) 11.2.1.0.1 in an Oracle cluster 11.2.0.3 (ACFS) and configuring a direct load and classic Change Data Capture (CDC) and Data Apply

Installing Oracle GoldenGate (OGG) 11.2.1.0.1 in an Oracle cluster 11.2.0.3 (ACFS) and configuring a direct load and classic Change Data Capture (CDC) and Data Apply

In the article you will have a look at the OGG 11.2.1.0.1 installation and an example of a classic CDC configuration, initial data load and Data apply. The environment is a two node Oracle RAC cluster running Oracle GI 11.2.0.3 and Oracle RAC RDBMS 11.2.0.3 and Oracle RAC RDBMS 10.2.0.5 described here and here. An ACFS mount point /u02 is created to host the OGG installation directory. The source schema and target schemas are as described in the following table. Both RACD and RACDB are two node databases using ASM. This article applies only to OGG using Oracle database as a target and source. For different databases the same OGG concept applies but setup and parameters are different.
Continue reading

July 8, 2012 Posted by | oracle | 3 Comments