Table of Contents
- Title and Copyright Information
- Preface
- 1 Oracle GoldenGate Administration Overview
-
Part I Oracle GoldenGate Administration:
Common Components and Operations
- 2 Oracle GoldenGate Globalization Support
-
Using Oracle GoldenGate Parameter Files
- Globalization Support for Parameter Files
- Working with the GLOBALS File
- Working with Runtime Parameters
- Creating a Parameter File
- Validating a Parameter File
- Viewing a Parameter File
- Changing a Parameter File
- Simplifying the Creation of Parameter Files
- Getting Information about Oracle GoldenGate Parameters
- 3 Using Oracle GoldenGate for Live Reporting
- 4 Using Oracle GoldenGate for Real-time Data Distribution
- 5 Configuring Oracle GoldenGate for Real-time Data Warehousing
- 6 Configuring Oracle GoldenGate to Maintain a Live Standby Database
-
7
Configuring Oracle GoldenGate for
Active-Active Configuration
- 7.1 Overview of an Active-Active Configuration
- 7.2 Considerations for an Active-Active Configuration
- 7.3 Preventing Data Looping
- 7.4 Managing Conflicts
- 7.5 Additional Information
- 7.6 Creating an Active-Active Configuration
-
7.7
Configuring Conflict Detection and Resolution
- 7.7.1 Overview of the Oracle GoldenGate CDR Feature
- 7.7.2 Configuring the Oracle GoldenGate Parameter Files for Error Handling
- 7.7.3 Configuring the Oracle GoldenGate Parameter Files for Conflict Resolution
- 7.7.4 Making the Required Column Values Available to Extract
- 7.7.5 Configuring Oracle GoldenGate CDR
-
7.7.6
CDR Example 1: All Conflict Types with USEMAX, OVERWRITE, DISCARD
- 7.7.6.1 Table Used in this Example
- 7.7.6.2 MAP Statement with Conflict Resolution Specifications
- 7.7.6.3 Description of MAP Statement
- 7.7.6.4 Error Handling
- 7.7.6.5 INSERTROWEXISTS with the USEMAX Resolution
- 7.7.6.6 UPDATEROWEXISTS with the USEMAX Resolution
- 7.7.6.7 UPDATEROWMISSING with OVERWRITE Resolution
- 7.7.6.8 DELETEROWMISSING with DISCARD Resolution
- 7.7.6.9 DELETEROWEXISTS with OVERWRITE Resolution
- 7.7.7 CDR Example 2: UPDATEROWEXISTS with USEDELTA and USEMAX
- 7.7.8 CDR Example 3: UPDATEROWEXISTS with USEDELTA, USEMAX, and IGNORE
-
8
Mapping and Manipulating Data
- 8.1 Guidelines for Using Self-describing Trails
- 8.2 Parameters that Control Mapping and Data Integration
- 8.3 Mapping between Dissimilar Databases
- 8.4 Deciding Where Data Mapping and Conversion Will Take Place
- 8.5 Globalization Considerations when Mapping Data
- 8.6 Mapping Columns Using TABLE and MAP
- 8.7 Selecting and Filtering Rows
- 8.8 Retrieving Before and After Values
- 8.9 Selecting Columns
- 8.10 Selecting and Converting SQL Operations
- 8.11 Using Transaction History
- 8.12 Testing and Transforming Data
- 8.13 Using Tokens
- Part II Administering Oracle GoldenGate Microservices Architecture
-
Part III Administering Oracle GoldenGate
Classic Architecture
-
10
Configuring Manager and Network Communications
- 10.1 Overview of the Manager Process
- 10.2 Assigning Manager a Port for Local Communication
- 10.3 Maintaining Ports for Remote Connections through Firewalls
- 10.4 Choosing an Internet Protocol
- 10.5 Using the Recommended Manager Parameters
- 10.6 Creating the Manager Parameter File
- 10.7 Starting Manager
- 10.8 Stopping Manager
-
11
Getting Started with the Oracle GoldenGate Process Interfaces
- 11.1 Using GGSCI and Admin Client Command Line Interfaces
- 11.2 Controlling Oracle GoldenGate Processes
- 11.3 Automating Commands
-
11.4
Specifying Object Names in Oracle GoldenGate Input
- 11.4.1 Specifying Filesystem Path Names in Parameter Files on Windows Systems
- 11.4.2 Supported Database Object Names
- 11.4.3 Specifying Names that Contain Slashes
- 11.4.4 Qualifying Database Object Names
- 11.4.5 Specifying Case-Sensitive Database Object Names
-
11.4.6
Using Wildcards in Database Object Names
- 11.4.6.1 Rules for Using Wildcards for Source Objects
- 11.4.6.2 Rules for Using Wildcards for Target Objects
- 11.4.6.3 Fallback Name Mapping
- 11.4.6.4 Wildcard Mapping from Pre-11.2.1 Trail Version
- 11.4.6.5 Asterisks or Question Marks as Literals in Object Names
- 11.4.6.6 How Wildcards are Resolved
- 11.4.6.7 Excluding Objects from a Wildcard Specification
- 11.4.7 Differentiating Case-Sensitive Column Names from Literals
-
12
Configuring Online Change Synchronization
- 12.1 Overview of Online Change Synchronization
- 12.2 Choosing Names for Processes and Files
- 12.3 Creating a Checkpoint Table
- 12.4 Creating an Online Extract Group
- 12.5 Creating a Trail
- 12.6 Creating a Parameter File for Online Extraction
- 12.7 Creating an Online Replicat Group
- 12.8 Creating a Parameter File for Online Replication
- 13 Handling Processing Errors
-
14
Instantiating Oracle GoldenGate with an Initial Load
- 14.1 Overview of the Initial-Load Procedure
- 14.2 Initial Load in Classic Architecture
-
15
Customizing Oracle GoldenGate Processing
- 15.1 Executing Commands, Stored Procedures, and Queries with SQLEXEC
- 15.2 Using Oracle GoldenGate Macros to Simplify and Automate Work
-
15.3
Using User Exits to Extend Oracle GoldenGate Capabilities
- 15.3.1 When to Implement User Exits
- 15.3.2 Making Oracle GoldenGate Record Information Available to the Routine
- 15.3.3 Creating User Exits
- 15.3.4 Supporting Character-set Conversion in User Exits
- 15.3.5 Using Macros to Check Name Metadata
- 15.3.6 Describing the Character Format
- 15.3.7 Upgrading User Exits
- 15.3.8 Viewing Examples of How to Use the User Exit Functions
-
15.4
Using the Oracle GoldenGate Event Marker System to Raise Database Events
-
15.4.1
Case Studies in the Usage of the Event Marker System
- 15.4.1.1 Trigger End-of-day Processing
- 15.4.1.2 Simplify Transition from Initial Load to Change Synchronization
- 15.4.1.3 Stop Processing When Data Anomalies are Encountered
- 15.4.1.4 Trace a Specific Order Number
- 15.4.1.5 Execute a Batch Process
- 15.4.1.6 Propagate Only a SQL Statement without the Resultant Operations
- 15.4.1.7 Committing Other Transactions Before Starting a Long-running Transaction
- 15.4.1.8 Execute a Shell Script to Validate Data
-
15.4.1
Case Studies in the Usage of the Event Marker System
-
16
Monitoring Oracle GoldenGate Processing
- 16.1 Using the Information Commands in GGSCI
- 16.2 Monitoring an Extract Recovery
- 16.3 Monitoring Lag
- 16.4 Using Automatic Heartbeat Tables to Monitor
- 16.5 Monitoring Processing Volume
- 16.6 Using the Error Log
- 16.7 Using the Process Report
- 16.8 Using the Discard File
- 16.9 Maintaining the Discard and Report Files
- 16.10 Reconciling Time Differences
- 16.11 Getting Help with Performance Tuning
-
17
Tuning the Performance of Oracle GoldenGate
- 17.1 Using Multiple Process Groups
- 17.2 Splitting Large Tables Into Row Ranges Across Process Groups
- 17.3 Configuring Oracle GoldenGate to Use the Network Efficiently
- 17.4 Eliminating Disk I/O Bottlenecks
- 17.5 Managing Virtual Memory and Paging
- 17.6 Optimizing Data Filtering and Conversion
-
17.7
Tuning Replicat Transactions
- 17.7.1 Tuning Coordination Performance Against Barrier Transactions
- 17.7.2 Applying Similar SQL Statements in Arrays
- 17.7.3 Preventing Full Table Scans in the Absence of Keys
- 17.7.4 Splitting Large Transactions
- 17.7.5 Adjusting Open Cursors
- 17.7.6 Improving Update Speed
- 17.7.7 Set a Replicat Transaction Timeout
- 17.8 Using Healthcheck Scripts to Monitor and Troubleshoot
-
18
Performing Administrative Operations
- 18.1 Performing Application Patches
- 18.2 Initializing the Transaction Logs
- 18.3 Shutting Down the System
-
18.4
Changing Database Attributes
- 18.4.1 Changing Database Metadata
- 18.4.2 Adding Tables to the Oracle GoldenGate Configuration
- 18.4.3 Coordinating Table Attributes between Source and Target
- 18.4.4 Performing an ALTER TABLE to Add a Column on DB2 z/OS Tables
- 18.4.5 Dropping and Recreating a Source Table
- 18.4.6 Changing the Number of Oracle RAC Threads when Using Classic Capture
- 18.4.7 Changing the ORACLE_SID
- 18.4.8 Purging Archive Logs
- 18.4.9 Reorganizing a DB2 Table (z/OS Platform)
- 18.5 Adding Process Groups to an Active Configuration
- 18.6 Changing the Size of Trail Files
- 18.7 Switching Extract from Classic Mode to Integrated Mode
- 18.8 Switching Extract from Integrated Mode to Classic Mode
- 18.9 Switching Replicat from Non-Integrated Mode to Integrated Mode
- 18.10 Switching Replicat from Integrated Mode to Non-Integrated Mode
- 18.11 Switching Replicat to Coordinated Mode
- 18.12 Administering a Coordinated Replicat Configuration
- 18.13 Synchronizing Threads After an Unclean Stop
- 18.14 Restarting a Primary Extract after System Failure or Corruption
- 18.15 Using Automatic Trail File Recovery
-
10
Configuring Manager and Network Communications
- A Supported Character Sets
- B Supported Locales
- C About the Oracle GoldenGate Trail
- D Using the Commit Sequence Number
- E About Checkpoints