1/15

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Information
• Conventions

1 Understanding Oracle GoldenGate for HP NonStop

• Oracle GoldenGate Overview
  • Oracle GoldenGate Configuration
  • Oracle GoldenGate Features
• Oracle GoldenGate Architecture
  • Oracle GoldenGate Components
    • Extract
    • Logger
    • Collector
    • Trails
    • Replicat
    • Manager
    • Syncfile
    • Processing Groups
    • Checkpoints
    • Parameters
    • Reader
    • Coordinator
• Oracle GoldenGate Processing
  • Initial Data Synchronization
    • File to Replicat
    • Direct Load
    • Direct Bulk Load
  • Capturing Data Changes from TMF Applications
    • Capturing Changes for Distributed Network Transactions
  • Capturing Data Changes from Non-TMF applications
  • Using Extract for Data Distribution
  • Batch Processing
  • Capturing Directly from Files
  • Custom Event Processing
• Oracle GoldenGate Commands
  • To Start GGSCI

2 Planning the Configuration

• Planning Overview
• Configuring TMF-Enabled Processing
  • Adding Columns to a Source Table
  • Ensuring All Audit is Processed
  • Keeping Necessary Audit Available for Extract
    • Ensuring TMF Cannot Purge Audit
    • Copying the Audit to an Alternative Location
    • Using Tape Dumps as an Alternative Location
  • Minimizing Vulnerability to Outages
  • Configuring FUP RELOAD Activity
  • Data Compression
    • Compressed Enscribe Records
    • Compressed SQL Records
    • DCOMPRESS File Attribute Not Supported
    • AUDITCOMPRESS File Attribute Considerations
  • Configuring for Distributed Network Transactions
    • Re-configuring TMF
• Configuring Non-TMF-Enabled Processing
  • Maintaining Data Integrity
  • Supported File Types and Operations
  • Authentication for Bound Programs
  • System Utilities That Update Databases
  • Private Memory and Stack Space
  • Impact on Existing Application Performance
• Configuring Oracle Goldengate Global Operations
  • GLOBALS Parameter File
  • Changing the Default Location of AUDCFG
• Configuring Replication
  • Replicating SQL Tables with System Keys
  • Replicating Primary Key Updates
    • Missing Row Errors
    • Non-Audited Target
    • Compressed Updates to Enscribe Targets
  • Files and Tables Other Than Key-Sequenced
  • Load Balancing and Performance Issues
  • Potential Problems with Audit Compressed Files
  • Conflicts with Updating the Target
  • Many-to-One Replication
  • Bi-Directional Replication
  • Replicating Data to Non-TMF Enabled Databases
  • Replicating New SQL Columns
• Configuring for Maximum Throughput
  • Extraction
  • TMF Extraction
  • Non-TMF Data Extraction
  • Replication
  • Latency Issues
  • Capacity Planning
    • TMF Data Extraction
    • Non-TMF Data Extraction
    • Data Transfer into Oracle GoldenGate Trails
    • Replicat Throughput
• Changing Default Component Names
• Using Wildcards
• Support for DDL and DDL2
• Specifying Internet Protocol Addresses

3 Configuring Initial Data Synchronization

• Initial Data Synchronization
  • Example Steps for Initial Data Load
    • Configure and Run Extract
    • Perform Initial Load Using the File to Replicat Method
    • Configure and Run Replicat
  • Direct Load
    • To run direct load:
    • Using Wildcards
  • Direct Bulk Load
    • To run direct bulk load:
  • Synchronizing Nonstop Databases Using Database Utilities Through TCP/IP
• Controlling the IP Process for Replicat
• Loading Oracle, Microsoft, or Sybase SQL Server Tables
  • Loading to Oracle or SQL Server
  • Initial Sync Parameter File Examples
    • Sample NonStop to Oracle Parameter Files
    • Sample SQL Server Parameter Files
• Limiting the Enscribe Source Key Range for Initial Load
• Restarting an Initial Load
• Loading Initial Data from Windows and Unix
• Integrating Source and Target Data
• Distributing Extracted Data
• Direct File Extraction
• Batch Processing
  • One-Time Database Extraction
  • Trickle Batch Processing
    • Determining the Next File
    • When the Next File is Processed

4 Configuring Oracle GoldenGate Security

• Using Encryption
  • How Data is Encrypted
  • Encrypting Trail or Extract Files
  • Encrypting a Database Password
  • Encrypting Data Sent Across TCP/IP
• Generating Encryption Keys
• Using Command Security
  • Securing the CMDSEC File

5 Configuring the Manager and Collector

• Introducing Manager
• Configuring and Starting Manager
  • Creating and Configuring the Manager Parameter File
    • A Sample Manager Parameter File
  • Starting and Stopping Manager
• Configuring and Running the Collector
  • Maintaining Ports for Remote Connections through Firewalls
  • Configuring Collector
    • Configuration Examples
  • The TCP/IP Port
    • Dynamic Method
    • Explicit Method
  • Monitoring Collector
  • Security Considerations
• Collecting Between Open Systems and NonStop

6 Configuring Change Synchronization

• Introduction
• Change Synchronization for TMF Applications
  • Configuring Extract
  • Configuring Trails
  • Configuring Replicat
• Change Synchronization for Non-TMF Applications
  • Creating the LOGPARM File
    • Sample LOGPARM File
  • Configuring Logger and GGSLIB
  • Starting Logger
  • Using Macros to Bind GGSLIB to a Non-TMF Application
    • Building GGSLIB
    • Private Memory and Stack Space
  • Alternate Methods of Binding GGSLIB to an Application
    • Using the ?Search Directive
    • Non-Native Environments
    • Native Mode Itanium Systems
  • Libraries for Native Applications
    • Running NLDLIB
    • Removing a Library
  • Activating Authorization of Bound Libraries
    • Managing the Authorization Event
    • Adding and Verifying the Authorization Event
    • Using Different PARAM-TEXT Options
    • Getting the Current Status of the Authorization Event
• Working with Parameter Files
  • Creating a Parameter File
  • Storing Parameter Files
  • Viewing a Parameter File
  • Changing a Parameter File
  • Using OBEY and Macros in Parameters
  • Verifying a Parameter File
  • Substituting a Parameter

7 Configuring Custom Operations

• User Exits
  • Record Formats for User Exits
  • Creating User Exits
  • Binding the User Exit
    • Binding User Exits in Native Mode
  • Debugging Replicat User Exits
  • Sample User Exits
• Using Oracle GoldenGate Macros
  • Creating a Macro
  • Creating Macro Parameters
  • Changing the Macro Character
  • Running the Macro
  • Invoking a Macro Without Parameters
  • Sample Macros
    • Implementing Multiple Uses of a Statement
    • Consolidating Multiple Commands
  • Macro Libraries
    • Sample Macro Libraries
    • Suppressing Report File Listing
    • Tracing Parameter Expansion
• Using OBEY Files
• Creating High Pin Processes
  • Replicat
  • Extract and GGSCI
  • TACL DEFINE

8 Integrating Data

• Selecting Records
  • Selecting Records with FILTER
  • Selecting Records with WHERE
    • Comparing Fields
    • Compressed Update Considerations
    • Testing for NULL Values
• Column Mapping
  • Mapping Between Different Database Structures
    • Data Type Conversions
    • Oracle GoldenGate User Tokens
    • Populating User Tokens in the Trail Header
    • Retrieving Values
    • Default Mapping
    • Mapping Examples
    • Legal Column Mapping
    • Dangerous Mapping if AUDITCOMPRESS Used on Source File
    • Using Constants, Taking Default Values.
• Field Conversion Functions
  • Function Arguments
  • Arithmetic Expressions
  • Null, Invalid, and Missing Columns and Fields
    • Overriding Exceptional Conditions
• Retrieving Before Values

9 Managing and Monitoring

• Managing Tasks
  • Getting Information on Tasks
  • Managing Tasks Using the Process Name
• Managing Oracle GoldenGate Trails
  • Initial Allocation of Storage for Trails
    • To estimate the required trail space
  • Ongoing Trail Management
    • Setting the Size of the Trail
    • Setting the PURGEOLDEXTRACTS rules
    • Manager Purge Trail Processing
    • Recommendations for Managing Trail Purges
• Managing Log Trails
• Monitoring Processing
• Error Handling
  • Error Handling Parameters
  • Handling Replicat Errors
  • TCP/IP Error Handling
    • Altering TCP/IP Error Handling Parameters
  • Using Discard Files
    • Using the Discard File
    • Using the SQL Formatted Discard File
  • Conflict Detection with SQLEXEC
    • A SQLEXEC Example
• Using the Event Log
• Using the Process Report
  • Viewing Process Reports
  • Storing Process Reports
  • Managing Process Reports
  • Generating Run-time Statistics
• Viewing Record Counts
• The STATS Command
• Collecting Events from Other Systems
  • Running EMSCLNT on Other Operating Systems

10 Using Oracle GoldenGate Utilities

• Generating Data Definitions with DEFGEN
  • Configuring DEFGEN Interactively
  • Configuring DEFGEN in Batch
  • A Sample Definitions File
  • Running DEFGEN to Use Existing Definitions
• Creating Target Database DDL
  • Configuring DDLGEN Interactively
  • Configuring DDLGEN in Batch
  • Addressing Enscribe DDL Peculiarities
  • Understanding the Template File
    • Sample Template File
    • Sample NonStop SQL Table Definition
    • Modifying the Sample Template File
    • Generating the Sample Definition
• Oracle GoldenGate Rollback
  • Using Oracle GoldenGate Rollback
  • Reviewing Reversed Records
  • Correcting Unexpected Results
  • Invalid Conditions for Rollback
• Using Syncfile
  • Implementing Syncfile

A Oracle Oracle GoldenGate Components

• Programs, Utilities, Macros, and Libraries
• Oracle GoldenGate Database
• External Component Summary
• Templates, Demonstrations, and Sample Code

B Installing Event Detail Text

• Standard Installation
• Custom Installation
• Customizing Error Messages