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

Steps to compare data between the source and target environment using Oracle GoldenGate Veridata

In this recipe, you will learn how to use Oracle GoldenGate Veridata to compare data between the source and target environments.

Getting ready

For this recipe, we will refer to the GoldenGate setup done in the Setting up a simple GoldenGate replication configuration between two single node databases recipe in Chapter 2, Setting up GoldenGate Replication. We will set up GoldenGate Veridata Java Agents on these two GoldenGate instances and perform a data comparison through Veridata. For the GoldenGate Veridata server setup, we will refer to the previous recipe.

How to do it...

The steps to set up a Veridata comparison between the source and target databases are as follows:

  1. Copy the Veridata Java client binaries to the source server (prim1-ol6-112.localdomain). The Java client binaries can be downloaded from the oracle otn/edelivery website.

  2. Extract the contents of the Agent binaries into a temporary...