D89113 – Oracle GoldenGate 12c: Advanced Configuration for Oracle

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