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.
Course Outline
Introduction to Oracle GoldenGate Architecture
- GoldenGate components and their roles: Extract, Pump, Replicat, Manager, and Collector.
- GoldenGate topologies: 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 prerequisites, supported platforms, and the installation process for GoldenGate 19c.
- Setting up the Manager process, parameter files, and deployment directories.
- Database requirements, user privilege setup, and network considerations.
Change Data Capture and Data Movement
- Capture techniques: Classic Extract, Integrated Extract, and Log-based CDC.
- Trail file structure, transport methods, and checkpoint management.
- Configuration of Extract, Data Pump, and Replicat processes.
Mapping, Transformations, and Conflict Handling
- Data mapping and column-level transformations via parameter files and mapping rules.
- Managing data type conversions and character set nuances.
- Strategies for detecting and resolving conflicts in bidirectional replication.
GoldenGate Microservices and Administration UI
- Deployment and management of the GoldenGate Microservices Manager and Admin Server.
- Utilizing GoldenGate Studio and REST APIs for administrative tasks.
- Security configuration: SSL/TLS, user role definitions, and secure connections.
Monitoring, Troubleshooting, and Performance Tuning
- Tracking replication health, latency indicators, and performance metrics.
- Identifying common error patterns, analyzing logs, and executing recovery steps.
- Optimizing Extract/Replicat parameters and resource allocation for high throughput.
Advanced Topics: High Availability, Cloud, and Migration
- Strategies for high availability and zero-downtime migrations using GoldenGate.
- Implementing GoldenGate in cloud and hybrid architectures (OCI, AWS, Azure).
- GoldenGate upgrade procedures, patching best practices, and migration planning.
Hands-on Labs and Real-World Scenarios
- Lab: Install GoldenGate 19c and set up a one-way replication pipeline.
- Lab: Apply transformations and manage DML and DDL replication.
- Scenario: Diagnose replication latency and perform failover/recovery actions.
Summary and Next Steps
Requirements
- A solid grasp of relational database fundamentals.
- Practical experience managing Oracle Database or similar RDBMS platforms.
- Proficiency with Linux/Unix or Windows server administration.
Target Audience
- Database Administrators (DBAs).
- Data replication and integration specialists.
- Platform and operations engineers tasked with maintaining high-availability systems.
21 Hours
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
