Table of Contents
- Title and Copyright Information
- Preface
-
1
Concepts
- Oracle GoldenGate
- Oracle GoldenGate Microservices Architecture
- Components of Oracle GoldenGate Microservices Architecture
- Components of Data Replication in Oracle GoldenGate
-
2
Install and Patch
- Download Oracle GoldenGate Software
- Verify Certification and System Requirements
- Operating System Requirements
- Prerequisites for Installing Oracle GoldenGate for Db2 LUW
- Prerequisites for Installing Oracle GoldenGate for Db2 for i
- Prerequisites for Installing Oracle GoldenGate for Db2 z/Os
- Prerequisites for Installing Oracle GoldenGate for MySQL
- Prerequisites for Installing Oracle GoldenGate for SQL Server
- Prerequisites for Installing Oracle GoldenGate for Sybase
- Prerequisites for Installing Oracle GoldenGate for Teradata
- Prerequisites for Installing Oracle GoldenGate for TimesTen
- Prerequisites for Installing Oracle GoldenGate Remote Capture and Delivery
- Other Program and Settings
- Installing Oracle GoldenGate
- Post-installation Tasks
- Software Installation Directories and Programs for Oracle GoldenGate
- Installing Patches for Oracle GoldenGate Microservices Architecture
- Uninstalling Oracle GoldenGate Microservices Architecture
-
3
Deploy
- Add a Deployment
- Add a Deployment to an Existing Service Manager
- Add a Deployment in Silent Mode using OGGCA
- First Access to the Deployment from the Service Manager
- Add Users to a Deployment
- Delegate User Authentication to an External ID Provider
- Monitor Oracle GoldenGate Processes, Trails, and Paths
- Switch Between States for a Deployment and Microservices
- Access Configuration and Log Details from the Service Manager and Microservices
- Manage Certificates for Deployments
- Manage the Debug Log
- Start and Stop the Service Manager
- Remove a Deployment
- Remove the Service Manager
-
4
Prepare
-
Prepare Databases
- Db2 LUW
-
Db2 for i
- Prepare Database Users and Privileges for Db2 for i
- Prepare Database Connection, System, and Parameter Settings
- Configuring Oracle GoldenGate for DB2 for i
- Preparing the Journals for Data Capture by Extract
- Prepare Tables for Processing
-
Db2 for i: Supported Data Types, Objects, and
Operations
- Supported Db2 for i Data Types
- Non-Supported Db2 for i Data Types
- Supported Objects and Operations for Db2 for i
- Non-Supported Objects and Operations for DB2 for i
- Oracle GoldenGate Parameters Not Supported for DB2 for i
- Supported Object Naming Conventions
- System Schemas for DB2 for i
- Supported Character Sets
- Db2 z/OS
- MySQL
-
Oracle
- Prepare Database Users and Privileges for Oracle
- Prepare Database Connection, System, and Parameter Settings
- Ensuring Row Uniqueness in Source and Target Table
- Transaction Log Settings and Requirements
-
Oracle: Supported Data Types,
Objects, and Operations for DDL and DML
- Details of Support for Oracle Database Editions
- Details of Support for Oracle Data Types and Objects
- Details of Support for JSON-Relational Duality Views and JSON Collection Tables
- Details of Support for Objects and Operations in Oracle DML
- Details of Support for Objects and Operations in Oracle DDL
- PostgreSQL
-
SQL Server
- SQL Server Supported Versions
- Prepare Database Users and Privileges for SQL Server
- Prepare Database Connection
- Preparing Tables for Processing
- Prepare the Database for Oracle GoldenGate
- CDC Capture Method Operational Considerations
- Requirements Summary for Capture and Delivery of Databases in an Always On Availability Group
- SQL Server: Supported Data Types, Objects, and Operations
- Sybase
- Teradata
- TimesTen
-
Prepare Oracle GoldenGate
- Configure Secure Database Connections from Oracle GoldenGate
- Authenticate the Database Connection Using the Database Password Plugin
- Add Database Connections
- Before Adding Extract and Replicat Processes
-
Prepare Databases
- 5 Quickstarts
-
6
Extract
- About Extract
- Add an Online Extract
- Register an Extract from the Admin Client
-
Downstream Extract for Oracle
GoldenGate Deployment
- Configure the Source and Downstream Databases
- Configure Oracle GoldenGate Extract for Downstream Deployment
- Configure Cascaded Downstream Extract Using Active Data Guard
- Extract Actions
- Positioning Extract to a Specific Start Point
- Bounded Recovery
-
7
Instantiate
- About Instantiating with Initial Load Extract
- Add Initial Load Extract Using the Admin Client
- Precise Instantiation for MySQL to MySQL Using MySQL Shell Utilities and Oracle GoldenGate
- Instantiating for a PostgreSQL Replication using Initial Load Extract
- Precise Instantiation between PostgreSQL Environments Using pg_dump
- Monitoring and Controlling Processing After the Instantiation
- Verifying Synchronization
-
8
Distribute
- About Distribution Service and Distribution Path
- Add a Distribution Path
- Manage Distribution Paths
- About Receiver Service
- About Target-Initiated Distribution Paths
- Add Target-Initiated Distribution Paths
- Manage Target-Initiated Distribution Paths
- Oracle GoldenGate Data Streams
- Replicating Business Objects with Oracle JSON Relational Duality and GoldenGate Data Streams
-
9
Replicat
- About Replicat
- Types of Replicat
- Add a Replicat
- Replicat Actions
- Controlling Checkpoint Retention
- Excluding Replicat Transactions in Bidirectional Replication
- Additional Parameter Options for Integrated Replicat
- DDL Notification on Target Tables
-
10
Secure
- Oracle GoldenGate Security Features
-
Oracle GoldenGate Security
Feature: Implementation
- Create Certificates for a Secure Deployments
- Configure Oracle GoldenGate Reverse Proxy with NGINX
-
Encrypting Trail Files
- Create and Apply Encryption Profile in a Deployment
- Using Oracle Key Vault Trail File Encryption in Oracle GoldenGate
- Using OCI KMS Trail File Encryption in Oracle GoldenGate
- Managing Identities in a Credential Store
- Configure Kerberos Authentication
-
11
Administer
-
Data Management
- MySQL: DDL Replication
-
Oracle: DDL Replication
- Overview of DDL Synchronization
- Limitations of Oracle GoldenGate DDL Support
- Guidelines for Configuring DDL Replication for Oracle
- Understanding DDL Scopes
- Correctly Identifying Unqualified Object Names in DDL
- Enabling DDL Support
- Filtering DDL Replication
- Special Filter Cases
- How Oracle GoldenGate Handles Derived Object Names
- Using DDL String Substitution
- Add Supplemental Log Groups Automatically
- Removing Comments from Replicated DDL
- Replicating an IDENTIFIED BY Password
- How DDL is Evaluated for Processing
- Viewing DDL Report Information
- Using Edition-Based Redefinition
- Using Oracle GoldenGate with MySQL Group Replication
- Manage Auto Start and Auto Restart for Extract and Replicat Processes
- Configure DDL Modification for Oracle GoldenGate for Sybase
-
Procedural Replication
- About Procedural Replication
- Procedural Replication Process Overview
- Determining Whether Procedural Replication Is On
- Enabling and Disabling Supplemental Logging
- Filtering Features for Procedural Replication
- Handling Procedural Replication Errors
- Listing the Procedures Supported for Oracle GoldenGate Procedural Replication
- Monitoring Oracle GoldenGate Procedural Replication
- Execute Commands, Stored Procedures, and Queries with SQLEXEC
-
Mapping and Manipulating Data
- Parameters that Control Mapping and Data Integration
- Mapping between Dissimilar Databases
- Globalization Considerations when Mapping Data
- Mapping Columns Using TABLE and MAP
- Data Type Conversions
- Selecting and Filtering Rows
- Retrieving Before and After Values
- Selecting Columns
- Selecting and Converting SQL Operations
- Using Transaction History
- Testing and Transforming Data
- Using Tokens
-
Bi-Directional Replication
- Prerequisites for Bidirectional Replication
- MySQL: Bi-Directional Replication
- PostgreSQL: Bi-Directional Replication
- Preparing DBFS for an Active-Active Configuration
-
Error Management
- Overview of Oracle GoldenGate Error Handling
-
Automatic Conflict Detection and
Resolution
-
About Automatic Conflict Detection and Resolution
- Automatic Conflict Detection and Resolution
- Requirements for Automatic Conflict Detection and Resolution
- Column Groups
- Earliest Timestamp Conflict Detection and Resolution
- Latest Timestamp Conflict Detection and Resolution
- Delta Conflict Resolution
- Site Priority CDR
- Delete Always Wins Timestamp CDR
- DELETE TOMBSTONE Table
- Track Primary Key Updates in Delete Tombstone
- Configuring Delta Conflict Detection and Resolution
- Managing Automatic Conflict Detection and Resolution
- Monitoring Automatic Conflict Detection and Resolution
-
About Automatic Conflict Detection and Resolution
-
Manual Conflict Detection and
Resolution
- Overview of the Oracle GoldenGate CDR Feature
- Configuring the Oracle GoldenGate Parameter Files for Conflict Resolution
- Making the Required Column Values Available to Extract
- Viewing CDR Statistics
-
CDR Example 1: All Conflict Types with USEMAX, OVERWRITE, DISCARD
- Table Used in this Example
- MAP Statement with Conflict Resolution Specifications
- Description of MAP Statement
- INSERTROWEXISTS with the USEMAX Resolution
- UPDATEROWEXISTS with the USEMAX Resolution
- UPDATEROWMISSING with OVERWRITE Resolution
- DELETEROWEXISTS with OVERWRITE Resolution
- DELETEROWMISSING with DISCARD Resolution
- CDR Example 2: UPDATEROWEXISTS with USEDELTA and USEMAX
- CDR Example 3: UPDATEROWEXISTS with USEDELTA, USEMAX, and IGNORE
- Configuring the Oracle GoldenGate Parameter Files for Error Handling
- Trail File Management
-
Admin Client Command Line
Interface for Oracle GoldenGate Microservices
- About Admin Client
- Using Wildcards in Command Arguments
- Using Command History
- Storing and Calling Frequently Used Command Sequences
- Controlling Extract and Replicat
- Deleting Extract and Replicat
- Creating a Parameter File Using Admin Client
- Validating a Parameter File
- Simplifying the Creation of Parameter Files
-
Specifying Object Names in Oracle GoldenGate Input
- Specifying Filesystem Path Names in Parameter Files on Windows Systems
- Supported Database Object Names
- Specifying Names that Contain Slashes
- Qualifying Database Object Names
- Specifying Case-Sensitive Database Object Names
- Using Wildcards in Database Object Names
- Differentiating Case-Sensitive Column Names from Literals
- Simplify and Automate Work with Oracle GoldenGate Macros
-
Using User Exits to Extend Oracle GoldenGate Capabilities
- When to Implement User Exits
- Making Oracle GoldenGate Record Information Available to the Routine
- Creating User Exits
- Supporting Character-set Conversion in User Exits
- Using Macros to Check Name Metadata
- Describing the Character Format
- Upgrading User Exits
- Viewing Examples of How to Use the User Exit Functions
-
Data Management
-
12
Performance
-
Monitor
- Monitor Processes from the Performance Metrics Service
- Using Automatic Workload Repository (AWR) Reports for Oracle Database
-
Monitor Oracle GoldenGate Statistics using
StatsD
- Enable StatsD using OGGCA
- Enable StatsD with REST API Service Endpoints
-
StatsD Metrics Catalog
- Batch SQL Statistics
- Bounded Recovery Status
- Cache Manager Statistics
- Distribution Service Network Statistics
- Distribution Service Path Statistics
- Distribution Service Table Statistics
- Checkpoint Position Information Statistics
- Input Trail File Statistics
- Output Trail File Statistics
- Extract Database Statistics
- Network Statistics
- Process Performance Statistics
- Queue Statistics
- Replicat Database Statistics
- Parallel Replicat Statistics
- Receiver Service Statistics
- Extract Database Statistics by Table
- Replicat Database Statistics by Table
- About Integrated Diagnostics
- Commands Used for Monitoring
- Monitor an Extract Recovery
- Use the Error Log
- Monitor Lag
- Db2 z/OS: Interpret Statistics for Update Operations
- Monitor Processing Volume
- Use the Process Report
- Use the Discard File
- Parameters Used to Interpret Synchronization Lag
-
Monitor
- 13 Mission Critical
- 14 Autonomous Database
- 15 Upgrade
-
16
Appendix
- Sample Commands to Configure GoldenGate Data Streams for JSON Relational Duality Views
- OGGCA Sample Template Response File for Silent Deployment
-
Using the LogDump Utility to Access
Trail File Records
- Trail Recovery Mode
-
Trail Record Format
- Trail File Header Record
- Tokens Area
- Oracle GoldenGate Operation Types
- Checkpoint Tables Additional Details
- Oracle GoldenGate Microservices Roles
- Supported Character Sets
- Supported Locales
- Commit Sequence Number (CSN)
- Connecting Microservices and Classic Architectures