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 the specific roles of processes: Extract, Pump, Replicat, Manager, and Collector.
- GoldenGate topologies, including one-way, bi-directional, cascaded, and hub-and-spoke configurations.
- An overview of the GoldenGate Microservices architecture, highlighting key distinctions from the classic architecture.
Installation, Configuration, and Environment Preparation
- System requirements, supported platforms, and the installation procedures for GoldenGate 19c.
- Configuring the Manager process, parameter files, and establishing deployment directories.
- Reviewing database prerequisites, necessary user privileges, and network considerations.
Change Data Capture and Data Movement
- Exploring capture methods such as Classic Extract, Integrated Extract, and Log-based CDC.
- Understanding trail file architecture, transport strategies, and checkpointing mechanisms.
- Setting up and configuring Extract, Data Pump, and Replicat processes.
Mapping, Transformations, and Conflict Handling
- Implementing data mapping and column transformations through parameter files and mapping rules.
- Addressing data type conversions and character set considerations.
- Developing conflict detection and resolution strategies for bidirectional replication scenarios.
GoldenGate Microservices and Administration UI
- Deploying and overseeing the GoldenGate Microservices Manager and Admin Server.
- Leveraging GoldenGate Studio and REST APIs for administrative tasks.
- Configuring security protocols, including SSL/TLS, user roles, and secure connections.
Monitoring, Troubleshooting, and Performance Tuning
- Tracking replication health, latency metrics, and performance counters.
- Analyzing common error patterns, interpreting logs, and executing recovery procedures.
- Optimizing Extract/Replicat parameters and managing resources to achieve high throughput.
Advanced Topics: High Availability, Cloud, and Migration
- Deploying high-availability solutions and zero-downtime migration strategies using GoldenGate.
- Integrating GoldenGate into cloud deployments and hybrid architectures (such as OCI, AWS, and Azure).
- Planning for GoldenGate upgrades, following patching best practices, and executing migration plans.
Hands-on Labs and Real-World Scenarios
- Lab Session: Installing GoldenGate 19c and configuring a one-way replication pipeline.
- Lab Session: Implementing data transformations and managing DML and DDL replication.
- Scenario Exercise: Diagnosing replication latency issues and performing failover/recovery steps.
Summary and Next Steps
Requirements
- A solid understanding of relational database concepts.
- Practical experience in administering Oracle Database or equivalent RDBMS systems.
- Proficiency in Linux/Unix or Windows server administration.
Target Audience
- Database Administrators (DBAs).
- Engineers specializing in data replication and integration.
- Platform and operations engineers responsible for maintaining 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
