Oracle GoldenGate

Module 1: Introduction to Oracle GoldenGate

• Overview of Oracle GoldenGate (OGG)
• GoldenGate use cases: Real-time replication, migration, zero-downtime upgrades
• GoldenGate architecture: Extract, Data Pump, Replicat
• GoldenGate 21c and Microservices architecture
• GoldenGate implementation methodology

Module 2: GoldenGate Architecture

• Classic vs. Microservices architecture
• Extract process types: Classic, integrated, initial load
• Trail files and data storage
• Data Pump for network transfer
• Replicat: Classic, integrated, parallel

Module 3: GoldenGate Installation and Setup

• Prerequisites: DB configuration, logging
• GoldenGate software installation
• Service Manager and Admin Server setup
• Database user and privilege setup
• Supplemental logging configuration

Module 4: Extract Configuration

• Classic extract setup
• Integrated extract (LogMiner-based)
• Table and schema-level capture
• DDL capture configuration
• Extract parameter file design

Module 5: Replicat Configuration

• Replicat parameter file
• Integrated replicat configuration
• Parallel replicat for throughput
• Apply conflicts detection and resolution
• Replicat error handling

Module 6: GoldenGate for Oracle-to-Oracle

• Homogeneous Oracle replication
• Active-active bidirectional replication
• Conflict detection and resolution (CDR)
• Cascading replication
• Selective replication filters

Module 7: Heterogeneous Replication

• Oracle to SQL Server replication
• Oracle to MySQL replication
• Oracle to Kafka/Big Data
• Non-Oracle source to Oracle target
• Data type mapping and transformation

Module 8: GoldenGate Data Transformations

• Column mapping and conversion
• COLMAP for field-level mapping
• Token-based transformation
• Custom transformation with user exits
• Filtering rows with WHERE clause

Module 9: GoldenGate Monitoring and Administration

• GoldenGate Manager and monitoring
• Performance metrics dashboard
• Lag monitoring and tuning
• Critical errors and recovery
• GoldenGate Admin Client (GGSCI)

Module 10: GoldenGate for Zero Downtime Migration

• Pre-migration synchronization
• Online schema changes with GoldenGate
• Cutover strategy and verification
• Post-migration validation
• GoldenGate for EBS upgrade migration

Module 11: GoldenGate on Oracle Cloud

• GoldenGate Cloud Service (GGCS) on OCI
• GoldenGate for Big Data on OCI
• GoldenGate Microservices on OCI
• Cloud-to-cloud and hybrid replication
• GoldenGate 23ai features

Module 12: Real-Time Projects and Case Studies

• Real-time data replication for reporting
• Zero-downtime database migration
• End-to-end GoldenGate implementation
• Certification and interview preparation

Experience in the Industry Gain knowledge from experts with hands-on Oracle GoldenGate project experience in real-time replication and zero-downtime migration.

Backgrounds at the Top Prominent corporations such as HCL, TCS, Accenture, and Oracle Consulting employ our GoldenGate trainers.

Clear & Effective Teaching Excellent communication and real-world examples simplify complex replication architecture and conflict resolution.

Hands-On Learning Focus Students apply skills using live Oracle GoldenGate environments with real replication and migration case studies.

Up-to-Date Knowledge Trainers stay current with GoldenGate Microservices, OCI cloud replication, and latest data integration best practices.