1. Oracle GoldenGate 11gR1 Introduction
Oracle GoldenGate Features and Functionality
Oracle Middleware for Business Intelligence
Oracle GoldenGate High Availability and Disaster Tolerance Solutions
Oracle GoldenGate Real-time Data Integration Solutions
2. Oracle GoldenGate: Overview
Oracle GoldenGate Functionality and Components
Supported Databases and Platforms
Oracle GoldenGate Product Line
3. Oracle GoldenGate Architecture
Oracle GoldenGate Process Groups
Change Capture and Delivery (with and without a Data Pump)
Initial Data Load
Contrasting Batch and Online Operation
Oracle GoldenGate Checkpointing
Commit Sequence Number (CSN)
Oracle GoldenGate Files
4. Installing Oracle GoldenGate
Installing Oracle GoldenGate on Linux
Preparing the Operating System
Running GoldenGate Commands from the GGSCI Prompt
Using Obey Files and OS Shell
Get Help Information on GGSCI Commands
Types of GGSCI Commands Available
5. Configuration Overview and Preparing the Environment
High-Level Configuration Steps
Configuring and Starting the Manager Process
Generating a Source Definitions File
Preparing a Source Database for Transaction Capture
6. Configuring Change Capture
Extract Process
Marking Tables with TRANDATA
Configuring Extract to Access Logs on Oracle ASM
Configuring and Starting an Extract Process
Adding Local and Remote Trails
Configuring and Starting an Extract Data Pump
7. Configuring Initial Load
Oracle GoldenGate Initial Load Methods
Variety of Database-Specific Methods
Advantages of Oracle GoldenGate Methods
Configuring an Initial Load Using Oracle GoldenGate