Oracle GoldenGate 12c: Advanced Configuration for Oracle

Suggested Prerequisite

• Oracle GoldenGate 12c: Fundamentals for Oracle

Required Prerequisite

• Oracle GoldenGate 12c: Fundamentals for Oracle
• Oracle GoldenGate 12c: Troubleshooting and Tuning

Audience

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

Course Topics

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

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

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

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

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

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

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

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

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

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