Oracle GoldenGate 12c: Advanced Configuration for Oracle

Course Outline

Topics

• 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 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)
• 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

• 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 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)

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

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

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