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
chevron up
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
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

Setting up a Replicat process

The Replicat processes are the delivery processes which are configured in the target environment. These processes read the changes from the trail files on the target system and apply them to the target database objects. If there are any transformations defined in the replicat configuration, the Replicat process takes care of those transformations as well. You can define the mapping information in the replicat configuration. The Replicat process will then apply the changes to the target database based on the mappings.

Getting ready

Before setting up replicat in the target system, you must have configured and started the Manager process.

How to do it…

Follow the following steps to configure a replicat in the target environment:

  1. From the GoldenGate Home directory, run the GoldenGate software command line interface (GGSCI) as follows:

    ./ggsci

  2. Log in to the target database through GGSCI as shown in the following code:

    GGSCI> DBLOGIN, USERID <USER> PASSWORD <PW>

  3. Add the Checkpoint table as shown in the following code:

    GGSCI> ADD CHECKPOINTTABLE <SCHEMA.TABLE>

  4. Edit the Replicat process configuration as shown in the following code:

    GGSCI> EDIT PARAMS RGGTEST1

  5. This command will open an editor window. You need to add the replicat configuration parameters in this window as shown in the following code:

    REPLICAT <REPLICAT_NAME>
USERID <TARGET_GG_USER>@TARGETDB, PASSWORD ******
DISCARDFILE <DISCARDFILE_SPEC>
MAP <mapping_specification>;

    For example:

    REPLICAT RGGTEST1
USERID GGATE_ADMIN@TGORTEST, PASSWORD ******
DISCARDFILE /u01/app/ggate/dirrpt/RGGTEST1.dsc, APPEND, MEGABYTES 500
MAP SCOTT.*, SCOTT.*;

  6. Save the file and exit the editor.

  7. Add the replicat to the GoldenGate instance as shown in the following code:

    GGSCI> ADD REPLICAT <REPLICAT> EXTTRAIL <PATH>

    For example:

    ADD REPLICAT RGGTEST1, EXTTRAIL /u01/app/ggate/dirdat/rt

  8. Start the Replicat process as shown in the following code:

    GGSCI> START REPLICAT <REPLICAT>

How it works…

In the preceding procedure we first create a Checkpoint table in the target database. As the name suggests, the Replicat process uses this table to maintain its checkpoints. In case the Replicat process crashes and it is restarted, it can read this Checkpoint table and start applying the changes from the point where it left.

Once you have added a Checkpoint table, you need to create a parameter file for the Replicat process. Once the process parameter file is created, it is then added to the GoldenGate instance. At this point, we are ready to start the Replicat process and apply the changes to the target database. You should see an output similar to the following:

GGSCI (stdby1-ol6-112.localdomain) 10> start replicat RGGTEST1
Sending START request to MANAGER ...
REPLICAT RGGTEST1 starting

You can check the status of the Replicat process using the following command:

GGSCI (stdby1-ol6-112.localdomain) 10> status replicat RGGTEST1
REPLICAT RGGTEST1: RUNNING

There's more…

Following are the common parameters that are specified in the replicat configuration:

  • DISCARDFILE: This parameter is used to specify the name of the discard file. If the Replicat process is unable to apply any changes to the target database due to any errors, it writes the record to the discard file.

  • EOFDELAY secs: This parameter controls how often GoldenGate should check the local trail file for new data.

  • REPORTCOUNT: This parameter controls how often the Replicat process writes its progress to the report file.

  • BATCHSQL: This parameter is used to specify the BATCHSQL mode for replicat.

  • ASSUMETARGETDEFS: This parameter tells the Replicat process to assume that the source and target database object structures are the same.

See also

  • Read Setting up GoldenGate replication between tables with different structures using defgen recipe in Chapter 2, Setting Up GoldenGate Replication

  • Steps to configure a BATCHSQL mode recipe in Chapter 6, Monitoring, Tuning, and Troubleshooting GoldenGate for further information

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 1
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