Oracle GoldenGate Training in Marina Bay, Singapore

This course provides a comprehensive introduction and hands-on experience with Oracle GoldenGate, Oracle’s premier solution for real-time data replication, high availability, and data integration. Participants will learn how to configure, manage, and monitor GoldenGate to ensure continuous availability of data across heterogeneous environments. This course is ideal for database administrators, system architects, and IT professionals responsible for data movement and replication strategies.

Course Agenda:

Introduction and Basic Configuration

• Introduction to Oracle GoldenGate

• Use Cases: HA, DR, Migration, ETL Offloading

• GoldenGate Architecture and Components

• Installation and Initial Setup

• Configuring Manager, Extract, Data Pump, and Replicat Processes

• GoldenGate Parameter Files and Trail Files

Advanced Replication Concepts

• Change Data Capture Techniques

• Checkpoints, Transactions, and Commit Sequencing

• Bidirectional and Peer-to-Peer Replication

• Conflict Detection and Resolution

• Oracle GoldenGate for Heterogeneous Databases

Administration and Troubleshooting

• Monitoring GoldenGate Using GGSCI and Admin Tools

• Error Handling, Lag Monitoring, and Log Dumps

• Performance Tuning and Optimization

• Security: Encryption, Authentication, and Access Controls

• Backup and Recovery for GoldenGate

Hands-on Exercises