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.
Course Outline
Introduction to Oracle GoldenGate Architecture
- Core GoldenGate components and process roles: Extract, Pump, Replicat, Manager, and Collector.
- Various GoldenGate topologies: one-way, bi-directional, cascaded, and hub-and-spoke.
- An overview of the GoldenGate Microservices architecture and its distinctions from the classic architecture.
Installation, Configuration, and Environment Preparation
- System requirements, supported platforms, and installation procedures for GoldenGate 19c.
- Setting up the Manager process, parameter files, and deployment directories.
- Database prerequisites, user privilege settings, and network considerations.
Change Data Capture and Data Movement
- Different 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 Handling
- Data mapping and column transformations via parameter files and mapping rules.
- Managing data type conversions and character set considerations.
- Strategies for conflict detection and resolution in bidirectional replication.
GoldenGate Microservices and Administration UI
- Deployment and management of the GoldenGate Microservices Manager and Admin Server.
- Utilising GoldenGate Studio and REST APIs for administrative tasks.
- Configuring security features: SSL/TLS, user roles, and secure connections.
Monitoring, Troubleshooting, and Performance Tuning
- Monitoring replication health, latency metrics, and performance counters.
- Identifying common error patterns, analysing logs, and executing recovery procedures.
- Optimising 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.
- Deploying GoldenGate in cloud environments 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: Applying transformations and managing DML and DDL replication.
- Scenario: Diagnosing replication latency and performing failover/recovery steps.
Summary and Next Steps
Requirements
- A solid grasp of relational database concepts.
- Practical experience in administering Oracle Database or equivalent RDBMS systems.
- Proficiency with Linux/Unix or Windows server administration.
Target Audience
- Database Administrators (DBAs).
- Data replication and integration engineers.
- Platform and operations engineers managing high-availability systems.
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
