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
Foundations of Oracle GoldenGate Architecture
- GoldenGate components and process functions: Extract, Pump, Replicat, Manager, and Collector.
- Architectural topologies: one-way, bidirectional, cascaded, and hub-and-spoke models.
- An overview of the GoldenGate Microservices architecture and its distinctions from the classic model.
Setup, Configuration, and Environment Setup
- System prerequisites, compatible platforms, and installation procedures for GoldenGate 19c.
- Setting up the Manager process, parameter files, and deployment directories.
- Database prerequisites, user permissions, and network-related considerations.
Capture of Change Data and Data Transfer
- Capture techniques: Classic Extract, Integrated Extract, and log-based CDC.
- Trail file structure, transport methods, and checkpoint mechanisms.
- Configuration of Extract, Data Pump, and Replicat processes.
Mapping, Transformation, and Conflict Management
- Data mapping and column-level transformations via parameter files and mapping rules.
- Addressing data type conversions and character set implications.
- Strategies for detecting and resolving conflicts in bidirectional replication.
GoldenGate Microservices and the Administrative Interface
- 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 establishment.
Monitoring, Diagnostics, and Performance Optimization
- Tracking replication health, latency indicators, and performance metrics.
- Identifying common error patterns, analyzing logs, and executing recovery steps.
- Optimizing Extract/Replicat parameters and managing resources for high throughput.
Advanced Concepts: High Availability, Cloud, and Migration
- Implementing high-availability and zero-downtime migration strategies using GoldenGate.
- Utilizing GoldenGate in cloud environments and hybrid architectures (OCI, AWS, Azure).
- Best practices for upgrading, patching, and planning migrations.
Practical Labs and Real-World Applications
- Lab: Installing GoldenGate 19c and setting up a one-way replication pipeline.
- Lab: Applying transformations and managing DML and DDL replication.
- Scenario: Diagnosing replication latency and performing failover or recovery actions.
Conclusion and Future Directions
Requirements
- A solid grasp of relational database principles.
- Practical experience managing Oracle Database or comparable RDBMS platforms.
- Proficiency in Linux/Unix or Windows server administration.
Target Audience
- Database Administrators (DBAs).
- Specialists in data replication and integration.
- 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
