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 their roles: Extract, Pump, Replicat, Manager, and Collector.
- Architectural topologies: one-way, bi-directional, cascaded, and hub-and-spoke configurations.
- An overview of the GoldenGate Microservices architecture and its distinctions from the classic architecture.
Installation, Configuration, and Environment Setup
- System requirements, supported platforms, and installation procedures for GoldenGate 19c.
- Setting up the Manager process, parameter files, and deployment directories.
- Database prerequisites, user privilege assignments, and network considerations.
Change Data Capture and Data Movement
- Capture methodologies: Classic Extract, Integrated Extract, and Log-based CDC.
- Trail file architecture, transport strategies, and checkpointing mechanisms.
- Configuring Extract, Data Pump, and Replicat processes effectively.
Mapping, Transformations, and Conflict Resolution
- Data mapping and column transformations via parameter files and mapping rules.
- Managing data type conversions and character set implications.
- Strategies for detecting and resolving conflicts in bidirectional replication.
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 Optimization
- Tracking replication health, latency metrics, and performance counters.
- Analyzing common error patterns, logs, and recovery procedures.
- Optimizing Extract/Replicat parameters and managing resources for high throughput.
Advanced Topics: High Availability, Cloud, and Migration
- Establishing high-availability and zero-downtime migration strategies using GoldenGate.
- Deploying GoldenGate in cloud and hybrid architectures (OCI, AWS, Azure).
- Upgrading GoldenGate, adhering to patching best practices, and planning migrations.
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
- A solid grasp of relational database concepts.
- Hands-on experience administering Oracle Database or equivalent RDBMS platforms.
- Proficiency in Linux/Unix or Windows server administration.
Audience
- Database administrators (DBAs).
- Data replication and integration engineers.
- Platform and operations engineers responsible for 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
