book

Oracle Goldengate 11g Complete Cookbook

Name: Oracle Goldengate 11g Complete Cookbook
Author: Ankur Gupta
ISBN: 9781849686143

by Ankur Gupta

September 2013

Intermediate to advanced

362 pages

7h 56m

English

Packt Publishing

Read now

Unlock full access

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 moreWhy Subscribe?Free Access for Packt account holdersInstant 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 codeErrataPiracyQuestions
1. Installation and Initial Setup
Introduction
Installing Oracle GoldenGate in a x86_64 Linux-based environment
Getting readyHow to do it...How it works...
Installing Oracle GoldenGate in a Windows environment
Getting readyHow to do it...How it works...
Enabling supplemental logging in the source database
Getting readyHow to do it…How it works…There's more…See also
Supported datatypes in Oracle GoldenGate
Getting readyHow to do it…How it works…There's more…
Preparing the source database for GoldenGate setup
Getting readyHow to do it…How it works…There's more…The Classic Capture modeThe Integrated Capture modeSee also
Preparing the target database for GoldenGate setup
Getting readyHow to do it…How it works…There's more…
Setting up a Manager process
Getting readyHow to do it…How it works…There's more…
Setting up a Classic Capture Extract process
Getting readyHow to do it…How it works…There's more…See also
Setting up an Integrated Capture Extract process
Getting readyHow to do it…How it works…There's more…See also
Setting up a Datapump process
Getting readyHow to do it…How it works…There's more…See also
Setting up a Replicat process
Getting readyHow 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 readyHow to do it...How it works...There's more...See also
Setting up a GoldenGate replication with multiple process groups
Getting readyHow 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 readyHow 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 readyHow to do it...How it works…There's more...
Generating encryption keys
How to do it…How it works…
Encrypting database user passwords
Getting readyHow to do it…How it works…
Encrypting the trail files
Getting readyHow to do it…How it works…
Setting up a GoldenGate replication between tables with different structures using defgen
Getting readyHow 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 readyHow to do it...How it works...There's more...See also
Setting up a GoldenGate DDL replication and verifying the changes
Getting readyHow to do it...How it works...There's more...Extra privileges that are required for the GoldenGate Admin userFiltering and mappingAdditional DDLOPTIONS
Performing an initial load using GoldenGate
Getting readyHow to do it...How it works...There's more...Extract file to the Replicat methodTrail to the Replicat methodFile to the database utility methodGoldenGate direct load methodDirect bulk load to SQL loader methodSee also
Performing an initial load using an extract file to the GoldenGate's replicat method
Getting readyHow to do it...How it works...There's more...
Loading data using trail files to the Replicat process method
Getting readyHow to do it...How it works...
Loading data with files to the database utility method
Getting readyHow to do it...How it works...There's more...See also
Loading data with the GoldenGate direct load method
Getting readyHow to do it...How it works...There's more...
Loading data with bulk load to the SQL loader method
Getting readyHow to do it...How it works...
4. Mapping and Manipulating Data
Introduction
Setting up a GoldenGate replication with mapping between different columns
Getting readyHow to do it...How it works...There's more...Source environment mappingDefining global mappingsDefining mappings using prefix/suffixSee also
Adding custom fields for a replicated record using tokens
Getting readyHow to do it...How it works...There's more...See also
Adding custom fields to a replicated record using SQLEXEC
Getting readyHow to do it...How it works...There's more...Running a stored procedure with SQLEXECRunning a global SQL statement/procedure
Filtering the records using the FILTER and WHERE clause
Getting readyHow to do it...How it works...There's more...Using the Where clauseFiltering in the source environmentFiltering the records into parallel groupsSee also
Mapping the changes to a target table and storing the transaction history in a history table
Getting readyHow 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 readyHow 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 readyHow to do it...How it works...There's more...MAPEXCEPTION methodHandle exceptions with a MACROSee also
5. Oracle GoldenGate High Availability
Introduction
Choosing a GoldenGate high availability option
Getting readyHow 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 readyHow to do it...How it works...
Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2
Getting readyHow to do it...How it works...
Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS
Getting readyHow to do it...How it works...See also
Manually switching over Oracle Clusterware-based configuration to the other node
Getting readyHow to do it...How it works...
Automatic failover of a DBFS-based configuration
Getting readyHow 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 readyHow 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 functionSee also
Optimizing the network settings for a GoldenGate configuration
Getting readyHow 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 readyHow to do it...How it works...See also
Steps to measure throughput of a GoldenGate configuration
Getting readyHow to do it...How it works...There's more...Stats command optionsSee also
Steps to re-instantiate a failed GoldenGate configuration
Getting readyHow to do it...How it works...See also
Steps to implement a Heartbeat mechanism for the GoldenGate replication
Getting readyHow to do it...How it works...There's more...See also
7. Advanced Administration Tasks – I
Introduction
Upgrading Oracle GoldenGate binaries
Getting readyHow to do it...How it works...
Table structure changes in GoldenGate environments with similar table definitions
Getting readyHow to do it…How it works...There's more...Specific tables defined in GoldenGate parameter filesIndividual table permissions granted to the GoldenGate Admin userSupplemental logging for modified tables without any keysSupplemental log groups with all columns for modified tablesSee also
Table structure changes in GoldenGate environments with different table definitions
Getting readyHow to do it...How it works...There's more…Individual table permissions granted to the GoldenGate Admin userSupplemental logging for modified tables without any keysSupplemental log groups with all columns for modified tables
Resolving GoldenGate errors using the logdump utility
Getting readyHow to do it...How it works...There's more...CountScan for timestampFilter on SCNSee also
Undoing the applied changes using the reverse utility
Getting readyHow to do it...How it works...There's more...
Creating an Integrated Capture with a downstream database for compressed tables
Getting readyHow 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 readyHow to do it...How it works...There's more…Why use deferred applyDEFERAPPLYINTERVAL UNITSSee also
Replicating data from an active standby database in Archivelog mode only
Getting readyHow to do it…How it works...
Migrating from an Oracle Streams environment to Oracle GoldenGate
Getting readyHow to do it...How it works...
GoldenGate Administration role separation from the DBA team
Getting readyHow to do it…How it works...
Cross RDBMS replication using GoldenGate
Getting readyHow to do it...How it works...
Creating a multimaster GoldenGate replication configuration
Getting readyHow to do it...How it works...There's more…Data collision avoidanceData collision resolutionTimestamp-basedDefined trusted source
9. GoldenGate Veridata, Director, and Monitor
Introduction
Setting up the Oracle GoldenGate Monitor server
Getting readyHow to do it...How it works...There's more…Installing the GoldenGate Monitor server using HTTPSSee also
Setting up Oracle GoldenGate Monitor Agents
Getting readyHow to do it…How it works...There's more…
Installing Oracle GoldenGate Director
Getting readyHow to do it...How it works...See also
Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances
Getting readyHow to do it...How it works...
Steps to set up the GoldenGate monitoring using OEM 12c
Getting readyHow to do it...How it works...There's more...
Steps to install Oracle GoldenGate Veridata
Getting readyHow to do it...How it works...See also
Steps to compare data between the source and target environment using Oracle GoldenGate Veridata
Getting readyHow to do it...How it works...
Index

Content preview from Oracle Goldengate 11g Complete Cookbook

Supported datatypes in Oracle GoldenGate

Oracle GoldenGate has some restrictions in terms of what it can replicate. With every new release, Oracle is adding new datatypes to the list of what is supported. The list of the datatypes of the objects that you are planning to replicate should be checked against the list of supported datatypes for the GoldenGate version that you are planning to install.

Getting ready

You should have identified the various datatypes of the objects that you plan to replicate.

How to do it…

The following is a high-level list of the datatypes that are supported by Oracle GoldenGate v11.2.1.0.1:

NUMBER
BINARY FLOAT
BINARY DOUBLE
CHAR
VARCHAR2
LONG
NCHAR
NVARCHAR2
RAW
LONG RAW
DATE
TIMESTAMP
CLOB
NCLOB
BLOB
SECUREFILE and BASICFILE
XML datatypes ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Oracle Database 11gR2 Performance Tuning Cookbook

Publisher Resources

ISBN: 9781849686143Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design