Table of Contents
- Title and Copyright Information
- Preface
-
1
Understanding What’s Supported
- 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
- Integrating Oracle GoldenGate into a Cluster
- 2 Preparing the Database for Oracle GoldenGate
- 3 Establishing Oracle GoldenGate Credentials
- 4 Choosing Capture and Apply Modes
- 5 Using Parallel Replicat
- 6 Configuring Capture in Integrated Mode
- 7 Configuring Oracle GoldenGate Apply
- 8 Additional Oracle GoldenGate Configuration Considerations
- 9 Additional Configuration Steps For Using Nonintegrated Replicat
-
10
Configuring DDL Support
- Prerequisites for Configuring DDL
- Overview of DDL Synchronization
- Limitations of Oracle GoldenGate DDL Support
- Configuration Guidelines for DDL Support
- 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
- Adding 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
- Using Tools that Support Trigger-Based DDL Capture
- Using Edition-Based Redefinition
- 11 Creating Process Groups
- 12 Instantiating Oracle GoldenGate Replication
-
13
Managing the DDL Replication Environment
- Disabling DDL Processing Temporarily
- Enabling and Disabling the DDL Trigger
- Maintaining the DDL Marker Table
- Deleting the DDL Marker Table
- Maintaining the DDL History Table
- Deleting the DDL History Table
- Purging the DDL Trace File
- Applying Database Patches and Upgrades when DDL Support is Enabled
- Apply Oracle GoldenGate Patches and Upgrades when DDL support is Enabled
- Restoring an Existing DDL Environment to a Clean State
- Removing the DDL Objects from the System
- 14 Automatic Conflict Detection and Resolution
-
15
Using Procedural Replication
- About Procedural Replication
- Procedural Replication Process Overview
- Enabling Procedural Replication
- Determining Whether Procedural Replication Is On
- Enabling and Disabling Supplemental Logging
- Filtering Features for Procedural Replication
- Handling Procedural Replication Errors
- Procedural Replication Pragma Options
- Listing the Procedures Supported for Oracle GoldenGate Procedural Replication
- Monitoring Oracle GoldenGate Procedural Replication
- 16 Configuring Oracle GoldenGate in a Multitenant Container Database
- 17 Using Oracle GoldenGate with Autonomous Database
- A Optional Parameters for Integrated Modes
- B Configuring a Downstream Mining Database
-
C
Example Downstream Mining Configuration
- Example 1: Capturing from One Source Database in Real-time Mode
-
Example 2: Capturing from Multiple Sources in Archive-log-only Mode
- Prepare the Mining Database to Archive its Local Redo
- Prepare the Mining Database to Archive Redo from the Source Database
- Prepare the First Source Database to Send Redo to the Mining Database
- Prepare the Second Source Database to Send Redo to the Mining Database
- Set up Extracts at Downstream Mining Database
-
Example 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 Third Source Database to Send Redo to the Mining Database
- Set up Extracts at Downstream Mining Database
- D Installing Trigger-Based DDL Capture
- E Supporting Changes to XML Schemas
- F Preparing DBFS for an Active-Active Configuration
- G Support for Classic Extract
- H Configuring Capture in Classic Mode
-
I
Additional Configuration Steps for Using Classic Capture
-
Configuring Oracle TDE Data in Classic Capture Mode
- Overview of TDE Support in Classic Capture Mode
- Requirements for Capturing TDE in Classic Capture Mode
- Required Database Patches for TDE Support
- Configuring Classic Capture for TDE Support
- Recommendations for Maintaining Data Security after Decryption
- Performing DDL while TDE Capture is Active
- Rekeying after a Database Upgrade
- Updating the Oracle Shared Secret in the Parameter File
- Using Classic Capture in an Oracle RAC Environment
- Mining ASM-stored Logs in Classic Capture Mode
- Ensuring Data Availability for Classic Capture
- Configuring Classic Capture in Archived Log Only Mode
- Configuring Classic Capture in Oracle Active Data Guard Only Mode
- Avoiding Log-read Bottlenecks in Classic Capture
-
Configuring Oracle TDE Data in Classic Capture Mode