Module 1: Oracle GoldenGate Integrated Capture/integrated Delivery

• 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
• Integrated Replicat: How it works
• Integrated Replicat/Apply Architecture
• What is Oracle GoldenGate Integrated Capture?
• Oracle GoldenGate Integrated Capture Deployment Modes
• Integrated Delivery in Detail

Module 2: Oracle Goldengate With Oracle Real Application Clusters Configuration

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

Module 3: Oracle GoldenGate Event Marker System

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

Module 4: Data Mapping, Data Selection/Filtering and Data Transformation

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

Module 5: Custom Behavior Through User Exits

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

Module 6: Configuring Zero-Downtime Migration Replication

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

Module 7: Bidirectional Replication: Two-Node Configuration

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

Module 8: Conflict Detection and Resolution – Custom Techniques

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

Module 9: Multi-Master Replication Topology – Three-Node Configuration

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

Module 10: Active Data Guard and Oracle GoldenGate. How to achieve Maximum Availability

• Data Guard Fast Start Fail Over (FSFO)
• Oracle Bundled Agent (XAG)
• Oracle Bundled Agent – The Key to Maximum Availability
• Role Transition Complexity – Oracle GoldenGate to the Rescue