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

Setting up a simple GoldenGate replication configuration between two single node databases

In this recipe we will look at how to configure GoldenGate for continuous replication between two single node databases.

Getting ready

For this setup, we make the following assumptions:

  1. The source and target database have already been set up.

  2. Both the databases have a schema called SCOTT which is in a consistent state. No transformations will be performed in this recipe.

  3. Oracle GoldenGate binaries are already installed in both sites.

  4. The extract method used in this example will be classic capture.

  5. Supplemental Logging is enabled at database and table level for all the objects to be replicated.

How to do it...

We will follow these steps to set up this replication configuration.

Perform the following steps in the source database:

  1. Set up the GoldenGate user. Run the following command in the source database:

    sqlplus sys/**** as sysdba