Table of Contents
- Title and Copyright Information
- Preface
- Part I What is Oracle GoldenGate for Heterogeneous Databases?
-
Part II Using Oracle GoldenGate for DB2
LUW
- 1 Understanding What's Supported for DB2 LUW
- 2 Preparing the System for Oracle GoldenGate
- 3 Configuring Oracle GoldenGate for DB2 LUW
-
Part III Using Oracle GoldenGate for DB2
for i
-
4
Understanding What's Supported for DB2 for
i
- Supported DB2 for i Data Types
- Non-Supported DB2 for i Data Types
- Supported Objects and Operations for DB2 for i
- Non-Supported Objects and Operations for DB2 for i
- Oracle GoldenGate Parameters Not Supported for DB2 for i
- Supported Object Naming Conventions
- System Schemas for DB2 for i
- Supported Character Sets
-
5
Preparing the System for Oracle GoldenGate
- Preparing the Journals for Data Capture by Extract
- Specifying Object Names
- Preparing Tables for Processing
- Adjusting the System Clock
- Configuring the ODBC Driver
-
6
Configuring Oracle GoldenGate for DB2 for i
- What to Expect from this Procedure
- Getting Started with Oracle GoldenGate
- Creating the Oracle GoldenGate Instance
- Creating a GLOBALS File
- Creating a Data Definitions File
- Encrypting the Extract and Replicat Passwords
- Configuring Extract for Change Capture from DB2 for i
- Configuring Replicat for Change Delivery to DB2 for i
- Next Steps in the Deployment
- When to Start Replicating Transactional Changes
- Testing Your Configuration
-
7
Instantiating and Starting Oracle GoldenGate Replication
- About the Instantiation Process
- Overview of Basic Oracle GoldenGate Instantiation Steps
- Satisfying Prerequisites for Instantiation
- Making the Instantiation Procedure More Efficient
- Configuring the Initial Load
- Adding Change-Capture and Change-Delivery processes
- Performing the Target Instantiation
- Monitoring Processing after the Instantiation
- Backing up Your Oracle GoldenGate Environment
- Positioning Extract After Startup
- 8 Using Remote Journal
-
4
Understanding What's Supported for DB2 for
i
-
Part IV Using Oracle GoldenGate for DB2
for z/OS
- 9 Understanding What's Supported for DB2 for z/OS
- 10 Preparing the DB2 for z/OS Database for Oracle GoldenGate
- 11 Preparing the DB2 for z/OS Transaction Logs for Oracle GoldenGate
-
Part V Using Oracle GoldenGate for
MySQL
- 12 Understanding What's Supported for MySQL
-
13
Preparing and Configuring the System for Oracle GoldenGate
- Database User for Oracle GoldenGate Processes for MySQL
- Ensuring Data Availability
- Setting Logging Parameters
- Adding Host Names
- Setting the Session Character Set
- Preparing Tables for Processing
- Changing the Log-Bin Location
- Configuring Bi-Directional Replication
- Configuring MySQL for Remote Capture
- Configuring a Two-way SSL Connection in MySQL Capture and Delivery
- Capturing using a MySQL Replication Slave
- Other Oracle GoldenGate Parameters for MySQL
- Positioning Extract to a Specific Start Point
- 14 Using DDL Replication
-
Part VI Using Oracle GoldenGate for PostgreSQL
- 15 Understanding What's Supported for PostgreSQL
- 16 Preparing the Database for Oracle GoldenGate
- 17 Configuring Extract
- 18 Configuring Replicat
- 19 Additional Considerations
-
Part VII Using Oracle GoldenGate for SQL
Server
- 20 Understanding What's Supported for SQL Server
- 21 Preparing the System for Oracle GoldenGate
- 22 Preparing the Database for Oracle GoldenGate — CDC Capture
- 23 Requirements Summary for Capture and Delivery of Databases in an Always On Availability Group
- 24 CDC Capture Method Operational Considerations
-
Part VIII Using Oracle GoldenGate with Sybase
- 25 Understanding What's Supported for Sybase
- 26 Preparing the System for Oracle GoldenGate
-
Part IX Using Oracle GoldenGate for
Teradata
-
27
Understanding What's Supported for Teradata
-
Supported Teradata Data Types
- Limitations of Support for Numeric Data Types
- Limitations of Support for Single-byte Character Data Types
- Conditions and Limitations of Support for Multi-byte Character Data
- Limitations of Support for Binary Data Types
- Limitations of Support for Large Object Data Types
- Limitations of Support for Date Data Types
- Limitations of Support for IDENTITY Data Types
- Supported Objects and Operations for Teradata
- Non-Supported Operations for Teradata
-
Supported Teradata Data Types
- 28 Preparing the System for Oracle GoldenGate
- 29 Configuring Oracle GoldenGate
- 30 Common Maintenance Tasks
-
27
Understanding What's Supported for Teradata
- Part X Using Oracle GoldenGate for Oracle TimesTen