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 models.
- Overview of the GoldenGate Microservices architecture and its key distinctions from the classic model.
Installation, Configuration, and Environment Setup
- System requirements, supported platforms, and the installation procedure for GoldenGate 19c.
- Configuring 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 Resolution
- Data mapping and column transformations via parameter files and mapping rules.
- Managing data type conversions and character set considerations.
- Strategies for detecting and resolving conflicts in bidirectional replication.
GoldenGate Microservices and Administration Interface
- 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 roles, and establishing secure connections.
Monitoring, Troubleshooting, and Performance Optimization
- Monitoring replication health, latency metrics, and performance counters.
- Analyzing common error patterns, logs, and executing recovery procedures.
- Tuning Extract/Replicat parameters and managing resources for high throughput.
Advanced Topics: High Availability, Cloud, and Migration
- Implementing high-availability and zero-downtime migration strategies using GoldenGate.
- GoldenGate in cloud deployments and hybrid architectures (OCI, AWS, Azure).
- Upgrading GoldenGate, 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 managing DML and DDL replication.
- Scenario: Diagnosing replication latency and performing failover/recovery operations.
Summary and Next Steps
Requirements
- Solid understanding of relational database concepts.
- Practical experience administering Oracle Database or other comparable RDBMS platforms.
- Familiarity with server administration on Linux/Unix or Windows environments.
Target Audience
- Database Administrators (DBAs)
- Engineers specializing in data replication and integration.
- Platform and operations engineers responsible for maintaining 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
