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
- Key GoldenGate components and their 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 distinct advantages over the classic model.
Installation, Configuration, and Environment Setup
- System requirements, supported platforms, and the installation process for GoldenGate 19c.
- Configuring the Manager process, parameter files, and directory structures for deployment.
- Database prerequisites, user privilege setup, and network configuration considerations.
Change Data Capture and Data Movement
- Capture methods including Classic Extract, Integrated Extract, and Log-based CDC.
- Architecture of trail files, transport strategies, and checkpointing mechanisms.
- Configuration of Extract, Data Pump, and Replicat processes.
Mapping, Transformations, and Conflict Resolution
- Implementing data mapping and column transformations via parameter files and mapping rules.
- Managing data type conversions and character set alignment.
- Strategies for detecting and resolving conflicts in bidirectional replication scenarios.
GoldenGate Microservices and Administrative Interface
- Deploying and overseeing the GoldenGate Microservices Manager and Admin Server.
- Leveraging GoldenGate Studio and REST APIs for administrative tasks.
- Establishing security protocols including SSL/TLS, role-based access control, and secure connections.
Monitoring, Troubleshooting, and Performance Optimization
- Tracking replication health, latency indicators, and performance metrics.
- Identifying common error patterns, analyzing logs, and executing recovery procedures.
- Optimizing Extract/Replicat parameters and resource allocation for high-throughput environments.
Advanced Topics: High Availability, Cloud, and Migration
- Executing high-availability and zero-downtime migration strategies using GoldenGate.
- Deploying GoldenGate in cloud and hybrid architectures (including OCI, AWS, and Azure).
- Best practices for upgrading GoldenGate, applying patches, and planning migrations.
Hands-on Labs and Practical Scenarios
- Lab: Installing GoldenGate 19c and setting up a one-way replication pipeline.
- Lab: Implementing data transformations and handling DML and DDL replication.
- Scenario: Diagnosing latency issues and performing failover or recovery actions.
Summary and Recommended Next Steps
Requirements
- Solid understanding of relational database concepts.
- Practical experience administering Oracle Database or a comparable RDBMS.
- Proficiency in Linux/Unix or Windows server administration.
Intended Audience
- Database Administrators (DBAs).
- Data replication and integration engineers.
- Platform and operations engineers responsible for high-availability systems.
Testimonials (1)
good explanation on each points and provide assignment for practices.
