1/11

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 System Requirements and Preinstallation Instructions

• 1.1 Overview of Oracle GoldenGate for Teradata
• 1.2 What this Documentation Provides
• 1.3 Verifying Certification and System Requirements
• 1.4 Supported Platforms for a Replication Server
• 1.5 Operating System Requirements
  • 1.5.1 Memory Requirements
  • 1.5.2 Disk Requirements
  • 1.5.3 Relay Services Gateway (RSG) vprocs
  • 1.5.4 Network
  • 1.5.5 Operating System Privileges
  • 1.5.6 Console
  • 1.5.7 Other Programs
• 1.6 Database Requirements
  • 1.6.1 Database Configuration
  • 1.6.2 Database User for Oracle GoldenGate Processes
• 1.7 Supported Teradata Data Types
  • 1.7.1 Limitations of Support for Numeric Data Types
  • 1.7.2 Limitations of Support for Single-byte Character Data Types
  • 1.7.3 Conditions and Limitations of Support for Multi-byte Character Data
  • 1.7.4 Limitations of Support for Binary Data Types
  • 1.7.5 Limitations of Support for Large Object Data Types
  • 1.7.6 Limitations of Support for Date Data Types
  • 1.7.7 Limitations of Support for IDENTITY Data Types
• 1.8 Supported Objects and Operations for Teradata
  • 1.8.1 DML
  • 1.8.2 DDL

2 Installing Oracle GoldenGate

• 2.1 Installation Overview
• 2.2 Downloading Oracle GoldenGate
• 2.3 Setting Library Paths for Dynamic Builds on UNIX
• 2.4 Preparing to Install Oracle GoldenGate within a Cluster
  • 2.4.1 Deciding Where to Install Oracle GoldenGate Binaries and Files in the Cluster
• 2.5 Installing Oracle GoldenGate on Linux and UNIX
• 2.6 Installing Oracle GoldenGate on Windows
  • 2.6.1 Installing Oracle GoldenGate into a Windows Cluster
  • 2.6.2 Installing the Oracle GoldenGate Files
  • 2.6.3 Specifying a custom Manager name
  • 2.6.4 Installing Manager as a Windows Service
• 2.7 Integrating Oracle GoldenGate into a Cluster
  • 2.7.1 General Requirements in a Cluster
  • 2.7.2 Adding Oracle GoldenGate as a Windows Cluster Resource

3 Preparing the System for Oracle GoldenGate

• 3.1 Preparing Tables for Processing
  • 3.1.1 Disabling Triggers and Cascade Constraints
  • 3.1.2 Assigning Row Identifiers
    • 3.1.2.1 How Oracle GoldenGate Determines the Kind of Row Identifier to Use
    • 3.1.2.2 Using KEYCOLS to Specify a Custom Key
• 3.2 Creating a Teradata Replication Group
• 3.3 Activating DDL Capture by the Teradata TAM
• 3.4 Disabling the Capture of DDL
• 3.5 Configuring the TAM Initialization File

4 Configuring Oracle GoldenGate

• 4.1 Configuring Oracle GoldenGate in Maximum Protection Mode
  • 4.1.1 Recommended Maximum Protection Configuration
  • 4.1.2 Configuring Extract in Maximum Protection Mode
  • 4.1.3 Configuring Replicat to Support Maximum Protection Mode
• 4.2 Configuring Oracle GoldenGate in Maximum Performance Mode
  • 4.2.1 Recommended Maximum Performance Configuration
  • 4.2.2 Configuring Extract in Maximum Performance Mode
  • 4.2.3 Configuring Replicat to Support Maximum Performance Mode
• 4.3 Additional Oracle GoldenGate Configuration Guidelines
  • 4.3.1 Configuring DDL Support
  • 4.3.2 Handling Massive Update and Delete Operations
  • 4.3.3 Preventing Multiple Connections
  • 4.3.4 Performing Initial Synchronization

5 Configuring DDL Synchronization for a Teradata Database

• 5.1 About this Chapter
• 5.2 Overview of DDL Synchronization
• 5.3 Limitations of Oracle GoldenGate DDL Support
  • 5.3.1 DDL Statement Length
  • 5.3.2 Supported Topologies
  • 5.3.3 Filtering, Mapping, and Transformation
  • 5.3.4 DDL Response Time
• 5.4 Configuration Guidelines for DDL Support
  • 5.4.1 Database Privileges
  • 5.4.2 Parallel Processing
  • 5.4.3 DDL and DML in Data Pumps and VAM-sort Extracts
  • 5.4.4 Object Names
  • 5.4.5 Data Definitions
  • 5.4.6 Initial Synchronization
• 5.5 Understanding DDL Scopes
  • 5.5.1 Mapped Scope
    • 5.5.1.1 Mapping ALTER INDEX
  • 5.5.2 Unmapped Scope
  • 5.5.3 Other Scope
• 5.6 Enabling DDL Support
• 5.7 Filtering DDL Replication
  • 5.7.1 Combining DDL Parameter Options
  • 5.7.2 DDL EXCLUDE ALL
• 5.8 How Oracle GoldenGate Handles Derived Object Names
  • 5.8.1 Mapping Derived Objects
    • 5.8.1.1 MAP Exists forBbase Object, But Not Derived Object
    • 5.8.1.2 MAP Exists for Base and Derived Objects
    • 5.8.1.3 MAP Exists for Derived Object, But Not Base Object
  • 5.8.2 New Tables as Derived Objects
    • 5.8.2.1 RENAME
    • 5.8.2.2 CREATE TABLE AS SELECT
  • 5.8.3 Disabling the Mapping of Derived Objects
• 5.9 Using DDL String Substitution
• 5.10 How DDL is Evaluated for Processing
  • 5.10.1 How Extract Evaluates DDL
  • 5.10.2 How Replicat Evaluates DDL
• 5.11 Handling DDL Processing Errors
• 5.12 Viewing DDL Report Information
  • 5.12.1 Extract DDL Reporting
  • 5.12.2 Replicat DDL Reporting
  • 5.12.3 Statistics in the Process Reports
• 5.13 Tracing DDL Processing

6 Modifying Objects in the Oracle GoldenGate Configuration

• 6.1 Deleting an Extract Group
• 6.2 Adding a Table to an Existing Extract Group
• 6.3 Moving a Table to a New Extract Group
• 6.4 Modifying Columns of a Table

7 Uninstalling Oracle GoldenGate

• 7.1 Uninstalling Oracle GoldenGate from Linux or UNIX
• 7.2 Uninstalling Oracle GoldenGate from Windows (Non-cluster)
• 7.3 Uninstalling Oracle GoldenGate from Windows Cluster

A Oracle GoldenGate Installed Components

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