Professional Training

Learning Objectives

Familiarize the student with Data Conflict Avoidance Techniques
Set up and manage advanced deployment models, such as 3-node multi master replication configurations
Integrate Oracle GoldenGate with Oracle cluster configurations
Explain Oracle GoldenGate Advanced Configuration options
Describe and take advantage of the Integrated Capture feature to extract complex data types and compressed data
Introduce the new Integrate Replicat feature for improved data delivery
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
Perform zero-downtime database migratio

Pre-requisites

Have attended our have equivalent knowledge of our Oracle GoldenGate Fundamentals course
Extensive use of—and exposure to—Oracle GoldenGate concepts and implementations

Oracle GoldenGate Integrated Capture/integrated Delivery

What is Oracle GoldenGate Integrated Capture?
Why it is Needed and What Additional Replication Features it Makes Possible
How to Prepare a Database for Integrated Capture – Creation of Users, Assignments of Roles and Privileges, etc
Oracle GoldenGate Integrated Capture Deployment Modes
Integrated Replicat/Apply Architecture
Integrated Replicat: How it works
Integrated Delivery in Detail

Oracle Goldengate With Oracle Real Application Clusters Configuration

Oracle RAC, Oracle GoldenGate and Business Continuity
Oracle GoldenGate Used in Combination with Oracle RAC
Oracle GoldenGate and the Oracle Database File System (DBFS)
Oracle DBFS and Oracle Clusterware
Configuring Oracle GoldenGate using the DBFS file systems

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 Behaviour Through User Exits

The CUSEREXIT Parameter and its Options
User Exit Mandatory Parameters: EXIT_CALL_TYPE, EXIT_CALL_RESULT and EXIT_PARAMS
The EXIT_CALL_PROCESS_RECORD Function
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
Simulating fallback

Bidirectional Replication: Two-Node Configuration

Bi-Directional Replication
Data Conflict Types
Getting Before Image Information from Source Database
Using RESOLVECONFLICT
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

Multi-Master Replication Topology

Three-Node Configuration

Active Data Guard and Oracle GoldenGate

How to Achieve Maximum Availability