Course Code: orqgg
Duration: 14 hours
Prerequisites:

Free Oracle Accounts

Overview:

-

Course Outline:

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)