Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
Introduction to Oracle GoldenGate Architecture
- GoldenGate components and process roles: Extract, Pump, Replicat, Manager, and Collector.
- GoldenGate topologies: one-way, bi-directional, cascaded, and hub-and-spoke.
- Overview of the GoldenGate Microservices architecture and its key distinctions from the classic model.
Installation, Configuration, and Environment Preparation
- System requirements, supported platforms, and installation procedures for GoldenGate 19c.
- Configuring the Manager process, parameter files, and deployment directories.
- Database prerequisites, user privileges, and network considerations.
Change Data Capture and Data Movement
- Capture methods: Classic Extract, Integrated Extract, and Log-based CDC.
- Trail file architecture, transport strategies, and checkpointing mechanisms.
- Configuration of Extract, Data Pump, and Replicat processes.
Mapping, Transformations, and Conflict Handling
- Data mapping and column transformations via parameter files and mapping rules.
- Managing data type conversions and character set implications.
- Conflict detection and resolution strategies for bidirectional replication.
GoldenGate Microservices and Administration UI
- Deploying and managing the GoldenGate Microservices Manager and Admin Server.
- Utilizing GoldenGate Studio and REST APIs for administrative tasks.
- Security configuration: SSL/TLS, user roles, and secure connections.
Monitoring, Troubleshooting, and Performance Tuning
- Monitoring replication health, latency metrics, and performance counters.
- Analyzing common error patterns, logs, and recovery procedures.
- Tuning Extract/Replicat parameters and resource management for high throughput.
Advanced Topics: High Availability, Cloud, and Migration
- Implementing high-availability and zero-downtime migration strategies using GoldenGate.
- GoldenGate deployment in cloud environments and hybrid architectures (OCI, AWS, Azure).
- GoldenGate upgrades, patching best practices, and migration planning.
Hands-on Labs and Real-World Scenarios
- Lab: Installing GoldenGate 19c and setting up a one-way replication pipeline.
- Lab: Implementing transformations and handling DML and DDL replication.
- Scenario: Diagnosing replication latency and executing failover/recovery steps.
Summary and Next Steps
Requirements
- Foundational understanding of relational database concepts.
- Experience in administering Oracle Database or an equivalent RDBMS.
- Familiarity with Linux/Unix or Windows server administration.
Target Audience
- Database Administrators (DBAs).
- Data replication and integration engineers.
- Platform and operations engineers overseeing high-availability systems.
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
presentation skills, prompt answers to all questions
Oana - OPEN COURSE
Course - Oracle SQL LP - Fundamentals
it was structured very well both by days and by modules, easy to follow