Golden Gate Bespoke Certificate for Mihaela Arcip
Day 1:
Introduction to Oracle GoldenGate (OGG) and Oracle GoldenGate for Big Data: features and architecture
Installation and initial configuration of OGG
Configuring data replication processes (using OGG Classic Architecture): data mapping, data filtering, data
transformation, unidirectional replication, initial loading
Managing OGG processes: starting, stopping, resynchronizing, status verification
Day 2:
Advanced data processing: WHERE/FILTER clauses, using predefined data transformation functions, using
SQLEXEC, macros, tokens, environment variables, bidirectional replication, conflict detection and resolution
Monitoring OGG: GGSCI commands, process monitoring, lag monitoring, reporting, log files
Troubleshooting: SQL tracing, operation tracing, Trace File debugging using LogDump
Overview of performance tuning techniques: parallel processing, network compression, disk I/O
Overview of HA/DR techniques: single server (autostart, autorestart), clusters (shared filesystem)