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 configurations.
- Overview of the GoldenGate Microservices architecture and its primary distinctions from the classic architecture.
Installation, Configuration, and Environment Preparation
- System requirements, supported platforms, and installation procedures for GoldenGate 19c.
- Configuration of the Manager process, parameter files, and deployment directories.
- Database prerequisites, user privilege assignments, 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 utilizing parameter files and mapping rules.
- Addressing data type conversions and character set considerations.
- Conflict detection and resolution strategies for bi-directional replication.
GoldenGate Microservices and Administration UI
- Deployment and management of the GoldenGate Microservices Manager and Admin Server.
- Leveraging GoldenGate Studio and REST APIs for administrative tasks.
- Security configuration: SSL/TLS, user role definitions, and secure connection settings.
Monitoring, Troubleshooting, and Performance Tuning
- Monitoring replication health, latency metrics, and performance counters.
- Analysis of common error patterns, log examination, and recovery procedures.
- Tuning of Extract/Replicat parameters and resource management for high-throughput scenarios.
Advanced Topics: High Availability, Cloud, and Migration
- Implementation of high-availability and zero-downtime migration strategies using GoldenGate.
- GoldenGate integration in cloud deployments 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 configuring a one-way replication pipeline.
- Lab: Implementing transformations and managing DML and DDL replication.
- Scenario: Diagnosing replication latency and executing failover/recovery steps.
Summary and Next Steps
Requirements
- A solid grasp of relational database concepts.
- Practical experience in administering Oracle Database or similar RDBMS systems.
- Familiarity with Linux/Unix or Windows server administration tasks.
Target Audience
- Database Administrators (DBAs).
- Data replication and integration engineers.
- Platform and operations engineers overseeing high-availability systems.
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Greg was very patient and helpful