Oracle GoldenGate training
Real-time data replication with GoldenGate 26ai, taught the way it actually runs in production. Configure Extract, Pump and Replicat from scratch, build uni- and bi-directional flows, handle conflicts and Automatic Schema Evolution, and keep replication healthy when lag hits.
- Weekend or weekday batches · morning or evening slots · check upcoming schedule →
- Hands-on labs on a live GoldenGate 26ai estate — Architecture, Installation, Extract / Pump / Replicat, Integrated Capture, Uni- & Bi-Directional Replication, Conflict Handling, Automatic Schema Evolution & Lag Tuning
- Certificate + lifetime recordings in your student portal
What this course is about
Oracle GoldenGate is the standard for real-time, log-based data replication — moving committed changes between databases with minimal latency and almost no impact on the source. It powers zero-downtime migrations, active-active databases across regions, reporting offloads and continuous data integration.
This is a live, instructor-led course built around a working GoldenGate 26ai environment. You won't just watch slides — you'll install GoldenGate, register an integrated Extract against the redo stream, ship trail files through a Pump, apply them with Replicat, and then deliberately break things so you learn how to read errors, resolve conflicts and recover. Every session is taught by our senior Oracle DBA instructors, who have run GoldenGate on real production systems for over a decade.
Course syllabus
1GoldenGate architecture & components1 session · 2 hrs
- How log-based replication works end to end
- Manager, Extract, Pump and Replicat roles
- Trail files and the checkpoint mechanism
- Classic vs integrated capture and apply
- Where GoldenGate fits in a real topology
- GoldenGate 26ai and the Microservices model
2Installation & configuration1 session · 2 hrs
- Install GoldenGate 26ai on Oracle Linux
- Prepare the source — archivelog & force logging
- Enable supplemental logging
- Create the GoldenGate user & privileges
- Configure the Manager / Service Manager
- Working in GGSCI and the Admin Client
3Extract / Pump / Replicat1 session · 2 hrs
- Register and start an Extract
- Add a data-pump Extract
- Ship trail files to the target
- Create and start a Replicat
- Read status, stats and lag output
- Parameter files and mapping basics
4Integrated Extract1 session · 2 hrs
- Integrated capture against the logmining server
- Downstream vs local integrated capture
- Integrated vs parallel Replicat
- Per-PDB capture with multitenant
- Configuring and tuning the apply
- When to choose integrated over classic
5Unidirectional replication1 session · 2 hrs
- One-way flows for reporting and offload
- Initial load & instantiation by SCN
- DML and DDL replication
- Map, filter and transform objects
- Column mapping & data-type handling
- Verifying source/target consistency
6Bi-directional replication & conflict handling1 session · 2 hrs
- Design an active-active configuration
- Loop detection & the EXCLUDETAG pattern
- Stop changes echoing back to the source
- Conflict Detection & Resolution (CDR) rules
- Resolution strategy — timestamp / source wins
- Exceptions and discard handling
7Automatic Schema Evolution & Per-PDB capture1 session · 2 hrs
- Automatic Schema Evolution (new in 26ai)
- Flowing structural changes without re-instantiation
- Per-PDB capture with Data Guard
- Multitenant replication considerations
- DDL replication options & filters
- Upgrade-friendly replication patterns
8Monitoring, Unified Web UI & lag troubleshooting1 session · 2 hrs
- The Unified Web UI for monitoring
- Read lag and checkpoint statistics
- Work through report and discard files
- Recover an abended Extract or Replicat
- Handle long transactions
- Tune for throughput when the target falls behind
What you'll be able to do
- Install and configure GoldenGate 26ai on source and target
- Build a working Extract → Pump → Replicat pipeline
- Use integrated Extract and parallel Replicat
- Perform a clean initial load and instantiation by SCN
- Design unidirectional and bidirectional topologies
- Configure conflict detection and resolution rules
- Use Automatic Schema Evolution and Per-PDB capture
- Diagnose and clear replication lag from the Unified Web UI
Who it's for
This course is for working Oracle DBAs and developers who need to add real-time replication to their skill set — anyone tasked with migrations, active-active databases, reporting offloads or data integration. You'll get the most out of it if you're already comfortable with core Oracle administration (instances, redo, archivelog). No prior GoldenGate experience is required; we start from installation.
Program benefits
- Live instructor-ledLive sessions taught by our senior Oracle DBA instructors, not recordings
- Session recordingsEvery session saved to your student portal
- Module assignmentsHands-on tasks after each module to lock in skills
- Session documentationDetailed notes provided for every session
- WhatsApp supportFast doubt-clearing help between sessions
- Software & patchesEverything you need for hands-on practice
- Interview prepCurated Q&A to get you interview-ready
- Completion certificateAwarded when you finish the course
What learners say
Setting up integrated Extract always confused me from the docs. Watching the instructor register it live and then break it on purpose finally made it click. I migrated a client database with zero downtime a month later.
SRThe bi-directional and conflict resolution module was worth the fee on its own. Loop detection and CDR were always a mystery to me — now I run an active-active setup in production and actually understand it.
OFHands-on from session one. By the end I could read lag stats, recover an abended Replicat and use the new Unified Web UI without panicking. The 26ai Automatic Schema Evolution part was a real eye-opener.
AKFrequently asked questions
Do I need GoldenGate installed before the course?
Which version of GoldenGate is covered?
Are the live sessions recorded?
When do batches run?
How do I pay?
Add real-time replication to your DBA toolkit
Join the next live GoldenGate batch and learn replication the production way — Extract to Replicat, integrated capture, conflicts and all.