1/28

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Information
• Conventions

1 Understanding What’s Supported

• 1.1 Summary of Supported Oracle Data Types and Objects Per Capture Mode
• 1.2 Details of Support for Oracle Data Types
  • 1.2.1 ANYDATA Data Types
    • 1.2.1.1 Limitations of Support — ANYDATA
  • 1.2.2 Numeric Data Types
    • 1.2.2.1 Limitations of Support — Numeric
  • 1.2.3 Character Data Types
    • 1.2.3.1 Limitations of Support — Character
  • 1.2.4 Multi-byte Character Types
    • 1.2.4.1 Limitations of Support — Multi-byte
  • 1.2.5 Binary Data Types
  • 1.2.6 Date and Timestamp Data Types
    • 1.2.6.1 Limitations of Support — Dates
  • 1.2.7 Large Object Data Types
    • 1.2.7.1 Limitations of support — Large Object Classic Capture Mode
  • 1.2.8 XML Data Types
    • 1.2.8.1 Limitations of Support — Integrated and Classic Capture Modes
    • 1.2.8.2 Limitations of Support — Integrated Capture Mode
    • 1.2.8.3 Limitations of Support — XML Binary Classic Capture Mode
  • 1.2.9 User Defined or Abstract Types
    • 1.2.9.1 General Limitations of Support — Integrated and Classic Capture Modes
    • 1.2.9.2 Limitations for Collection Types — Integrated and Classic Capture Modes
    • 1.2.9.3 Limitations for Object Tables — Integrated and Classic Capture Modes
    • 1.2.9.4 Limitations for Spatial Types — Integrated and Classic Capture Modes
  • 1.2.10 Non-Supported Oracle Data Types
• 1.3 Details of Support for Objects and Operations in Oracle DML
  • 1.3.1 Multitenant Container Database
  • 1.3.2 Tables, Views, and Materialized Views
    • 1.3.2.1 Limitations of Support for Regular Tables
    • 1.3.2.2 Limitations of Support for Index-Organized Tables
    • 1.3.2.3 Limitations of Support for Views
    • 1.3.2.4 Limitations of Support for Materialized Views
    • 1.3.2.5 Limitations of Support for Clustered Tables
  • 1.3.3 Sequences
    • 1.3.3.1 Limitations of Support for Sequences
  • 1.3.4 Non-supported Objects and Operations in Oracle DML
• 1.4 Details of Support for Objects and Operations in Oracle DDL
  • 1.4.1 Supported Objects and Operations in Oracle DDL
  • 1.4.2 Non-supported Objects and Operations in Oracle DDL
    • 1.4.2.1 Excluded Objects
    • 1.4.2.2 Other Non-supported DDL
• 1.5 Integrating Oracle GoldenGate into a Cluster
  • 1.5.1 General Requirements in a Cluster
  • 1.5.2 Adding Oracle GoldenGate as a Windows Cluster Resource

2 Preparing the Database for Oracle GoldenGate

• 2.1 Configuring Connections for Integrated Processes
• 2.2 Configuring Logging Properties
  • 2.2.1 Enabling Minimum Database-level Supplemental Logging
  • 2.2.2 Enabling Schema-level Supplemental Logging
  • 2.2.3 Enabling Table-level Supplemental Logging
• 2.3 Enabling Oracle GoldenGate in the Database
• 2.4 Setting Flashback Query
• 2.5 Managing Server Resources

3 Establishing Oracle GoldenGate Credentials

• 3.1 Assigning Credentials to Oracle GoldenGate
  • 3.1.1 Extract User
  • 3.1.2 Replicat User
  • 3.1.3 Other Oracle GoldenGate Users
  • 3.1.4 Granting the Appropriate User Privileges
    • 3.1.4.1 Oracle 11.2.0.4 or Later Database Privileges
    • 3.1.4.2 Oracle 11.2.0.3 or Earlier Database Privileges
    • 3.1.4.3 About the dbms_goldengate_auth.grant_admin_privilege Package
    • 3.1.4.4 Optional Grants for dbms_goldengate_auth.grant_admin_privilege
• 3.2 Securing the Oracle GoldenGate Credentials

4 Choosing Capture and Apply Modes

• 4.1 Overview of Oracle GoldenGate Capture and Apply Processes
• 4.2 Deciding Which Capture Method to Use
  • 4.2.1 About Classic Capture
  • 4.2.2 About Integrated Capture
    • 4.2.2.1 Integrated Capture Supported Database Versions
    • 4.2.2.2 Integrated Capture Deployment Options
• 4.3 Deciding Which Apply Method to Use
  • 4.3.1 About Nonintegrated Replicat
  • 4.3.2 About Integrated Replicat
    • 4.3.2.1 Benefits of Integrated Replicat
    • 4.3.2.2 Integrated Replicat Requirements
• 4.4 Using Different Capture and Apply Modes Together
• 4.5 Switching to a Different Process Mode

5 Configuring Oracle GoldenGate in a Multitenant Container Database

• 5.1 Using Oracle GoldenGate with Pluggable Databases
  • 5.1.1 Capturing from Pluggable Databases
  • 5.1.2 Applying to Pluggable Databases
  • 5.1.3 Excluding Objects from the Configuration
• 5.2 Other Requirements for Multitenant Container Databases

6 Configuring Capture in Integrated Mode

• 6.1 Prerequisites for Configuring Integrated Capture
• 6.2 What to Expect from these Instructions
• 6.3 Configuring the Primary Extract in Integrated Capture Mode
• 6.4 Configuring the Data Pump Extract
• 6.5 Next Steps

7 Configuring Capture in Classic Mode

• 7.1 Prerequisites for Configuring Classic Capture
• 7.2 What to Expect from these Instructions
• 7.3 Configuring the Primary Extract in Classic Capture Mode
• 7.4 Configuring the Data Pump Extract
• 7.5 Next Steps

8 Configuring Oracle GoldenGate Apply

• 8.1 Prerequisites for Configuring Replicat
• 8.2 What to Expect from these Instructions
• 8.3 Creating a Checkpoint Table (Non-Integrated Replicat Only)
  • 8.3.1 Adding the Checkpoint Table to the Target Database
  • 8.3.2 Specifying the Checkpoint Table in the Oracle GoldenGate Configuration
  • 8.3.3 Disabling Default Asynchronous COMMIT to Checkpoint Table
• 8.4 Configuring Replicat
• 8.5 Next Steps

9 Additional Oracle GoldenGate Configuration Considerations

• 9.1 Ensuring Row Uniqueness in Source and Target Tables
• 9.2 Installing Support for Oracle Sequences
• 9.3 Handling Special Data Types
  • 9.3.1 Multibyte Character Types
  • 9.3.2 Oracle Spatial Objects
  • 9.3.3 TIMESTAMP
  • 9.3.4 Large Objects (LOB)
  • 9.3.5 XML
  • 9.3.6 User Defined Types
• 9.4 Handling Other Database Properties
• 9.5 Controlling the Checkpoint Frequency
• 9.6 Excluding Replicat Transactions
• 9.7 Advanced Configuration Options for Oracle GoldenGate

10 Additional Configuration Steps for Using Classic Capture

• 10.1 Configuring Oracle TDE Data in Classic Capture Mode
  • 10.1.1 Overview of TDE Support in Classic Capture Mode
  • 10.1.2 Requirements for Capturing TDE in Classic Capture Mode
  • 10.1.3 Required Database Patches for TDE Support
  • 10.1.4 Configuring Classic Capture for TDE Support
    • 10.1.4.1 Agree on a Shared Secret that Meets Oracle Standards
    • 10.1.4.2 Oracle DBA Tasks
    • 10.1.4.3 Oracle Security Officer Tasks
    • 10.1.4.4 Oracle GoldenGate Administrator Tasks
  • 10.1.5 Recommendations for Maintaining Data Security after Decryption
  • 10.1.6 Performing DDL while TDE Capture is Active
  • 10.1.7 Rekeying after a Database Upgrade
  • 10.1.8 Updating the Oracle Shared Secret in the Parameter File
• 10.2 Using Classic Capture in an Oracle RAC Environment
• 10.3 Mining ASM-stored Logs in Classic Capture Mode
  • 10.3.1 Accessing the Transaction Logs in ASM
    • 10.3.1.1 Reading Transaction Logs Through the RDBMS
    • 10.3.1.2 ASM Direct Connection
  • 10.3.2 Ensuring ASM Connectivity
• 10.4 Ensuring Data Availability for Classic Capture
  • 10.4.1 Log Retention Requirements per Extract Recovery Mode
  • 10.4.2 Log Retention Options
    • 10.4.2.1 Oracle Enterprise Edition 11g and Later
    • 10.4.2.2 All Other Oracle Versions
  • 10.4.3 Determining How Much Data to Retain
  • 10.4.4 Purging Log Archives
  • 10.4.5 Specifying the Archive Location
  • 10.4.6 Mounting Logs that are Stored on Other Platforms
• 10.5 Configuring Classic Capture in Archived Log Only Mode
  • 10.5.1 Limitations and Requirements for Using ALO Mode
  • 10.5.2 Configuring Extract for ALO mode
• 10.6 Configuring Classic Capture in Oracle Active Data Guard Only Mode
  • 10.6.1 Limitations and Requirements for Using ADG Mode
  • 10.6.2 Configuring Classic Extract for ADG Mode
  • 10.6.3 Migrating Classic Extract To and From an ADG Database
  • 10.6.4 Handling Role Changes In an ADG Configuration
• 10.7 Avoiding Log-read Bottlenecks in Classic Capture

11 Additional Configuration Steps For Using Nonintegrated Replicat

• 11.1 Disabling Triggers and Referential Cascade Constraints on Target Tables
• 11.2 Deferring Constraint Checking on Target Tables
  • 11.2.1 Handling Transient Primary-key Duplicates in Versions Earlier than 11.2.0.2
  • 11.2.2 Handling Transient Primary-key Duplicates in Version 11.2.0.2 or Later

12 Configuring DDL Support

• 12.1 Prerequisites for Configuring DDL
  • 12.1.1 Support for DDL Capture in Integrated Capture Mode
  • 12.1.2 Support for DDL Capture in Classic Capture Mode
• 12.2 Overview of DDL Synchronization
• 12.3 Limitations of Oracle GoldenGate DDL Support
  • 12.3.1 DDL Statement Length
  • 12.3.2 Supported Topologies
  • 12.3.3 Filtering, Mapping, and Transformation
  • 12.3.4 Renames
  • 12.3.5 Interactions Between Fetches from a Table and DDL
  • 12.3.6 Comments in SQL
  • 12.3.7 Compilation Errors
  • 12.3.8 Interval Partitioning
  • 12.3.9 DML or DDL Performed Inside a DDL Trigger
  • 12.3.10 LogMiner Data Dictionary Maintenance
• 12.4 Configuration Guidelines for DDL Support
  • 12.4.1 Database Privileges
  • 12.4.2 Parallel Processing
  • 12.4.3 Object Names
  • 12.4.4 Data Definitions
  • 12.4.5 Truncates
  • 12.4.6 Initial Synchronization
  • 12.4.7 Data Continuity After CREATE or RENAME
• 12.5 Understanding DDL Scopes
  • 12.5.1 Mapped Scope
  • 12.5.2 Unmapped Scope
  • 12.5.3 Other Scope
• 12.6 Correctly Identifying Unqualified Object Names in DDL
• 12.7 Enabling DDL Support
• 12.8 Filtering DDL Replication
  • 12.8.1 Filtering with PL/SQL Code
  • 12.8.2 Filtering With Built-in Filter Rules
    • 12.8.2.1 DDLAUX.addRule() Function Definition
    • 12.8.2.2 Parameters for DDLAUX.addRule()
    • 12.8.2.3 Valid DDL Components for DDLAUX.addRule()
    • 12.8.2.4 Examples of Rule-based Trigger Filtering
    • 12.8.2.5 Dropping Filter Rules
  • 12.8.3 Filtering with the DDL Parameter
• 12.9 Special Filter Cases
  • 12.9.1 DDL EXCLUDE ALL
  • 12.9.2 Implicit DDL
• 12.10 How Oracle GoldenGate Handles Derived Object Names
  • 12.10.1 MAP Exists for Base Object, But Not Derived Object
  • 12.10.2 MAP Exists for Base and Derived Objects
  • 12.10.3 MAP Exists for Derived Object, But Not Base Object
  • 12.10.4 New Tables as Derived Objects
    • 12.10.4.1 CREATE TABLE AS SELECT
    • 12.10.4.2 RENAME and ALTER TABLE RENAME
  • 12.10.5 Disabling the Mapping of Derived Objects
• 12.11 Using DDL String Substitution
• 12.12 Controlling the Propagation of DDL to Support Different Topologies
  • 12.12.1 Propagating DDL in Active-Active (Bidirectional) Configurations
  • 12.12.2 Propagating DDL in a Cascading Configuration
• 12.13 Adding Supplemental Log Groups Automatically
• 12.14 Removing Comments from Replicated DDL
• 12.15 Replicating an IDENTIFIED BY Password
• 12.16 How DDL is Evaluated for Processing
• 12.17 Viewing DDL Report Information
  • 12.17.1 Viewing DDL Reporting in Replicat
  • 12.17.2 Viewing DDL Reporting in Extract
  • 12.17.3 Statistics in the Process Reports
• 12.18 Tracing DDL Processing
• 12.19 Using Tools that Support Trigger-Based DDL Capture
  • 12.19.1 Tracing the DDL Trigger
  • 12.19.2 Viewing Metadata in the DDL History Table
  • 12.19.3 Handling DDL Trigger Errors
• 12.20 Using Edition-Based Redefinition

13 Creating Process Groups

• 13.1 Prerequisites
• 13.2 Registering Extract with the Mining Database
• 13.3 Add the Primary Extract
• 13.4 Add the Local Trail
• 13.5 Add the Data Pump Extract Group
• 13.6 Add the Remote Trail
• 13.7 Add the Replicat Group

14 Instantiating Oracle GoldenGate Replication

• 14.1 Overview of the Instantiation Process
• 14.2 Prerequisites for Instantiation
  • 14.2.1 Configuring and Adding Change Synchronization Groups
  • 14.2.2 Disabling DDL Processing
  • 14.2.3 Adding Collision Handling
  • 14.2.4 Preparing the Target Tables
• 14.3 Configuring the Initial Load
  • 14.3.1 Configuring a Load with an Oracle Data Pump
  • 14.3.2 Configuring a Direct Bulk Load to SQL*Loader
  • 14.3.3 Configuring a Load from an Input File to SQL*Loader
• 14.4 Performing the Target Instantiation
  • 14.4.1 Performing Instantiation with Oracle Data Pump
  • 14.4.2 Performing Instantiation with Direct Bulk Load to SQL*Loader
  • 14.4.3 Performing Instantiation From an Input File to SQL*Loader
• 14.5 Monitoring and Controlling Processing After the Instantiation
• 14.6 Verifying Synchronization
• 14.7 Backing up the Oracle GoldenGate Environment

15 Managing the DDL Replication Environment

• 15.1 Disabling DDL Processing Temporarily
• 15.2 Enabling and Disabling the DDL Trigger
• 15.3 Maintaining the DDL Marker Table
• 15.4 Deleting the DDL Marker Table
• 15.5 Maintaining the DDL History Table
• 15.6 Deleting the DDL History Table
• 15.7 Purging the DDL Trace File
• 15.8 Applying Database Patches and Upgrades when DDL Support is Enabled
• 15.9 Apply Oracle GoldenGate Patches and Upgrades when DDL support is Enabled
• 15.10 Restoring an Existing DDL Environment to a Clean State
• 15.11 Removing the DDL Objects from the System

16 Automatic Conflict Detection and Resolution

• 16.1 About Automatic Conflict Detection and Resolution
  • 16.1.1 Automatic Conflict Detection and Resolution
  • 16.1.2 Latest Timestamp Conflict Detection and Resolution
  • 16.1.3 Delta Conflict Detection and Resolution
  • 16.1.4 Column Groups
• 16.2 Configuring Automatic Conflict Detection and Resolution
  • 16.2.1 Configuring Latest Timestamp Conflict Detection and Resolution
  • 16.2.2 Configuring Delta Conflict Detection and Resolution
• 16.3 Managing Automatic Conflict Detection and Resolution
  • 16.3.1 Altering Conflict Detection and Resolution for a Table
  • 16.3.2 Altering a Column Group
  • 16.3.3 Purging Tombstone Rows
  • 16.3.4 Removing Conflict Detection and Resolution From a Table
  • 16.3.5 Removing a Column Group
  • 16.3.6 Removing Delta Conflict Detection and Resolution
• 16.4 Monitoring Automatic Conflict Detection and Resolution
  • 16.4.1 Displaying Information About the Tables Configured for Conflicts
  • 16.4.2 Displaying Information About Conflict Resolution Columns
  • 16.4.3 Displaying Information About Column Groups

17 Using Parallel Replicat

• 17.1 Overview of Parallel Replicat
• 17.2 Parallel Replication Architecture
• 17.3 Basic Parameters for Parallel Replicat
• 17.4 Creating a Parallel Replicat

18 Using Procedural Replication

• 18.1 About Procedural Replication
• 18.2 Procedural Replication Process Overview
• 18.3 Enabling Procedural Replication
• 18.4 Determining Whether Procedural Replication Is On
• 18.5 Enabling and Disabling Supplemental Logging
• 18.6 Filtering Features for Procedural Replication
• 18.7 Handling Procedural Replication Errors
• 18.8 Procedural Replication Pragma Options
• 18.9 Listing the Procedures Supported for Oracle GoldenGate Procedural Replication
• 18.10 Monitoring Oracle GoldenGate Procedural Replication

19 Replicating Data to Oracle Autonomous Data Warehouse Cloud

• 19.1 About Replicating Data to Autonomous Databases
• 19.2 Understanding What is Supported While Replicating to the Autonomous Database
• 19.3 How Do I Replicate Data to Oracle Autonomous Data Warehouse Cloud?

A Optional Parameters for Integrated Modes

• A.1 Additional Parameter Options for Integrated Capture
• A.2 Additional Parameter Options for Integrated Replicat

B Configuring a Downstream Mining Database

• B.1 Evaluating Capture Options for a Downstream Deployment
• B.2 Preparing the Source Database for Downstream Deployment
  • B.2.1 Creating the Source User Account
  • B.2.2 Configuring Redo Transport from Source to Downstream Mining Database
• B.3 Preparing the Downstream Mining Database
  • B.3.1 Creating the Downstream Mining User Account
  • B.3.2 Configuring the Mining Database to Archive Local Redo Log Files
  • B.3.3 Preparing a Downstream Mining Database for Real-time Capture
    • B.3.3.1 Create the Standby Redo Log Files
    • B.3.3.2 Configure the Database to Archive Standby Redo Log Files Locally

C Example Downstream Mining Configuration

• C.1 Example 1: Capturing from One Source Database in Real-time Mode
  • C.1.1 Prepare the Mining Database to Archive its Local Redo
  • C.1.2 Prepare the Mining Database to Archive Redo Received in Standby Redo Logs from the Source Database
  • C.1.3 Prepare the Source Database to Send Redo to the Mining Database
  • C.1.4 Set up Integrated Capture (ext1) on DBMSCAP
• C.2 Example 2: Capturing from Multiple Sources in Archive-log-only Mode
  • C.2.1 Prepare the Mining Database to Archive its Local Redo
  • C.2.2 Prepare the Mining Database to Archive Redo from the Source Database
  • C.2.3 Prepare the First Source Database to Send Redo to the Mining Database
  • C.2.4 Prepare the Second Source Database to Send Redo to the Mining Database
  • C.2.5 Set up Extracts at Downstream Mining Database
• C.3 Example 3: Capturing from Multiple Sources with Mixed Real-time and Archive-log-only Mode
  • C.3.1 Prepare the Mining Database to Archive its Local Redo
  • C.3.2 Prepare the Mining Database to Accept Redo from the Source Databases
  • C.3.3 Prepare the First Source Database to Send Redo to the Mining Database
  • C.3.4 Prepare the Second Source Database to Send Redo to the Mining Database
  • C.3.5 Prepare the Third Source Database to Send Redo to the Mining Database
  • C.3.6 Set up Extracts at Downstream Mining Database
    • C.3.6.1 Set up Extract (ext1) to Capture Changes from Archived Logs Sent by DBMS1
    • C.3.6.2 Set up Extract (ext2) to Capture Changes from Archived Logs Sent by DBMS2
    • C.3.6.3 Set up Extract (ext3) to Capture Changes in Real-time Mode from Online Logs Sent by DBMS3

D Installing Trigger-Based DDL Capture

• D.1 When to Use Trigger-based DDL Capture
• D.2 Overview of the Objects that Support Trigger-based DDL Capture
• D.3 Installing the DDL Objects

E Supporting Changes to XML Schemas

• E.1 Supporting RegisterSchema
• E.2 Supporting DeleteSchema
• E.3 Supporting CopyEvolve

F Preparing DBFS for an Active-Active Configuration

• F.1 Supported Operations and Prerequisites
• F.2 Applying the Required Patch
• F.3 Examples Used in these Procedures
  • F.3.1 Partitioning the DBFS Sequence Numbers
  • F.3.2 Configuring the DBFS file system
  • F.3.3 Mapping Local and Remote Peers Correctly