Oracle Goldengate 11g Complete Cookbook

Over 60 simple and easy-to-follow recipes to perform various Goldengate administration tasks such as installing, configuring, and maintaining Goldengate replication

Overview

• Various recipes that will help you to set up Goldengate in various environments
• Practical examples of Goldengate management tasks
• Step by step instructions with various examples and scripts

In Detail

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.

What you will learn from this book

• Configure DML and DDL Goldengate replication
• Tune and Troubleshoot Goldengate replication
• Cross Platform replication using Goldengate
• Monitor Goldengate Replication using OEM 12c
• What to do when GoldenGate replication breaks
• Reverse changes applied by Goldengate
• High Availability Setup for Goldengate
• Learn about GoldenGate Veridata and GoldenGate Director
• Migrate Oracle Streams environment to Goldengate

Approach

Oracle Goldengate 11g Complete Cookbook follows the Cookbook style. Each recipe provides step by step instructions with various examples and scripts. This book provides the necessary information to successfully complete most of the possible administration tasks.

Who this book is written for

Oracle Goldengate 11g Complete Cookbook is aimed at Database Administrators, Architects, and Middleware Administrators who are keen to know more about Oracle Goldengate. Whether you are handling Goldengate environments on a day-to-day basis, or using it just for migration, this book provides the necessary information required to successfully complete your administration tasks. The reader is expected to have some knowledge of Oracle databases.

Table of Contents

Chapter 1: Installation and Initial Setup
Chapter 2: Setting up GoldenGate Replication
Chapter 3: DDL Replication and Initial Load
Chapter 4: Mapping and Manipulating Data
Chapter 5: Oracle GoldenGate High Availability
Chapter 6: Monitoring, Tuning and Troubleshooting GoldenGate
Chapter 7: Advanced Administration Tasks – I
Chapter 8: Advanced Administration Tasks – Part II
Chapter 9: GoldenGate Veridata, Director, and Monitor