Go to main content
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
Scripting on this page enhances content navigation, but does not change the content in any way.