Table of Contents
- Title and Copyright Information
- Preface
-
1
Preparing the Database for Oracle GoldenGate
- Enabling Oracle GoldenGate in the Database
- Configuring Connections for Extract and Replicat Processes
- Setting Flashback Query
- Managing Server Resources
- Ensuring Row Uniqueness in Source and Target Tables
- Configuring Logging Properties
- Using the Extract Automated Capture Mode
- Additional Oracle GoldenGate Configuration for Your Database
- 2 Establishing Oracle GoldenGate Credentials
- 3 Configuring Oracle GoldenGate in a Multitenant Container Database
- 4 Configuring Oracle GoldenGate Replicat
-
5
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 Edition-Based Redefinition
- 6 Instantiating Oracle GoldenGate Replication
-
7
Configuring a Downstream Mining Database
- Evaluating Capture Options for a Downstream Deployment
- Preparing the Source Database for Downstream Deployment
- Preparing the Downstream Mining Database
- Enabling Downstream Extract Registration Using ADG Redirection in Downstream 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
-
8
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 Detection and Resolution
- Site Priority CDR
- Track PK Updates in Delete Tombstone
- Configuring Automatic Conflict Detection and Resolution
- Managing Automatic Conflict Detection and Resolution
- Monitoring Automatic Conflict Detection and Resolution
-
About Automatic Conflict Detection and Resolution
-
9
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
- 10 Using Oracle GoldenGate with Autonomous Database
-
11
Understanding What’s Supported
- Details of Support for Oracle Data Types and Objects
- Details of Support for Oracle Database Editions
- Details of Support for Objects and Operations in Oracle DML
- Details of Support for Objects and Operations in Oracle DDL
- A Configuring the Initial Load for Classic Architecture
- B Configuring the Data Pump Extract
- C Optional Parameters for Integrated Modes
- D Supporting Changes to XML Schemas
- E Preparing DBFS for an Active-Active Configuration