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


When GoldenGate is used in some of the topologies where the source and target systems are not identical, you would most likely be required to perform some additional configuration. GoldenGate has got many additional parameters and options using which you can set up complex mappings and filtering. Data Lifecycle management is becoming an important part of the overall IT strategy of various companies. The regulatory requirements in some industries require the businesses to maintain a record of upto seven years or even longer. In such cases if you keep all the data in main database tables it can cause performance problems. Using GoldenGate you can track the changes applied on a table to maintain a transaction history without much impact on the production system. It also allows you to track the replication errors using exception handling.

Using GoldenGate macros, you can write the process configuration parameters once and reuse them in multiple parameter files in a single environment...