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 their functional roles: Extract, Pump, Replicat, Manager, and Collector.
- Architectural topologies: one-way, bi-directional, cascaded, and hub-and-spoke configurations.
- Understanding the GoldenGate Microservices architecture and how it contrasts with the classic model.
Installation, Configuration, and Environment Preparation
- Reviewing system prerequisites, supported platforms, and the installation workflow for GoldenGate 19c.
- Setting up the Manager process, parameter files, and deployment directory structures.
- Establishing database prerequisites, defining user privileges, and addressing network requirements.
Change Data Capture and Data Movement
- Exploration of capture methods: Classic Extract, Integrated Extract, and log-based CDC.
- Trail file architecture, data transport strategies, and checkpoint 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 nuances.
- Strategies for detecting and resolving conflicts in bi-directional 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 administrative tasks.
- Security configuration: implementing SSL/TLS, defining user roles, and ensuring secure connections.
Monitoring, Troubleshooting, and Performance Tuning
- Tracking replication health, latency metrics, and performance indicators.
- Analyzing common error patterns, logs, and executing recovery procedures.
- Optimizing Extract/Replicat parameters and managing resources for high throughput.
Advanced Topics: High Availability, Cloud, and Migration
- Strategies for implementing high-availability and zero-downtime migrations using GoldenGate.
- GoldenGate in cloud and hybrid architectures, including OCI, AWS, and Azure.
- Upgrading GoldenGate, adhering to patching best practices, and planning migrations.
Hands-on Labs and Real-World Scenarios
- Practical lab: Installing GoldenGate 19c and setting up a one-way replication pipeline.
- Practical lab: Applying transformations and managing DML and DDL replication.
- Scenario simulation: Diagnosing replication latency and performing failover and recovery actions.
Summary and Next Steps
Requirements
- A solid grasp of relational database fundamentals.
- Practical experience managing Oracle Database or comparable RDBMS platforms.
- Competency in administering Linux/Unix or Windows server environments.
Target Audience
- Database Administrators (DBAs).
- Engineers specializing in data replication and integration.
- Platform and operations engineers overseeing high-availability system infrastructure.
Testimonials (1)
good explanation on each points and provide assignment for practices.
