Oracle GoldenGate 12c: Advanced Configuration for Oracle Training

• Elucidate Oracle GoldenGate Advanced Configuration options
• Perform zero-downtime database migration
• Work on Advanced Data Transformation techniques and Integrated Capture feature for the extraction and compression of complex data types
• Implement two-way and three-way active-active replication configurations
• Work on conflict detection and resolution (CDR) techniques
• Improve data delivery by using the Integrate Replicat feature and  Integrated Extract Groups
• Enable data transformation by configuring and implementing the Oracle GoldenGate Event Marker system
• Integrate Oracle GoldenGate with Oracle cluster configurations

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

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

2. 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

3. 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

4. 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

5. Custom Behavior 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)

6. 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

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

8. 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

9. 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
• Combining RESOLVECONFLICT with UPDATEROWEXISTS, INSERTROWEXISTS, DELETEROWEXISTS, UPDATEROWMISSING and DELETEROWMISSING Clauses to Identify Source of Conflict Errors
• Increasing Troubleshooting Information Captured in Error and Discard Tables Using Oracle GoldenGate Facilities

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

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