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
- Core components and process roles: Extract, Pump, Replicat, Manager, and Collector.
- GoldenGate topologies: one-way, bi-directional, cascaded, and hub-and-spoke configurations.
- Overview of the GoldenGate Microservices architecture and its key distinctions from the classic architecture.
Installation, Configuration, and Environment Setup
- System requirements, supported platforms, and installation procedures for GoldenGate 19c.
- Configuring the Manager process, parameter files, and deployment directories.
- Establishing database prerequisites, user privileges, 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.
- Configuring Extract, Data Pump, and Replicat processes for efficient data flow.
Mapping, Transformations, and Conflict Handling
- Data mapping and column transformations utilizing parameter files and mapping rules.
- Managing data type conversions and character set considerations.
- Conflict detection and resolution strategies for bidirectional replication scenarios.
GoldenGate Microservices and Administration UI
- Deployment and management of the GoldenGate Microservices Manager and Admin Server.
- Leveraging GoldenGate Studio and REST APIs for streamlined administration.
- Security configuration: SSL/TLS, user roles, and secure connection protocols.
Monitoring, Troubleshooting, and Performance Tuning
- Monitoring replication health, latency metrics, and performance counters.
- Analyzing common error patterns, logs, and recovery procedures.
- Tuning Extract/Replicat parameters and resource management to achieve high throughput.
Advanced Topics: High Availability, Cloud, and Migration
- Implementing 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 configuring a one-way replication pipeline.
- Lab: Implementing transformations and handling DML and DDL replication.
- Scenario: Diagnosing replication latency and executing failover/recovery procedures.
Summary and Next Steps
Requirements
- A solid grasp of relational database concepts.
- Practical experience in administering Oracle Database or equivalent RDBMS systems.
- Familiarity with server administration tasks on Linux/Unix or Windows platforms.
Target Audience
- Database Administrators (DBAs).
- Data replication and integration engineers.
- Platform and operations engineers responsible for maintaining 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
