Go to main content
1/17
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Understanding Oracle GoldenGate for HP NonStop
1.1
Oracle GoldenGate Overview
1.1.1
Oracle GoldenGate Configuration
1.1.2
Oracle GoldenGate Features
1.2
Oracle GoldenGate Architecture
1.2.1
Oracle GoldenGate Components
1.3
Oracle GoldenGate Processing
1.3.1
Initial Data Synchronization
1.3.2
Capturing Data Changes from TMF Applications
1.3.3
Capturing Data Changes from Non-TMF applications
1.3.4
Using Extract for Data Distribution
1.3.5
Batch Processing
1.3.6
Capturing Directly from Files
1.3.7
Custom Event Processing
1.4
Oracle GoldenGate Commands
1.4.1
To Start GGSCI
2
Installing Oracle GoldenGate for HP NonStop
2.1
Installing Oracle GoldenGate
2.1.1
Downloading Oracle GoldenGate for HP NonStop
2.1.2
Installing Oracle GoldenGate for HP NonStop
2.2
Upgrading Oracle GoldenGate
2.2.1
Migrating from a Previous Release of Oracle GoldenGate:
2.3
Preparing your Production Environment
2.3.1
Sizing
2.3.2
CPU Requirements
2.3.3
Disk Space Requirements
2.3.4
Data Communications Requirements
2.4
Preparing the Source and Target
2.4.1
Downloading Source Data Definitions
2.4.2
Synchronizing Source and Target
3
Planning the Configuration
3.1
Planning Overview
3.2
Configuring TMF-Enabled Processing
3.2.1
Adding Columns to a Source Table
3.2.2
Ensuring All Audit is Processed
3.2.3
Keeping Necessary Audit Available for Extract
3.2.4
Minimizing Vulnerability to Outages
3.2.5
Configuring FUP RELOAD Activity
3.2.6
Data Compression
3.2.7
Configuring for Distributed Network Transactions
3.3
Configuring Non-TMF-Enabled Processing
3.3.1
Maintaining Data Integrity
3.3.2
Supported File Types and Operations
3.3.3
Authentication for Bound Programs
3.3.4
System Utilities That Update Databases
3.3.5
Private Memory and Stack Space
3.3.6
Impact on Existing Application Performance
3.4
Configuring Oracle Goldengate Global Operations
3.4.1
GLOBALS Parameter File
3.4.2
Changing the Default Location of AUDCFG
3.5
Configuring Replication
3.5.1
Replicating SQL Tables with System Keys
3.5.2
Replicating Primary Key Updates
3.5.3
Files and Tables Other Than Key-Sequenced
3.5.4
Load Balancing and Performance Issues
3.5.5
Potential Problems with Audit Compressed Files
3.5.6
Conflicts with Updating the Target
3.5.7
Many-to-One Replication
3.5.8
Bi-Directional Replication
3.5.9
Replicating Data to Non-TMF Enabled Databases
3.5.10
Replicating New SQL Columns
3.6
Configuring for Maximum Throughput
3.6.1
Extraction
3.6.2
TMF Extraction
3.6.3
Non-TMF Data Extraction
3.6.4
Replication
3.6.5
Latency Issues
3.6.6
Capacity Planning
3.7
Changing Default Component Names
3.8
Using Wildcards
3.9
Support for DDL and DDL2
3.10
Specifying Internet Protocol Addresses
4
Configuring Initial Data Synchronization
4.1
Initial Data Synchronization
4.1.1
Example Steps for Initial Data Load
4.1.2
Direct Load
4.1.3
Direct Bulk Load
4.1.4
Synchronizing Nonstop Databases Using Database Utilities Through TCP/IP
4.2
Controlling the IP Process for Replicat
4.3
Loading Oracle, Microsoft, or Sybase SQL Server Tables
4.3.1
Loading to Oracle or SQL Server
4.3.2
Initial Sync Parameter File Examples
4.4
Limiting the Enscribe Source Key Range for Initial Load
4.5
Restarting an Initial Load
4.6
Loading Initial Data from Windows and Unix
4.7
Integrating Source and Target Data
4.8
Distributing Extracted Data
4.9
Direct File Extraction
4.10
Batch Processing
4.10.1
One-Time Database Extraction
4.10.2
Trickle Batch Processing
5
Configuring Oracle GoldenGate Security
5.1
Using Encryption
5.1.1
How Data is Encrypted
5.1.2
Encrypting Trail or Extract Files
5.1.3
Encrypting a Database Password
5.1.4
Encrypting Data Sent Across TCP/IP
5.2
Generating Encryption Keys
5.3
Using Command Security
5.3.1
Securing the CMDSEC File
6
Configuring the Manager and Collector
6.1
Introducing Manager
6.2
Configuring and Starting Manager
6.2.1
Creating and Configuring the Manager Parameter File
6.2.2
Starting and Stopping Manager
6.3
Configuring and Running the Collector
6.3.1
Configuring Collector
6.3.2
The TCP/IP Port
6.3.3
Monitoring Collector
6.3.4
Security Considerations
6.4
Collecting Between Open Systems and NonStop
7
Configuring Change Synchronization
7.1
Introduction
7.2
Change Synchronization for TMF Applications
7.2.1
Configuring Extract
7.2.2
Configuring Trails
7.2.3
Configuring Replicat
7.3
Change Synchronization for Non-TMF Applications
7.3.1
Creating the LOGPARM File
7.3.2
Configuring Logger and GGSLIB
7.3.3
Starting Logger
7.3.4
Using Macros to Bind GGSLIB to a Non-TMF Application
7.3.5
Alternate Methods of Binding GGSLIB to an Application
7.3.6
Libraries for Native Applications
7.3.7
Activating Authorization of Bound Libraries
7.4
Working with Parameter Files
7.4.1
Creating a Parameter File
7.4.2
Storing Parameter Files
7.4.3
Viewing a Parameter File
7.4.4
Changing a Parameter File
7.4.5
Using OBEY and Macros in Parameters
7.4.6
Verifying a Parameter File
7.4.7
Substituting a Parameter
8
Configuring Custom Operations
8.1
User Exits
8.1.1
Record Formats for User Exits
8.1.2
Creating User Exits
8.1.3
Binding the User Exit
8.1.4
Debugging Replicat User Exits
8.1.5
Sample User Exits
8.2
Using Oracle GoldenGate Macros
8.2.1
Creating a Macro
8.2.2
Creating Macro Parameters
8.2.3
Changing the Macro Character
8.2.4
Running the Macro
8.2.5
Invoking a Macro Without Parameters
8.2.6
Sample Macros
8.2.7
Macro Libraries
8.3
Using OBEY Files
8.4
Creating High Pin Processes
8.4.1
Replicat
8.4.2
Extract and GGSCI
8.4.3
TACL DEFINE
9
Integrating Data
9.1
Selecting Records
9.1.1
Selecting Records with FILTER
9.1.2
Selecting Records with WHERE
9.2
Column Mapping
9.2.1
Mapping Between Different Database Structures
9.3
Field Conversion Functions
9.3.1
Function Arguments
9.3.2
Arithmetic Expressions
9.3.3
Null, Invalid, and Missing Columns and Fields
10
Managing and Monitoring
10.1
Managing Tasks
10.1.1
Getting Information on Tasks
10.1.2
Managing Tasks Using the Process Name
10.2
Managing Oracle GoldenGate Trails
10.2.1
Initial Allocation of Storage for Trails
10.2.2
Ongoing Trail Management
10.3
Managing Log Trails
10.4
Monitoring Processing
10.5
Error Handling
10.5.1
Error Handling Parameters
10.5.2
Handling Replicat Errors
10.5.3
TCP/IP Error Handling
10.5.4
Using Discard Files
10.5.5
Conflict Detection with SQLEXEC
10.6
Using the Event Log
10.7
Using the Process Report
10.7.1
Viewing Process Reports
10.7.2
Storing Process Reports
10.7.3
Managing Process Reports
10.7.4
Generating Run-time Statistics
10.8
Viewing Record Counts
10.9
The STATS Command
10.10
Collecting Events from Other Systems
10.10.1
Running EMSCLNT on Other Operating Systems
11
Using Oracle GoldenGate Utilities
11.1
Generating Data Definitions with DEFGEN
11.1.1
Configuring DEFGEN Interactively
11.1.2
Configuring DEFGEN in Batch
11.1.3
A Sample Definitions File
11.1.4
Running DEFGEN to Use Existing Definitions
11.2
Creating Target Database DDL
11.2.1
Configuring DDLGEN Interactively
11.2.2
Configuring DDLGEN in Batch
11.2.3
Addressing Enscribe DDL Peculiarities
11.2.4
Understanding the Template File
11.3
Oracle GoldenGate Rollback
11.3.1
Using Oracle GoldenGate Rollback
11.3.2
Reviewing Reversed Records
11.3.3
Correcting Unexpected Results
11.3.4
Invalid Conditions for Rollback
11.4
Using Syncfile
11.4.1
Implementing Syncfile
12
Collecting and Reporting Statistics
12.1
Running MEASFLS
12.2
MEASRPT Statistical Output
12.2.1
Running MEASRPT
A
Oracle GoldenGate Components
A.1
Programs, Utilities, Macros, and Libraries
A.2
Oracle GoldenGate Database
A.3
External Component Summary
A.4
Templates, Demonstrations, and Sample Code
B
Installing Event Detail Text
B.1
Standard Installation
B.2
Custom Installation
B.3
Customizing Error Messages
Scripting on this page enhances content navigation, but does not change the content in any way.