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
- Overview of GoldenGate components and process roles: Extract, Pump, Replicat, Manager, and Collector.
- GoldenGate topologies: one-way, bi-directional, cascaded, and hub-and-spoke models.
- Overview of GoldenGate Microservices architecture and key distinctions from the classic architecture.
Installation, Configuration, and Environment Preparation
- System requirements, supported platforms, and step-by-step installation procedures for GoldenGate 19c.
- Configuring the Manager process, parameter files, and deployment directories.
- Database prerequisites, required 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.
Mapping, Transformations, and Conflict Handling
- Data mapping and column transformations using parameter files and mapping rules.
- Handling data type conversions and character set considerations.
- Strategies for conflict detection and resolution in bidirectional replication.
GoldenGate Microservices and Administration UI
- Deploying and managing the GoldenGate Microservices Manager and Admin Server.
- Utilizing GoldenGate Studio and REST APIs for administrative tasks.
- Configuring security measures: SSL/TLS, user roles, and secure connections.
Monitoring, Troubleshooting, and Performance Tuning
- Monitoring replication health, latency metrics, and performance counters.
- Identifying common error patterns, log analysis techniques, and recovery procedures.
- Tuning Extract/Replicat parameters and resource management for high throughput.
Advanced Topics: High Availability, Cloud, and Migration
- Implementing high-availability and zero-downtime migration strategies with GoldenGate.
- Deploying GoldenGate in cloud environments and hybrid architectures (OCI, AWS, Azure).
- Best practices for upgrading GoldenGate, patching, and migration planning.
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 steps.
Summary and Next Steps
Requirements
- A solid understanding of relational database concepts.
- Experience in administering Oracle Database or equivalent RDBMS platforms.
- Familiarity with Linux/Unix or Windows server administration.
Audience
- Database administrators (DBAs).
- Data replication and integration engineers.
- Platform and operations engineers responsible for maintaining high-availability systems.
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
