Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle Goldengate 11g Complete Cookbook
  • Table Of Contents Toc
Oracle Goldengate 11g Complete Cookbook

Oracle Goldengate 11g Complete Cookbook

By : Ankur Gupta
3.7 (9)
Buy this Book
close
close
Oracle Goldengate 11g Complete Cookbook

Oracle Goldengate 11g Complete Cookbook

3.7 (9)
By: Ankur Gupta
Buy this Book

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)
close
close
close
Oracle GoldenGate 11g Complete Cookbook
Icon
Oracle GoldenGate 11g Complete Cookbook
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Installation and Initial Setup
Icon
Installation and Initial Setup
Icon
Introduction
Icon
Installing Oracle GoldenGate in a x86_64 Linux-based environment
Icon
Installing Oracle GoldenGate in a Windows environment
Icon
Enabling supplemental logging in the source database
Icon
Supported datatypes in Oracle GoldenGate
Icon
Preparing the source database for GoldenGate setup
Icon
Preparing the target database for GoldenGate setup
Icon
Setting up a Manager process
Icon
Setting up a Classic Capture Extract process
Icon
Setting up an Integrated Capture Extract process
Icon
Setting up a Datapump process
Icon
Setting up a Replicat process
2
Setting up GoldenGate Replication
Icon
Setting up GoldenGate Replication
Icon
Introduction
Icon
Setting up a simple GoldenGate replication configuration between two single node databases
Icon
Setting up a GoldenGate replication with multiple process groups
Icon
Configuring an Extract process to read from an Oracle ASM instance
Icon
Setting up a GoldenGate replication between Oracle RAC databases
Icon
Determining the size of trail file areas
Icon
Verifying the data transfer on the target system
Icon
Generating encryption keys
Icon
Encrypting database user passwords
Icon
Encrypting the trail files
Icon
Setting up a GoldenGate replication between tables with different structures using defgen
3
DDL Replication and Initial Load
chevron up
Icon
DDL Replication and Initial Load
Icon
Introduction
Icon
Performing an initial setup required for GoldenGate DDL replication
Icon
Setting up a GoldenGate DDL replication and verifying the changes
Icon
Performing an initial load using GoldenGate
Icon
Performing an initial load using an extract file to the GoldenGate's replicat method
Icon
Loading data using trail files to the Replicat process method
Icon
Loading data with files to the database utility method
Icon
Loading data with the GoldenGate direct load method
Icon
Loading data with bulk load to the SQL loader method
4
Mapping and Manipulating Data
Icon
Mapping and Manipulating Data
Icon
Introduction
Icon
Setting up a GoldenGate replication with mapping between different columns
Icon
Adding custom fields for a replicated record using tokens
Icon
Adding custom fields to a replicated record using SQLEXEC
Icon
Filtering the records using the FILTER and WHERE clause
Icon
Mapping the changes to a target table and storing the transaction history in a history table
Icon
Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated
Icon
Creating an exception handler to record the erroneous transactions in a GoldenGate configuration
5
Oracle GoldenGate High Availability
Icon
Oracle GoldenGate High Availability
Icon
Introduction
Icon
Choosing a GoldenGate high availability option
Icon
Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS
Icon
Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2
Icon
Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS
Icon
Manually switching over Oracle Clusterware-based configuration to the other node
Icon
Automatic failover of a DBFS-based configuration
Icon
Creating a set of parallel load balanced, highly available GoldenGate configurations using Oracle Clusterware and DBFS
6
Monitoring, Tuning, and Troubleshooting GoldenGate
Icon
Monitoring, Tuning, and Troubleshooting GoldenGate
Icon
Introduction
Icon
Steps to configure a BATCHSQL mode
Icon
Splitting the replication load into multiple process groups for optimal performance
Icon
Optimizing the network settings for a GoldenGate configuration
Icon
Performing a healthcheck of a live GoldenGate configuration
Icon
Script to perform a regular scheduled healthcheck of a live GoldenGate configuration
Icon
Steps to measure throughput of a GoldenGate configuration
Icon
Steps to re-instantiate a failed GoldenGate configuration
Icon
Steps to implement a Heartbeat mechanism for the GoldenGate replication
7
Advanced Administration Tasks – I
Icon
Advanced Administration Tasks – I
Icon
Introduction
Icon
Upgrading Oracle GoldenGate binaries
Icon
Table structure changes in GoldenGate environments with similar table definitions
Icon
Table structure changes in GoldenGate environments with different table definitions
Icon
Resolving GoldenGate errors using the logdump utility
Icon
Undoing the applied changes using the reverse utility
Icon
Creating an Integrated Capture with a downstream database for compressed tables
8
Advanced Administration Tasks – Part II
Icon
Advanced Administration Tasks – Part II
Icon
Introduction
Icon
Creating a GoldenGate configuration with a consistent state behind the target database
Icon
Replicating data from an active standby database in Archivelog mode only
Icon
Migrating from an Oracle Streams environment to Oracle GoldenGate
Icon
GoldenGate Administration role separation from the DBA team
Icon
Cross RDBMS replication using GoldenGate
Icon
Creating a multimaster GoldenGate replication configuration
9
GoldenGate Veridata, Director, and Monitor
Icon
GoldenGate Veridata, Director, and Monitor
Icon
Introduction
Icon
Setting up the Oracle GoldenGate Monitor server
Icon
Setting up Oracle GoldenGate Monitor Agents
Icon
Installing Oracle GoldenGate Director
Icon
Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances
Icon
Steps to set up the GoldenGate monitoring using OEM 12c
Icon
Steps to install Oracle GoldenGate Veridata
Icon
Steps to compare data between the source and target environment using Oracle GoldenGate Veridata
1
Index
Icon
Index

Loading data with bulk load to the SQL loader method

The GoldenGate bulk load to the SQL loader method consists of an initial load Extract process which communicates with an initial load Replicat process. This process is started automatically by the destination Manager process. The Replicat process then coordinates with the SQL loader API and uses it to load the data into the target database. In this recipe, we will look into the detailed steps of how to use this method to perform an instantiation of the source database.

Getting ready

For this recipe we will use the following setup:

  1. Create a modified version of the EMP table that is delivered in the SCOTT demo schema with Oracle binaries in the source and target databases. You can use the following DDL statement to create the EMP table: 

    CREATE TABLE EMP (
EMPNO NUMBER(10) PRIMARY KEY, 
ENAME VARCHAR2(25),
JOB VARCHAR2(25),
MGR NUMBER(10),
HIREDATE DATE,
SAL NUMBER(20,2),
COMM NUMBER(20,2),
DEPTNO NUMBER(10),
CITY VARCHAR2(25));

  2. Use the following...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle Goldengate 11g Complete Cookbook
End of Chapter 3
Next Chapter
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon