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
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Optimizing the network settings for a GoldenGate configuration


You can use GoldenGate to replicate data between two schemas within the same database; however, in most cases you will use GoldenGate to replicate the data between two databases that are running on different systems. These systems can be quite far from each other in different locations. One of the key functions performed by the GoldenGate processes is transferring the files to the remote destination. Even though you have the best tuned database with a well-tuned GoldenGate Replicat process, it will not apply any changes if they are not transferred to the target system by the Extract/Datapump process. In order to transfer the data efficiently and make the best use of the network, there are certain things that you need to consider and tune at the GoldenGate and operating system level. In this recipe, we will look at the configuration required to ensure an efficient transfer of GoldenGate trail files between two systems.

Getting...