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
- 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
-
Using OGGCA Wizard for
Deployment
- Start the OGGCA Wizard
- Select Service Manager Options
- Configuration Options
- Deployment Details
- Select Deployment Directories
- Specify Environment Variables
- Service Manager Administrator Account
- Specify Security Options
- Advanced Security Settings
- Sharding Options
- Port Settings
- Replication Settings
- Summary
- Configure Deployment
- Finish
-
Using OGGCA Wizard for
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 Deployment Users from the Service Manager
- Add Deployment Users from the Administration Server
- Manage Deployments from the Service Manager
- Remove a Deployment
- Remove the Service Manager
- View and Edit Services Configuration
-
Add a Deployment
-
4
Prepare
-
Prepare Oracle Database
- Prepare Database Users and Privileges for Oracle
- Configuring Connections for Integrated Processes
- Configuring Logging Properties
- Enabling Oracle GoldenGate in the Database
- Configuring Oracle GoldenGate in a Multitenant Container Database
- Setting Flashback Query
- Managing Server Resources
- Ensuring Row Uniqueness in Source and Target Tables
-
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 Objects and Operations in Oracle DML
- Details of Support for Objects and Operations in Oracle DDL
- Prepare Oracle GoldenGate
-
Prepare Oracle Database
-
5
Extract
- Quick Tour of the Administration Service Overview Page
- About Extract
- Add an Extract
- Using Extract Actions
-
Downstream Extract for Downstream Database
Mining
-
Configure Extract for a Downstream
Deployment
- Evaluate Extract Options for a Downstream Deployment
- Prepare the Source Database for the Downstream Deployment
- Prepare the Downstream Mining Database to Receive Online Redo Logs
- Enable Downstream Extract to Work with ADG
-
Use Cases for Downstream Mining
Configuration
- Case 1: Capture from One Source Database in Real-time Mode
- Case 2: Capture from Multiple Sources in Archive-log-only Mode
-
Case 3: Capturing from Multiple Sources
with Mixed Real-time and Archive-log-only Mode
- Prepare the Mining Database to Archive its Local Redo
- Prepare the Mining Database to Accept Redo from the Source Databases
- Prepare the First Source Database to Send Redo to the Mining Database
- Prepare the Second Source Database to Send Redo to the Mining Database
- Prepare the Second Source Database to Send Redo to the Mining Database
- Prepare the Third Source Database to Send Redo to the Mining Database
-
Configure Extract for a Downstream
Deployment
- Positioning Extract to a Specific Start Point
- 6 Distribute
-
7
Replicat
- Quick Tour of the Administration Service Overview Page
- About Replicat
- Types of Replicat
- Select a Replicat Type for the Deployment
- Add a Replicat
- Using Replicat Actions
- Review Critical Events
- 8 Instantiate
-
9
Administer
-
Data Management
-
Oracle: DDL Replication
- Prerequisites for Configuring DDL
- 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
- Controlling the Propagation of DDL to Support Different Topologies
- 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
- Tracing DDL Processing
-
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
- Set up and Use the Master Keys and Encryption Keys
- Access the Parameter Files
- Configure an Encryption Profile
- Access Extract and Replicat Log Information
-
Mapping and Manipulating Data
- Guidelines for Using Self-describing Trails
- Parameters that Control Mapping and Data Integration
- Mapping between Dissimilar Databases
- Globalization Considerations when Mapping Data
- Mapping Columns Using TABLE and MAP
- Configuring Global Column Mapping with COLMATCH
- Understanding Default Column Mapping
- 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
- Using Edition-Based Redefinition
-
Oracle: DDL Replication
-
Error Management
-
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
- DELETE TOMBSTONE Table
- Earliest Timestamp Conflict Detection and Resolution
- Latest Timestamp Conflict Detection and Resolution
- Delete Always Wins Timestamp CDR
- Delta Conflict Resolution
- Site Priority CDR
- 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 Error Handling
- 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
- Error Handling
-
Automatic Conflict Detection and
Resolution
- 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
-
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
- Creating a Parameter File Using Admin Client
- Simplifying the Creation of Parameter Files
- Validating a Parameter File
- 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
-
10
Performance
-
Monitor
- Commands Used for Monitoring
- Monitor Processes from the Performance Metrics Service
- Monitor an Extract Recovery
- Monitor Lag
- Db2 z/OS: Interpret Statistics for Update Operations
- Monitor Processing Volume
- Use the Error Log
- Use the Process Report
- Use the Discard File
- Maintain Discard and Report Files
- Parameters Used to Interpret Synchronization Lag
- Tuning
-
Monitor
- 11 Autonomous Database
- 12 Upgrade
-
13
Appendix
-
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
- Supported Character Sets
- Supported Locales
- Commit Sequence Number (CSN)
- Connecting Microservices and Classic Architectures
-
Using the LogDump Utility to Access
Trail File Records