Course Outline
Introduction to Oracle GoldenGate Architecture
- Roles of key GoldenGate components and processes: Extract, Pump, Replicat, Manager, and Collector.
- Exploration of GoldenGate topologies, including one-way, bi-directional, cascaded, and hub-and-spoke models.
- Insights into the GoldenGate Microservices architecture and its distinctions from the classic structure.
Installation, Configuration, and Environment Setup
- System prerequisites, supported platforms, and deployment steps for GoldenGate 19c.
- Setting up the Manager process, parameter files, and deployment directories.
- Reviewing database requirements, user permissions, and network factors.
Change Data Capture and Data Transfer
- Capture techniques: Classic Extract, Integrated Extract, and Log-based CDC.
- Trail file structure, transport mechanisms, and checkpoint management.
- Configuration of Extract, Data Pump, and Replicat processes.
Mapping, Transformations, and Conflict Management
- Data mapping and column transformation via parameter files and mapping rules.
- Managing data type conversions and character set alignments.
- Strategies for detecting and resolving conflicts in bidirectional replication.
GoldenGate Microservices and Administrative Interface
- Deployment and management of the GoldenGate Microservices Manager and Admin Server.
- Utilizing GoldenGate Studio and REST APIs for administrative tasks.
- Security configuration, including SSL/TLS, user roles, and secure connections.
Monitoring, Troubleshooting, and Performance Optimization
- Tracking replication health, latency indicators, and performance metrics.
- Analyzing common error patterns, logs, and recovery protocols.
- Optimizing Extract/Replicat parameters and resource allocation 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 setups (OCI, AWS, Azure).
- Upgrading GoldenGate, adhering to patching best practices, and planning migrations.
Practical Labs and Real-World Applications
- Lab: Install GoldenGate 19c and establish a one-way replication pipeline.
- Lab: Apply transformations and manage DML and DDL replication.
- Scenario: Diagnose replication latency and perform failover/recovery actions.
Recap and Future Steps
Requirements
- A solid grasp of relational database principles.
- Practical experience in managing Oracle Database or similar RDBMS platforms.
- Proficiency in Linux/Unix or Windows server administration.
Target Audience
- Database Administrators (DBAs)
- Data replication and integration specialists.
- Platform and operations engineers 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
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
