Oracle Goldengate 11g Complete Cookbook

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

Steps to install Oracle GoldenGate Veridata

Steps to set up the GoldenGate monitoring using OEM 12c

Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances

Installing Oracle GoldenGate Director

Setting up Oracle GoldenGate Monitor Agents

Setting up the Oracle GoldenGate Monitor server

Introduction

Chapter 9. GoldenGate Veridata Director and Monitor

Creating a multimaster GoldenGate replication configuration

Cross RDBMS replication using GoldenGate

GoldenGate Administration role separation from the DBA team

Migrating from an Oracle Streams environment to Oracle GoldenGate

Replicating data from an active standby database in Archivelog mode only

Creating a GoldenGate configuration with a consistent state behind the target database

Introduction

Chapter 8. Advanced Administration Tasks – Part II

Creating an Integrated Capture with a downstream database for compressed tables

Undoing the applied changes using the reverse utility

Resolving GoldenGate errors using the logdump utility

Table structure changes in GoldenGate environments with different table definitions

Table structure changes in GoldenGate environments with similar table definitions

Upgrading Oracle GoldenGate binaries

Introduction

Chapter 7. Advanced Administration Tasks – I

Steps to implement a Heartbeat mechanism for the GoldenGate replication

Steps to re-instantiate a failed GoldenGate configuration

Steps to measure throughput of a GoldenGate configuration

Script to perform a regular scheduled healthcheck of a live GoldenGate configuration

Performing a healthcheck of a live GoldenGate configuration

Optimizing the network settings for a GoldenGate configuration

Splitting the replication load into multiple process groups for optimal performance

Steps to configure a BATCHSQL mode

Introduction

Chapter 6. Monitoring Tuning and Troubleshooting GoldenGate

Creating a set of parallel load balanced highly available GoldenGate configurations using Oracle Clusterware and DBFS

Automatic failover of a DBFS-based configuration

Manually switching over Oracle Clusterware-based configuration to the other node

Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS

Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2

Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS

Choosing a GoldenGate high availability option

Introduction

Chapter 5. Oracle GoldenGate High Availability

Creating an exception handler to record the erroneous transactions in a GoldenGate configuration

Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated

Mapping the changes to a target table and storing the transaction history in a history table

Filtering the records using the FILTER and WHERE clause

Adding custom fields to a replicated record using SQLEXEC

Adding custom fields for a replicated record using tokens

Setting up a GoldenGate replication with mapping between different columns

Introduction

Chapter 4. Mapping and Manipulating Data

Loading data with bulk load to the SQL loader method

Loading data with the GoldenGate direct load method

Loading data with files to the database utility method

Loading data using trail files to the Replicat process method

Performing an initial load using an extract file to the GoldenGate's replicat method

Performing an initial load using GoldenGate

Setting up a GoldenGate DDL replication and verifying the changes

Performing an initial setup required for GoldenGate DDL replication

Introduction

Chapter 3. DDL Replication and Initial Load

Setting up a GoldenGate replication between tables with different structures using defgen

Encrypting the trail files

Encrypting database user passwords

Generating encryption keys

Verifying the data transfer on the target system

Determining the size of trail file areas

Setting up a GoldenGate replication between Oracle RAC databases

Configuring an Extract process to read from an Oracle ASM instance

Setting up a GoldenGate replication with multiple process groups

Setting up a simple GoldenGate replication configuration between two single node databases

Introduction

Chapter 2. Setting up GoldenGate Replication

Setting up a Replicat process

Setting up a Datapump process

Setting up an Integrated Capture Extract process

Setting up a Classic Capture Extract process

Setting up a Manager process

Preparing the target database for GoldenGate setup

Preparing the source database for GoldenGate setup

Supported datatypes in Oracle GoldenGate

Enabling supplemental logging in the source database

Installing Oracle GoldenGate in a Windows environment

Installing Oracle GoldenGate in a x86_64 Linux-based environment

Introduction

Chapter 1. Installation and Initial Setup

Preface

www.PacktPub.com

About the Reviewers

About the Author

Credits

版权信息

封面

封面

版权信息

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Chapter 1. Installation and Initial Setup

Introduction

Installing Oracle GoldenGate in a x86_64 Linux-based environment

Installing Oracle GoldenGate in a Windows environment

Enabling supplemental logging in the source database

Supported datatypes in Oracle GoldenGate

Preparing the source database for GoldenGate setup

Preparing the target database for GoldenGate setup

Setting up a Manager process

Setting up a Classic Capture Extract process

Setting up an Integrated Capture Extract process

Setting up a Datapump process

Setting up a Replicat process

Chapter 2. Setting up GoldenGate Replication

Introduction

Setting up a simple GoldenGate replication configuration between two single node databases

Setting up a GoldenGate replication with multiple process groups

Configuring an Extract process to read from an Oracle ASM instance

Setting up a GoldenGate replication between Oracle RAC databases

Determining the size of trail file areas

Verifying the data transfer on the target system

Generating encryption keys

Encrypting database user passwords

Encrypting the trail files

Setting up a GoldenGate replication between tables with different structures using defgen

Chapter 3. DDL Replication and Initial Load

Introduction

Performing an initial setup required for GoldenGate DDL replication

Setting up a GoldenGate DDL replication and verifying the changes

Performing an initial load using GoldenGate

Performing an initial load using an extract file to the GoldenGate's replicat method

Loading data using trail files to the Replicat process method

Loading data with files to the database utility method

Loading data with the GoldenGate direct load method

Loading data with bulk load to the SQL loader method

Chapter 4. Mapping and Manipulating Data

Introduction

Setting up a GoldenGate replication with mapping between different columns

Adding custom fields for a replicated record using tokens

Adding custom fields to a replicated record using SQLEXEC

Filtering the records using the FILTER and WHERE clause

Mapping the changes to a target table and storing the transaction history in a history table

Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated

Creating an exception handler to record the erroneous transactions in a GoldenGate configuration

Chapter 5. Oracle GoldenGate High Availability

Introduction

Choosing a GoldenGate high availability option

Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS

Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2

Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS

Manually switching over Oracle Clusterware-based configuration to the other node

Automatic failover of a DBFS-based configuration

Creating a set of parallel load balanced highly available GoldenGate configurations using Oracle Clusterware and DBFS

Chapter 6. Monitoring Tuning and Troubleshooting GoldenGate

Introduction

Steps to configure a BATCHSQL mode

Splitting the replication load into multiple process groups for optimal performance

Optimizing the network settings for a GoldenGate configuration

Performing a healthcheck of a live GoldenGate configuration

Script to perform a regular scheduled healthcheck of a live GoldenGate configuration

Steps to measure throughput of a GoldenGate configuration

Steps to re-instantiate a failed GoldenGate configuration

Steps to implement a Heartbeat mechanism for the GoldenGate replication

Chapter 7. Advanced Administration Tasks – I

Introduction

Upgrading Oracle GoldenGate binaries

Table structure changes in GoldenGate environments with similar table definitions

Table structure changes in GoldenGate environments with different table definitions

Resolving GoldenGate errors using the logdump utility

Undoing the applied changes using the reverse utility

Creating an Integrated Capture with a downstream database for compressed tables

Chapter 8. Advanced Administration Tasks – Part II

Introduction

Creating a GoldenGate configuration with a consistent state behind the target database

Replicating data from an active standby database in Archivelog mode only

Migrating from an Oracle Streams environment to Oracle GoldenGate

GoldenGate Administration role separation from the DBA team

Cross RDBMS replication using GoldenGate

Creating a multimaster GoldenGate replication configuration

Chapter 9. GoldenGate Veridata Director and Monitor

Introduction

Setting up the Oracle GoldenGate Monitor server

Setting up Oracle GoldenGate Monitor Agents

Installing Oracle GoldenGate Director

Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances

Steps to set up the GoldenGate monitoring using OEM 12c

Steps to install Oracle GoldenGate Veridata

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