Oracle Goldengate 11g Complete Cookbook电子书

Oracle GoldenGate 11g Complete Cookbook

Table of Contents

Oracle GoldenGate 11g Complete Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Installation and Initial Setup

Introduction

Installing Oracle GoldenGate in a x86_64 Linux-based environment

Getting ready

How to do it...

How it works...

Installing Oracle GoldenGate in a Windows environment

Getting ready

How to do it...

How it works...

Enabling supplemental logging in the source database

Getting ready

How to do it…

How it works…

There's more…

See also

Supported datatypes in Oracle GoldenGate

Getting ready

How to do it…

How it works…

There's more…

Preparing the source database for GoldenGate setup

Getting ready

How to do it…

How it works…

There's more…

The Classic Capture mode

The Integrated Capture mode

See also

Preparing the target database for GoldenGate setup

Getting ready

How to do it…

How it works…

There's more…

Setting up a Manager process

Getting ready

How to do it…

How it works…

There's more…

Setting up a Classic Capture Extract process

Getting ready

How to do it…

How it works…

There's more…

See also

Setting up an Integrated Capture Extract process

Getting ready

How to do it…

How it works…

There's more…

See also

Setting up a Datapump process

Getting ready

How to do it…

How it works…

There's more…

See also

Setting up a Replicat process

Getting ready

How to do it…

How it works…

There's more…

See also

2. Setting up GoldenGate Replication

Introduction

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

Getting ready

How to do it...

How it works...

There's more...

See also

Setting up a GoldenGate replication with multiple process groups

Getting ready

How to do it...

How it works...

There's more...

See also

Configuring an Extract process to read from an Oracle ASM instance

How to do it…

How it works…

Setting up a GoldenGate replication between Oracle RAC databases

Getting ready

How to do it…

How it works…

See also

Determining the size of trail file areas

How to do it…

How it works...

Verifying the data transfer on the target system

Getting ready

How to do it...

How it works…

There's more...

Generating encryption keys

How to do it…

How it works…

Encrypting database user passwords

Getting ready

How to do it…

How it works…

Encrypting the trail files

Getting ready

How to do it…

How it works…

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

Getting ready

How to do it…

How it works…

See also

3. DDL Replication and Initial Load

Introduction

Performing an initial setup required for GoldenGate DDL replication

Getting ready

How to do it...

How it works...

There's more...

See also

Setting up a GoldenGate DDL replication and verifying the changes

Getting ready

How to do it...

How it works...

There's more...

Extra privileges that are required for the GoldenGate Admin user

Filtering and mapping

Additional DDLOPTIONS

Performing an initial load using GoldenGate

Getting ready

How to do it...

How it works...

There's more...

Extract file to the Replicat method

Trail to the Replicat method

File to the database utility method

GoldenGate direct load method

Direct bulk load to SQL loader method

See also

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

Getting ready

How to do it...

How it works...

There's more...

Loading data using trail files to the Replicat process method

Getting ready

How to do it...

How it works...

Loading data with files to the database utility method

Getting ready

How to do it...

How it works...

There's more...

See also

Loading data with the GoldenGate direct load method

Getting ready

How to do it...

How it works...

There's more...

Loading data with bulk load to the SQL loader method

Getting ready

How to do it...

How it works...

4. Mapping and Manipulating Data

Introduction

Setting up a GoldenGate replication with mapping between different columns

Getting ready

How to do it...

How it works...

There's more...

Source environment mapping

Defining global mappings

Defining mappings using prefix/suffix

See also

Adding custom fields for a replicated record using tokens

Getting ready

How to do it...

How it works...

There's more...

See also

Adding custom fields to a replicated record using SQLEXEC

Getting ready

How to do it...

How it works...

There's more...

Running a stored procedure with SQLEXEC

Running a global SQL statement/procedure

Filtering the records using the FILTER and WHERE clause

Getting ready

How to do it...

How it works...

There's more...

Using the Where clause

Filtering in the source environment

Filtering the records into parallel groups

See also

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

Getting ready

How to do it...

How it works...

See also

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

Getting ready

How to do it...

How it works...

There's more...

See also

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

Getting ready

How to do it...

How it works...

There's more...

MAPEXCEPTION method

Handle exceptions with a MACRO

See also

5. Oracle GoldenGate High Availability

Introduction

Choosing a GoldenGate high availability option

Getting ready

How to do it...

How it works...

There's more…

Oracle Cluster File System (OCFS2)

Database File System (DBFS)

ASM Cluster File System (ACFS)

See also

Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS

Getting ready

How to do it...

How it works...

Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2

Getting ready

How to do it...

How it works...

Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS

Getting ready

How to do it...

How it works...

See also

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

Getting ready

How to do it...

How it works...

Automatic failover of a DBFS-based configuration

Getting ready

How to do it...

How it works...

There's more...

Manual relocation of a DBFS-based GoldenGate configuration

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

Getting ready

How to do it...

How it works...

See also

6. Monitoring, Tuning, and Troubleshooting GoldenGate

Introduction

Steps to configure a BATCHSQL mode

How to do it...

How it works...

There's more…

See also

Splitting the replication load into multiple process groups for optimal performance

How to do it...

How it works...

There's more…

The RANGE function

See also

Optimizing the network settings for a GoldenGate configuration

Getting ready

How to do it...

How it works...

Performing a healthcheck of a live GoldenGate configuration

How to do it...

How it works...

See also

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

Getting ready

How to do it...

How it works...

See also

Steps to measure throughput of a GoldenGate configuration

Getting ready

How to do it...

How it works...

There's more...

Stats command options

See also

Steps to re-instantiate a failed GoldenGate configuration

Getting ready

How to do it...

How it works...

See also

Steps to implement a Heartbeat mechanism for the GoldenGate replication

Getting ready

How to do it...

How it works...

There's more...

See also

7. Advanced Administration Tasks – I

Introduction

Upgrading Oracle GoldenGate binaries

Getting ready

How to do it...

How it works...

Table structure changes in GoldenGate environments with similar table definitions

Getting ready

How to do it…

How it works...

There's more...

Specific tables defined in GoldenGate parameter files

Individual table permissions granted to the GoldenGate Admin user

Supplemental logging for modified tables without any keys

Supplemental log groups with all columns for modified tables

See also

Table structure changes in GoldenGate environments with different table definitions

Getting ready

How to do it...

How it works...

There's more…

Individual table permissions granted to the GoldenGate Admin user

Supplemental logging for modified tables without any keys

Supplemental log groups with all columns for modified tables

Resolving GoldenGate errors using the logdump utility

Getting ready

How to do it...

How it works...

There's more...

Count

Scan for timestamp

Filter on SCN

See also

Undoing the applied changes using the reverse utility

Getting ready

How to do it...

How it works...

There's more...

Creating an Integrated Capture with a downstream database for compressed tables

Getting ready

How to do it...

How it works...

8. Advanced Administration Tasks – Part II

Introduction

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

Getting ready

How to do it...

How it works...

There's more…

Why use deferred apply

DEFERAPPLYINTERVAL UNITS

See also

Replicating data from an active standby database in Archivelog mode only

Getting ready

How to do it…

How it works...

Migrating from an Oracle Streams environment to Oracle GoldenGate

Getting ready

How to do it...

How it works...

GoldenGate Administration role separation from the DBA team

Getting ready

How to do it…

How it works...

Cross RDBMS replication using GoldenGate

Getting ready

How to do it...

How it works...

Creating a multimaster GoldenGate replication configuration

Getting ready

How to do it...

How it works...

There's more…

Data collision avoidance

Data collision resolution

Timestamp-based

Defined trusted source

9. GoldenGate Veridata, Director, and Monitor

Introduction

Setting up the Oracle GoldenGate Monitor server

Getting ready

How to do it...

How it works...

There's more…

Installing the GoldenGate Monitor server using HTTPS

See also

Setting up Oracle GoldenGate Monitor Agents

Getting ready

How to do it…

How it works...

There's more…

Installing Oracle GoldenGate Director

Getting ready

How to do it...

How it works...

See also

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

Getting ready

How to do it...

How it works...

Steps to set up the GoldenGate monitoring using OEM 12c

Getting ready

How to do it...

How it works...

There's more...

Steps to install Oracle GoldenGate Veridata

Getting ready

How to do it...

How it works...

See also

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

Getting ready

How to do it...

How it works...

Index