Course Outline
Introduction to Oracle GoldenGate Architecture
- Core GoldenGate components and their process roles: Extract, Pump, Replicat, Manager, and Collector
- GoldenGate deployment topologies: one-way, bidirectional, cascaded, and hub-and-spoke models
- An overview of the GoldenGate Microservices architecture, highlighting key distinctions from the classic model
Installation, Configuration, and Environment Setup
- System prerequisites, compatible platforms, and the installation workflow for GoldenGate 19c
- Setting up the Manager process, parameter files, and directory structures
- Database-level prerequisites, user permission requirements, and network planning
Change Data Capture and Data Transfer
- Capture techniques: Classic Extract, Integrated Extract, and Log-based CDC
- Trail file structure, transport mechanisms, and checkpoint management
- Configuring the Extract, Data Pump, and Replicat processes
Mapping, Transformations, and Conflict Management
- Defining data mappings and column transformations via parameter files and mapping rules
- Managing data type conversions and character set nuances
- Strategies for detecting and resolving conflicts in bidirectional replication scenarios
GoldenGate Microservices and Administrative Interface
- Deploying and administering the GoldenGate Microservices Manager and Admin Server
- Utilizing GoldenGate Studio and REST APIs for administrative tasks
- Security configuration: SSL/TLS protocols, user roles, and secure connection management
Monitoring, Troubleshooting, and Performance Optimization
- Tracking replication health, latency indicators, and performance metrics
- Identifying common error patterns, analyzing logs, and executing recovery steps
- Optimizing Extract/Replicat parameters and managing resources to achieve high throughput
Advanced Topics: High Availability, Cloud, and Migration
- Establishing high-availability frameworks and zero-downtime migration strategies using GoldenGate
- Leveraging GoldenGate in cloud environments and hybrid setups (OCI, AWS, Azure)
- GoldenGate upgrade procedures, patching best practices, and migration planning
Practical Labs and Real-World Applications
- Laboratory Exercise: Installing GoldenGate 19c and establishing a one-way replication pipeline
- Laboratory Exercise: Applying transformations and managing DML and DDL replication
- Scenario Analysis: Identifying replication latency issues and performing failover/recovery operations
Recap and Future Directions
Requirements
- A solid grasp of relational database fundamentals
- Practical experience in administering Oracle Database or comparable RDBMS systems
- Proficiency with Linux/Unix or Windows server administration tasks
Target Audience
- Database Administrators (DBAs)
- Specialists in data replication and integration
- Platform and Operations Engineers tasked with 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 3900 € + 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
