Oracle Golden Gate Architecture
- Two Oracle GoldenGate Architectures
- Classic Architecture
- Microservices Architecture
- Extracts
- Initial Loads
- Checkpoints
- Interaction between Oracle GoldenGate and Oracle RDBMS
Installing Golden Gate
- System Requirements
- Performing Installation
- Configuring Environment Variables
- Using GGSCI - Command Interface
- Running from OS Shell
- Use Obey Files to Automate Tasks
Preparing Environment and Configuring Integrated Extract
- Configuration Overview
- Preparing the Environment
- Enabling Oracle GoldenGate in the Database
- Enabling Supplemental Logging
- Defining Roles and Permissions
- Starting the Manager
- Configuring Data Capture
Configuring Intial Load
- Initial Load Overview
- Configuring Initial Load
- Setting up the Initial Load by Using the File to Replicat Method
- Setting up the Initial Data Load by Using the Direct Load Method
Configuring Change Delivery
- Replicat Overview
- Configuring Replicat Tasks
- Adding Checkpoints
- Using Checkpoints
- Initial Load: Avoiding Collisions with Initial Load
- Initial Load: Handling Collisions with Initial Load
- Troubleshooting: GGSCI Process Information
- Troubleshooting: Report Files and Logfiles
Managing Extract Trails and Files
- Trail Format: Local and Remote
- Trail Format: Cleanup
- Trail Format: Record Header Area
- Trail Format: Record Data Area
- Alternative Trail Formats: Logical Change Records (LCRs)
- logdump: Opening, Viewing, and Filtering
Oracle Golden Gate Parameters
- GLOBALS
- Manager
- Source Manager Parameters
- Target Manager Parameters
- Extract
- Extract Parameters on the Source Database
- Replicat
- Options Common to Both Replicat and Extract
Data Selection and Filtering
- Mapping and Manipulation
- Definition Files
- Data Selection
- Where
- Filter
- Mapping
- SQLEXE
Golden Gate BiDirectional
- Pictorial View
- Configurations
- Data Looping
- Resolving Conflicts
- Effect of Oracle Sequences