Course Outline
Fundamentals of Oracle GoldenGate Architecture
- Core GoldenGate elements and process functions: Extract, Pump, Replicat, Manager, and Collector
- GoldenGate structural layouts: one-way, bidirectional, cascaded, and hub-and-spoke
- An overview of the GoldenGate Microservices structure and its distinct advantages over the classic architecture
Installation, Configuration, and Environment Setup
- System specifications, compatible platforms, and deployment procedures for GoldenGate 19c
- Setting up the Manager process, parameter files, and deployment directories
- Database prerequisites, user permissions, and network requirements
Change Data Capture and Data Transfer
- Capture techniques: Classic Extract, Integrated Extract, and Log-based CDC
- Trail file structure, transmission strategies, and checkpointing mechanisms
- Configuration of Extract, Data Pump, and Replicat processes
Mapping, Transformations, and Conflict Management
- Data mapping and column modifications via parameter files and mapping rules
- Managing data type conversions and character set implications
- Strategies for detecting and resolving conflicts in bidirectional replication
GoldenGate Microservices and Administration Interface
- Deployment and management of the GoldenGate Microservices Manager and Admin Server
- Leveraging GoldenGate Studio and REST APIs for administrative tasks
- Security setup: SSL/TLS, user roles, and secure connection protocols
Monitoring, Diagnosis, and Performance Optimization
- Tracking replication status, latency indicators, and performance metrics
- Identifying common error patterns, analyzing logs, and recovery protocols
- Optimizing Extract/Replicat parameters and resource allocation for high throughput
Advanced Topics: High Availability, Cloud, and Migration
- Executing high-availability and zero-downtime migration strategies using GoldenGate
- GoldenGate in cloud environments and hybrid setups (OCI, AWS, Azure)
- Upgrading GoldenGate, patching best practices, and migration planning
Practical Labs and Real-World Applications
- Lab: Installing GoldenGate 19c and setting up a one-way replication stream
- Lab: Applying transformations and managing DML and DDL replication
- Scenario: Investigating replication latency and performing failover/recovery actions
Recap and Future Recommendations
Requirements
- A solid grasp of relational database principles
- Practical experience managing Oracle Database or a comparable RDBMS
- Knowledge of Linux/Unix or Windows server administration
Target Audience
- Database Administrators (DBAs)
- Specialists in data replication and integration
- Platform and operations engineers maintaining high-availability systems
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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
