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

Creating an Integrated Capture with a downstream database for compressed tables


Logical replication between two databases is a complex task. The level of complexity is quite dependent on the data types of the underlying data that you are replicating. When you add additional features offered by an Oracle database, for example compression, the complexity increases further. Until quite recently, Oracle GoldenGate did not support replicating data from a source database where the data was stored in compressed tables. With the launch of Oracle GoldenGate 11gR2, Oracle has added a new capture mode called Integrated Capture using which you can extract data from compressed tables. The Integrated Capture uses a logminer dictionary which you can either place in the source database itself, or in a separate database called the downstream database. In this recipe we will see how we can create an Integrated Capture extract to read data from compressed tables with a logminer dictionary created in a downstream...