Table of Contents
- Title and Copyright Information
- Preface
-
1
Understanding Oracle GoldenGate for HP NonStop
- 1.1 Oracle GoldenGate Overview
- 1.2 Oracle GoldenGate Architecture
- 1.3 Oracle GoldenGate Processing
- 1.4 Oracle GoldenGate Commands
-
2
Planning the Configuration
- 2.1 Planning Overview
- 2.2 Configuring TMF-Enabled Processing
- 2.3 Configuring Non-TMF-Enabled Processing
- 2.4 Configuring Oracle Goldengate Global Operations
-
2.5
Configuring Replication
- 2.5.1 Replicating SQL Tables with System Keys
- 2.5.2 Replicating Primary Key Updates
- 2.5.3 Files and Tables Other Than Key-Sequenced
- 2.5.4 Load Balancing and Performance Issues
- 2.5.5 Potential Problems with Audit Compressed Files
- 2.5.6 Conflicts with Updating the Target
- 2.5.7 Many-to-One Replication
- 2.5.8 Bi-Directional Replication
- 2.5.9 Replicating Data to Non-TMF Enabled Databases
- 2.5.10 Replicating New SQL Columns
- 2.6 Configuring for Maximum Throughput
- 2.7 Changing Default Component Names
- 2.8 Using Wildcards
- 2.9 Support for DDL and DDL2
- 2.10 Specifying Internet Protocol Addresses
-
3
Configuring Initial Data Synchronization
- 3.1 Initial Data Synchronization
- 3.2 Controlling the IP Process for Replicat
- 3.3 Loading Oracle, Microsoft, or Sybase SQL Server Tables
- 3.4 Limiting the Enscribe Source Key Range for Initial Load
- 3.5 Restarting an Initial Load
- 3.6 Loading Initial Data from Windows and Unix
- 3.7 Integrating Source and Target Data
- 3.8 Distributing Extracted Data
- 3.9 Direct File Extraction
- 3.10 Batch Processing
- 4 Configuring Oracle GoldenGate Security
- 5 Configuring the Manager and Collector
-
6
Configuring Change Synchronization
- 6.1 Introduction
- 6.2 Change Synchronization for TMF Applications
- 6.3 Change Synchronization for Non-TMF Applications
- 6.4 Working with Parameter Files
-
7
Configuring Custom Operations
- 7.1 User Exits
- 7.2 Using Oracle GoldenGate Macros
- 7.3 Using OBEY Files
- 7.4 Creating High Pin Processes
-
8
Integrating Data
- 8.1 Selecting Records
-
8.2
Column Mapping
-
8.2.1
Mapping Between Different Database Structures
- 8.2.1.1 Data Type Conversions
- 8.2.1.2 Oracle GoldenGate User Tokens
- 8.2.1.3 Populating User Tokens in the Trail Header
- 8.2.1.4 Retrieving Values
- 8.2.1.5 Default Mapping
- 8.2.1.6 Mapping Examples
- 8.2.1.7 Legal Column Mapping
- 8.2.1.8 Dangerous Mapping if AUDITCOMPRESS Used on Source File
- 8.2.1.9 Using Constants, Taking Default Values.
-
8.2.1
Mapping Between Different Database Structures
- 8.3 Field Conversion Functions
- 8.4 Retrieving Before Values
- 8.5 Detokenizing Base24 (Classic) TLF/PTLF records
-
9
Managing and Monitoring
- 9.1 Managing Tasks
- 9.2 Managing Oracle GoldenGate Trails
- 9.3 Oracle GoldenGate Self Describing Trail Files
- 9.4 Managing Log Trails
- 9.5 Monitoring Processing
- 9.6 Error Handling
- 9.7 Using the Event Log
- 9.8 Using the Process Report
- 9.9 Viewing Record Counts
- 9.10 The STATS Command
- 9.11 Collecting Events from Other Systems
- 10 Using Oracle GoldenGate Utilities
- A Oracle Oracle GoldenGate Components
- B Installing Event Detail Text