Book Image

Oracle Goldengate 11g Complete Cookbook

By : Ankur Gupta
Book Image

Oracle Goldengate 11g Complete Cookbook

By: Ankur Gupta

Overview of this book

Oracle Goldengate 11g Complete Cookbook is your complete guide to all aspects of Goldengate administration. The recipes in this book will teach you how to setup Goldengate configurations for simple and complex environments requiring various filtering and transformations. It also covers various aspects of tuning and troubleshooting the replication setups using exception handling, custom fields, and logdump utility.The book begins by explaining some basic tasks like Installation and Process groups setup. You will then be introduced to some further topics including DDL replication and various options to perform Initial Loads. You will then learn some advanced administration tasks such as Multi Master replication setup and conflict resolution. Further recipes, contain the cross platform replication and high availability options for Goldengate.
Table of Contents (16 chapters)
Oracle GoldenGate 11g Complete Cookbook
About the Author
About the Reviewers

Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS

In this recipe we will see how to create a GoldenGate configuration using ACFS as a shared storage filesystem and Oracle Clusterware to manage the high availability.

Getting ready

For this recipe, we have a two-node Oracle RAC database in the source environment. The new ACFS filesystem for GoldenGate will be created on the DATA diskgroup. We would also need an additional IP on the public network in the cluster as that will be used for GoldenGate's high availability and communication. This IP ( has been added to /etc/hosts on both nodes with a ggate_vip alias.

How to do it...

The following steps show how we can create an ACFS filesystem, install GoldenGate on it and configure it for high availability using Oracle Clusterware. The high availability setup required in the target environment would be similar to that of the source environment.

Follow these steps to set up an ACFS filesystem...