Download PDF
of this course

Oracle GoldenGate 11g: Advanced Configuration for Oracle (G11GACO)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 4 Days

Price: SGD 3,360.00

Enrolling in this Oracle GoldenGate 11g training will help you develop your installation and configuration skills. By interacting with top Oracle instructors, you'll be able to ask questions as you learn to solidify your understanding.

Learn To:

  • Explain Oracle GoldenGate advanced configuration options.
  • Describe and take advantage of the new Integrated Capture to replicate complex data types and compressed data.
  • Configure and implement the Oracle GoldenGate Event Marker system.
  • Enable data transformation based on event records in the transaction logs or in the trail files.
  • Perform zero-downtime database migration.
  • Set up and manage advanced deployment models, like 3-node multi master replication configuration.
  • Master Oracle GoldenGate facilities to detect and resolve data conflicts in active-to-active replication implementations.

Benefits to You

Integrate your organization's disparate data across heterogeneous databases for improved decision-making. Become more efficient at configuring and implementing Oracle GoldenGate.

Enable Zero-Downtime Migration

This course also allows you to simulate a system upgrade. You'll develop the skills needed to survive an aborted migration, incurring zero data loss. Hone these skills by engaging in hands-on demonstrations and exercises.

Active-Active Replication and CDR

You'll also build two-way and three-way active-active replication configurations. Explore both basic and advanced conflict detection and resolution (CDR). Review basic product-provided CDR, with more advanced custom CDR techniques implemented using SQLEXEC and stored procedures.

Configure Integrated Extract Groups

The recently introduced Integrated Extract feature is also covered in depth. You'll learn to configure integrated extract groups operating in both local and downstream deployment modes.

Learn to Utilize Advanced Features

Upon completing this course, you'll be able to utilize the more advanced features of Oracle GoldenGate 11g, including: integrated capture, active-active replication, conflict detection and resolution, DDL/DML replication, Oracle GoldenGate event marker subsystem, advanced data manipulation and transformation techniques and advanced data mapping.

Live Virtual Class Format

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.


Who Should Attend

  • Process Developer
  • Data Warehouse Administrator
  • Database Administrators
  • Database Designers
  • Architect
  • System Integrator

Course Certifications

This course is part of the following Certifications:


Required Prerequisites:

  • Oracle GoldenGate 11g: Fundamentals for Oracle

Suggested Prerequisites:

  • Oracle Database 11g: Administration Workshop I
  • Oracle Database 11g: 2 Day DBA

Course Objectives

  • Explain Oracle GoldenGate Advanced Configuration options
  • Describe and take advantage of the new Integrated Capture to replicate complex data types and compressed data, currently unsupported by Classic Capture
  • Install and deploy Oracle GoldenGate Integrated Capture components
  • Configure and implement the Oracle GoldenGate Event Marker system, to enable data transformation based on event records in the transaction logs or in the trail files
  • Master Oracle GoldenGate facilities to detect and resolve data conflicts in active-to-active replication implementations
  • Familiarize the student with Data Conflict Avoidance Techniques
  • Set up and manage advanced deployment models, such as 3-node multi master replication configurations
  • Perform zero-downtime database migration

Course Content

Oracle GoldenGate Integrated Capture

  • What is Oracle GoldenGate Integrated Capture?
  • Why it is Needed and What Additional Replication Features it Makes Possible
  • Comparing and Contrasting Classic Capture vs. Integrated Capture
  • How to Prepare a Database for Integrated Capture – Creation of Users, Assignments of Roles and Privileges, etc
  • Oracle GoldenGate Integrated Capture Deployment Modes
  • Configuring an Extract Process to Perform Change Data Capture Using Integrated Capture
  • Extracting Parameters Relevant to Integrated Capture

Oracle GoldenGate Event Marker System

  • Starting, Suspending, Stopping Processes, Performing a Transformation, Reporting Statistics, and Capturing Lag History Using the Event Marker System
  • Invoking Stored Procedures When Specific Events Occur Using SQLEXEC
  • Activating Tracing Following the Exceeding of a Data Threshold
  • Running OS Shell Commands at the Occurrence of Specific Data-Driven Events
  • Extracting Details Analysis of the TABLE, MAP, FILTER, WHERE and SQLEXEC Statements
  • Implementing Event Marker Actions on the Extraction Side and on the Delivery Side of Replication

Data Mapping, Data Selection/Filtering and Data Transformation

  • TABLE (for Extract) and MAP (for Replicat) Options Which Allow for Data Selection
  • COLMAP and COLMATCH Options
  • Exploring Simple Filtering (Achieved Through the WHERE Clause) and Complex Filtering (Using the FILTER Clause)
  • Data Transformation Functions: Enabling Concatenation, Substitution, Case Changing, Numeric Conversion and Date Conversion
  • SQLEXEC Parameter to Invoke Stored Procedures or to Perform Native SQL Queries

Custom Behavior Through User Exits

  • The CUSEREXIT Parameter and its Options
  • User Exit Mandatory Parameters: EXIT_CALL_TYPE, EXIT_CALL_RESULT and EXIT_PARAMS
  • Oracle GoldenGate Callback Routines Invoked Through ERCALLBACK
  • The usrdecs.h “C” Include File
  • JMS and Flat File Using Oracle GoldenGate Application Adapters
  • Connecting to the Java Subsystem Through the Java Native Interface (JNI)

Configuring Zero-Downtime Migration Replication

  • Zero-Downtime Migration Prerequisites
  • Zero-Downtime Migration Topology
  • Configuring Initial Setup and Required Steps
  • Configuring Primary Extract, Data pump and Replicat for Fallback

Bidirectional Replication: Two-Node Configuration

  • Bi-Directional Replication
  • Multi-Master Replication
  • Data Conflict Types
  • Getting Before Image Information from Source Database
  • Handling UPDATEROWEXISTS in Conjunction with USEDELTA, USEMAX, and IGNORE
  • Exceptions MAP Statement
  • Creating and Populating Exception and Discard Tables

Conflict Detection and Resolution – Custom Techniques

  • Workload Partitioning
  • Geographic or Topic-Based Segmentation
  • Primary Key Generation
  • Custom Conflict Resolution Techniques: Quantitative Methods for Conflict Resolution and Data Convergence
  • Automatic Conflict Resolution Based on Time stamp or Trusted Source
  • Automatic Data Convergence of Numeric Values Based on Additive Value or Average Value

Multi-Master Replication Topology – Three-Node Configuration

  • Handling Multi-Master Configurations: Additional Limitations Compared to Active-Active
  • Dealing with the Lack of Support for DDL Replication
  • Data Convergence and Latency in a Multi-Master Topology
  • Decreasing Complexity by Enabling Segmentation and Node-Based Partitioning in the Application
  • Minimizing Data Conflict by Minimizing Latency
  • Resolving Simple Conflicts Using RESOLVECONFLICT with USEMIN, USEMAX and USEDELTA
  • Increasing Troubleshooting Information Captured in Error and Discard Tables Using Oracle GoldenGate Facilities

Administering a Multi-Master Configuration

  • Adding Process Groups to Active Configurations
  • Changing Database Attributes
  • Performing Administrative Operations on a Multi-Master Replication Environment
  • Reinitializing the Transaction Log

Course ID: G11GACO

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register