1/27

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 System Requirements and Preinstallation Instructions

• 1.1 Verifying Certification and System Requirements
• 1.2 Operating System Requirements
  • 1.2.1 Memory Requirements
  • 1.2.2 Disk Requirements
    • 1.2.2.1 Disk Requirements for Oracle GoldenGate Installation Files
    • 1.2.2.2 Other Disk Space Considerations
    • 1.2.2.3 Installing in a Cluster
    • 1.2.2.4 Temporary Disk Requirements
  • 1.2.3 Network
  • 1.2.4 Operating System Privileges
  • 1.2.5 Itanium Requirements
  • 1.2.6 Console Character Sets
  • 1.2.7 Other Programs
• 1.3 Oracle Universal Installer Requirements for Oracle GoldenGate
• 1.4 Database Configuration
• 1.5 Summary of Supported Oracle Data Types and Objects Per Capture Mode
• 1.6 Details of Support for Oracle Data Types
  • 1.6.1 ANYDATA Data Types
    • 1.6.1.1 Limitations of Support
  • 1.6.2 Numeric Data Types
    • 1.6.2.1 Limitations of Support
  • 1.6.3 Character Data Types
    • 1.6.3.1 Limitations of Support
  • 1.6.4 Multi-byte Character Types
    • 1.6.4.1 Limitations of Support
  • 1.6.5 Binary Data Types
  • 1.6.6 Date and Timestamp Data Types
    • 1.6.6.1 Limitations of Support
  • 1.6.7 Large Object Data Types
    • 1.6.7.1 General Limitations of Support — Integrated and Classic Capture Modes
    • 1.6.7.2 Limitations of support — Classic Capture Mode
  • 1.6.8 XML Data Types
    • 1.6.8.1 Limitations of Support — Integrated and Classic Capture Modes
    • 1.6.8.2 Limitations of Support — Integrated Capture Mode
    • 1.6.8.3 Limitations of Support — Classic Capture Mode
  • 1.6.9 User Defined or Abstract Types
    • 1.6.9.1 General Limitations of Support — Integrated and Classic Capture Modes
    • 1.6.9.2 Limitations for Collection Types — Integrated and Classic Capture Modes
    • 1.6.9.3 Limitations for Object Tables — Integrated and Classic Capture Modes
    • 1.6.9.4 Limitations for Spatial Types — Integrated and Classic Capture Modes
  • 1.6.10 Non-Supported Oracle Data Types
• 1.7 Details of Support for Objects and Operations in Oracle DML
  • 1.7.1 Multitenant Container Databases
  • 1.7.2 Tables, Views, and Materialized Views
    • 1.7.2.1 Limitations of Support for Regular Tables
    • 1.7.2.2 Limitations of Support for Index-Organized Tables
    • 1.7.2.3 Limitations of Support for Views
    • 1.7.2.4 Limitations of Support for Materialized Views
    • 1.7.2.5 Limitations of Support for Clustered Tables
  • 1.7.3 Sequences
    • 1.7.3.1 Limitations of Support for Sequences
  • 1.7.4 Non-supported Objects and Operations in Oracle DML
• 1.8 Details of Support for Objects and Operations in Oracle DDL
  • 1.8.1 Supported Objects and Operations in Oracle DDL
  • 1.8.2 Non-supported Objects and Operations in Oracle DDL
    • 1.8.2.1 Excluded Objects
    • 1.8.2.2 Other Non-supported DDL
• 1.9 Supported and Non-supported Object Names

2 Installing Oracle GoldenGate

• 2.1 Downloading Oracle GoldenGate
• 2.2 Setting ORACLE_HOME and ORACLE_SID
  • 2.2.1 Specifying Oracle Variables on UNIX and Linux Systems
  • 2.2.2 Specifying Oracle Variables on Windows Systems
• 2.3 Setting Library Paths for Dynamic Builds on UNIX
• 2.4 Preparing to Install Oracle GoldenGate Within a Cluster
  • 2.4.1 Supported Oracle Cluster Storage
  • 2.4.2 Deciding Where to Install Oracle GoldenGate Binaries and Files in the Cluster
• 2.5 Installing Oracle GoldenGate
  • 2.5.1 Performing an Interactive Installation with OUI
  • 2.5.2 Performing a Silent Installation with OUI
• 2.6 Integrating Oracle GoldenGate into a Cluster
  • 2.6.1 General Requirements in a Cluster
  • 2.6.2 Adding Oracle GoldenGate as a Windows Cluster Resource

3 Preparing the Database for Oracle GoldenGate

• 3.1 Configuring Connections for Integrated Processes
• 3.2 Configuring Logging Properties
  • 3.2.1 Enabling Minimum Database-level Supplemental Logging
  • 3.2.2 Enabling Schema-level Supplemental Logging
  • 3.2.3 Enabling Table-level Supplemental Logging
• 3.3 Enabling Oracle GoldenGate in the Database
• 3.4 Setting Flashback Query
• 3.5 Managing Server Resources

4 Establishing Oracle GoldenGate Credentials

• 4.1 Assigning Credentials to Oracle GoldenGate
  • 4.1.1 Extract User
  • 4.1.2 Replicat User
  • 4.1.3 Other Oracle GoldenGate Users
  • 4.1.4 Granting the Appropriate User Privileges
    • 4.1.4.1 Oracle 11.2.0.4 or Later Database Privileges
    • 4.1.4.2 Oracle 11.2.0.3 or Earlier Database Privileges
    • 4.1.4.3 About the dbms_goldengate_auth.grant_admin_privilege Package
    • 4.1.4.4 Optional Grants for dbms_goldengate_auth.grant_admin_privilege
• 4.2 Securing the Oracle GoldenGate Credentials

5 Choosing Capture and Apply Modes

• 5.1 Overview of Oracle GoldenGate Capture and Apply Processes
• 5.2 Deciding Which Capture Method to Use
  • 5.2.1 About Classic Capture
  • 5.2.2 About Integrated Capture
    • 5.2.2.1 Integrated Capture Supported Database Versions
    • 5.2.2.2 Integrated Capture Deployment Options
• 5.3 Deciding Which Apply Method to Use
  • 5.3.1 About Nonintegrated Replicat
  • 5.3.2 About Integrated Replicat
    • 5.3.2.1 Benefits of Integrated Replicat
    • 5.3.2.2 Integrated Replicat Requirements
• 5.4 Using Different Capture and Apply Modes Together
• 5.5 Switching to a Different Process Mode

6 Configuring Oracle GoldenGate in a Multitenant Container Database

• 6.1 Using Oracle GoldenGate with Pluggable Databases
  • 6.1.1 Capturing from Pluggable Databases
  • 6.1.2 Applying to Pluggable Databases
  • 6.1.3 Excluding Objects from the Configuration
• 6.2 Other Requirements for Multitenant Container Databases

7 Configuring Capture in Integrated Mode

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

8 Configuring Capture in Classic Mode

• 8.1 Prerequisites for Configuring Classic Capture
• 8.2 What to Expect from these Instructions
• 8.3 Configuring the Primary Extract in Classic Capture Mode
• 8.4 Configuring the Data Pump Extract
• 8.5 Next Steps

9 Configuring Oracle GoldenGate Apply

• 9.1 Prerequisites for Configuring Replicat
• 9.2 What to Expect from these Instructions
• 9.3 Creating a Checkpoint Table (Nonintegrated Replicat Only)
  • 9.3.1 Adding the Checkpoint Table to the Target Database
  • 9.3.2 Specifying the Checkpoint Table in the Oracle GoldenGate Configuration
  • 9.3.3 Disabling Default Asynchronous COMMIT to Checkpoint Table
• 9.4 Configuring Replicat
• 9.5 Next Steps

10 Additional Oracle GoldenGate Configuration Considerations

• 10.1 Ensuring Row Uniqueness in Source and Target Tables
• 10.2 Installing Support for Oracle Sequences
• 10.3 Handling Special Data Types
  • 10.3.1 Multibyte Character Types
  • 10.3.2 Oracle Spatial Objects
  • 10.3.3 TIMESTAMP
  • 10.3.4 Large Objects (LOB)
  • 10.3.5 XML
  • 10.3.6 User Defined Types
• 10.4 Handling Other Database Properties
• 10.5 Controlling the Checkpoint Frequency
• 10.6 Excluding Replicat Transactions
• 10.7 Advanced Configuration Options for Oracle GoldenGate

11 Additional Configuration Steps for Using Classic Capture

• 11.1 Configuring Oracle TDE Data in Classic Capture Mode
  • 11.1.1 Overview of TDE Support in Classic Capture Mode
  • 11.1.2 Requirements for Capturing TDE in Classic Capture Mode
  • 11.1.3 Required Database Patches for TDE Support
  • 11.1.4 Configuring Classic Capture for TDE Support
    • 11.1.4.1 Agree on a Shared Secret that Meets Oracle Standards
    • 11.1.4.2 Oracle DBA Tasks
    • 11.1.4.3 Oracle Security Officer Tasks
    • 11.1.4.4 Oracle GoldenGate Administrator Tasks
  • 11.1.5 Recommendations for Maintaining Data Security after Decryption
  • 11.1.6 Performing DDL while TDE Capture is Active
  • 11.1.7 Rekeying after a Database Upgrade
  • 11.1.8 Updating the Oracle Shared Secret in the Parameter File
• 11.2 Using Classic Capture in an Oracle RAC Environment
• 11.3 Mining ASM-stored Logs in Classic Capture Mode
  • 11.3.1 Accessing the Transaction Logs in ASM
    • 11.3.1.1 Reading Transaction Logs Through the RDBMS
    • 11.3.1.2 ASM Direct Connection
  • 11.3.2 Ensuring ASM Connectivity
• 11.4 Ensuring Data Availability for Classic Capture
  • 11.4.1 Log Retention Requirements per Extract Recovery Mode
  • 11.4.2 Log Retention Options
    • 11.4.2.1 Oracle Enterprise Edition 11g and Later
    • 11.4.2.2 All Other Oracle Versions
  • 11.4.3 Determining How Much Data to Retain
  • 11.4.4 Purging Log Archives
  • 11.4.5 Specifying the Archive Location
  • 11.4.6 Mounting Logs That are Stored on Other Platforms
• 11.5 Configuring Classic Capture in Archived Log Only Mode
  • 11.5.1 Limitations and Requirements for Using ALO Mode
  • 11.5.2 Configuring Extract for ALO mode
• 11.6 Configuring Classic Capture in Oracle Active Data Guard Only Mode
  • 11.6.1 Limitations and Requirements for Using ADG Mode
  • 11.6.2 Configuring Extract for ADG Mode
  • 11.6.3 Migrating Classic Extract To and From an ADG Database
  • 11.6.4 Handling Role Changes In an ADG Configuration
• 11.7 Avoiding Log-read Bottlenecks in Classic Capture

12 Additional Configuration Steps For Using Nonintegrated Replicat

• 12.1 Disabling Triggers and Referential Cascade Constraints on Target Tables
• 12.2 Deferring Constraint Checking on Target Tables
  • 12.2.1 Handling Transient Primary-key Duplicates in Versions Earlier than 11.2.0.2
  • 12.2.2 Handling Transient Primary-key Duplicates in Version 11.2.0.2 or Later

13 Configuring DDL Support

• 13.1 Prerequisites for Configuring DDL
  • 13.1.1 Support for DDL capture in integrated capture mode
  • 13.1.2 Support for DDL capture in classic capture mode
• 13.2 Overview of DDL Synchronization
• 13.3 Limitations of Oracle GoldenGate DDL Support
  • 13.3.1 DDL Statement Length
  • 13.3.2 Supported Topologies
  • 13.3.3 Filtering, Mapping, and Transformation
  • 13.3.4 Renames
  • 13.3.5 Interactions Between Fetches from a Table and DDL
  • 13.3.6 Comments in SQL
  • 13.3.7 Compilation Errors
  • 13.3.8 Interval Partitioning
  • 13.3.9 DML or DDL Performed Inside a DDL Trigger
  • 13.3.10 LogMiner Data Dictionary Query Errors
• 13.4 Configuration Guidelines for DDL Support
  • 13.4.1 Database Privileges
  • 13.4.2 Parallel Processing
  • 13.4.3 DDL and DML in Data Pumps
  • 13.4.4 Object Names
  • 13.4.5 Data Definitions
  • 13.4.6 Truncates
  • 13.4.7 Initial Synchronization
  • 13.4.8 Data Continuity After CREATE or RENAME
• 13.5 Understanding DDL Scopes
  • 13.5.1 Mapped Scope
    • 13.5.1.1 Mapping Oracle Cluster Tables and UDTs
    • 13.5.1.2 Mapping ALTER INDEX
  • 13.5.2 Unmapped Scope
  • 13.5.3 Other Scope
• 13.6 Correctly Identifying Unqualified Object Names in DDL
• 13.7 Enabling DDL Support
• 13.8 Filtering DDL Replication
  • 13.8.1 Filtering with PL/SQL Code
  • 13.8.2 Filtering With Built-in Filter Rules
    • 13.8.2.1 DDLAUX.addRule() Function Definition
    • 13.8.2.2 Parameters for DDLAUX.addRule()
    • 13.8.2.3 Valid DDL Components for DDLAUX.addRule()
    • 13.8.2.4 Examples of Rule-based Trigger Filtering
    • 13.8.2.5 Dropping Filter Rules
  • 13.8.3 Filtering with the DDL Parameter
• 13.9 Special Filter Cases
  • 13.9.1 DDL EXCLUDE ALL
  • 13.9.2 Implicit DDL
• 13.10 How Oracle GoldenGate Handles Derived Object Names
  • 13.10.1 MAP Exists for Base Object, But Not Derived Object
  • 13.10.2 MAP Exists for Base and Derived Objects
  • 13.10.3 MAP Exists for Derived Object, But Not Base Object
  • 13.10.4 New Tables as Derived Objects
    • 13.10.4.1 RENAME and ALTER TABLE RENAME
    • 13.10.4.2 CREATE TABLE AS SELECT
  • 13.10.5 Disabling the Mapping of Derived Objects
• 13.11 Using DDL String Substitution
• 13.12 Controlling the Propagation of DDL to Support Different Topologies
  • 13.12.1 Propagating DDL in Active-Active (Bidirectional) Configurations
  • 13.12.2 Propagating DDL in a Cascading Configuration
• 13.13 Adding Supplemental Log Groups Automatically
• 13.14 Removing Comments from Replicated DDL
• 13.15 Replicating an IDENTIFIED BY Password
• 13.16 How DDL is Evaluated for Processing
• 13.17 Handling DDL Processing Errors
• 13.18 Viewing DDL Report Information
  • 13.18.1 Viewing DDL Reporting in Replicat
  • 13.18.2 Viewing DDL Reporting in Extract
  • 13.18.3 Statistics in the Process Reports
• 13.19 Tracing DDL Processing
• 13.20 Using Tools that Support Trigger-Based DDL Capture
  • 13.20.1 Tracing the DDL Trigger
  • 13.20.2 Viewing Metadata in the DDL History Table
  • 13.20.3 Handling DDL Trigger Errors
• 13.21 Using Edition-Based Redefinition

14 Creating Process Groups

• 14.1 Prerequisites to These Procedures
• 14.2 Registering Extract with the Mining Database
• 14.3 Adding the Primary Extract
• 14.4 Add the Local Trail
• 14.5 Add the Data Pump Extract Group
• 14.6 Add the Remote Trail
• 14.7 Add the Replicat Group

15 Instantiating Oracle GoldenGate Replication

• 15.1 Overview of the Instantiation Process
• 15.2 Satisfying Prerequisites for Instantiation
  • 15.2.1 Configuring and Adding Change Synchronization Groups
  • 15.2.2 Disabling DDL Processing
  • 15.2.3 Adding Collision Handling
  • 15.2.4 Preparing the Target Tables
• 15.3 Configuring the Initial Load
  • 15.3.1 Configuring a Load with an Oracle Data Pump
  • 15.3.2 Configuring a Direct Bulk Load to SQL*Loader
  • 15.3.3 Configuring a Load from an Input File to SQL*Loader
• 15.4 Performing the Target Instantiation
  • 15.4.1 Performing Instantiation with Oracle Data Pump
  • 15.4.2 Performing Instantiation with Direct Bulk Load to SQL*Loader
  • 15.4.3 Performing Instantiation From an Input File to SQL*Loader
• 15.5 Monitoring and Controlling Processing After the Instantiation
• 15.6 Verifying Synchronization
• 15.7 Backing up the Oracle GoldenGate Environment

16 Managing the DDL Replication Environment

• 16.1 Disabling DDL Processing Temporarily
• 16.2 Enabling and Disabling the DDL Trigger
• 16.3 Maintaining the DDL Marker Table
• 16.4 Deleting the DDL Marker Table
• 16.5 Maintaining the DDL History Table
• 16.6 Deleting the DDL History Table
• 16.7 Purging the DDL Trace File
• 16.8 Applying Database Patches and Upgrades when DDL Support is Enabled
• 16.9 Applying Oracle GoldenGate Patches and Upgrades when DDL support is Enabled
• 16.10 Restoring an Existing DDL Environment to a Clean State
• 16.11 Removing the DDL Objects from the System

17 Uninstalling Oracle GoldenGate

• 17.1 Stopping Processes
• 17.2 Removing the DDL Environment
• 17.3 Removing Database Objects
• 17.4 Uninstalling Oracle GoldenGate Using Oracle Universal Installer
• 17.5 Uninstalling Oracle GoldenGate Manually
  • 17.5.1 Manually Removing Oracle GoldenGate Windows Components
  • 17.5.2 Manually Removing the Oracle GoldenGate Files

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 the Downstream Mining Database
    • C.2.5.1 Set up Extract (ext1) to Capture Changes from Archived Logs Sent by DBMS1
    • C.2.5.2 Set up Extract (ext2) to Capture Changes from Archived Logs Sent by DBMS2
• 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.4 Partitioning the DBFS Sequence Numbers
• F.5 Configuring the DBFS file system
• F.6 Mapping Local and Remote Peers Correctly

G Oracle GoldenGate Installed Components

• G.1 Oracle GoldenGate Programs and Utilities
• G.2 Oracle GoldenGate Subdirectories
• G.3 Other Oracle GoldenGate Files
• G.4 Oracle GoldenGate Checkpoint Table