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 GoldenGate components and process functions: Extract, Pump, Replicat, Manager, and Collector
- Exploration of GoldenGate topologies: one-way, bi-directional, cascaded, and hub-and-spoke models
- Understanding the GoldenGate Microservices architecture and its key distinctions from the classic architecture
Installation, Configuration, and Environment Setup
- Reviewing system requirements, supported platforms, and the installation process for GoldenGate 19c
- Setting up the Manager process, parameter files, and deployment directories
- Addressing database prerequisites, user privileges, and network configurations
Change Data Capture and Data Movement
- Examining capture techniques: Classic Extract, Integrated Extract, and Log-based CDC
- Understanding Trail file architecture, transport methods, and checkpointing mechanisms
- Configuring the Extract, Data Pump, and Replicat processes
Mapping, Transformations, and Conflict Resolution
- Defining data mappings and column transformations via parameter files and mapping rules
- Managing data type conversions and character set considerations
- Implementing conflict detection and resolution strategies for bi-directional 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
- Establishing security protocols: SSL/TLS, user role definitions, and secure connections
Monitoring, Troubleshooting, and Performance Optimization
- Tracking replication health, latency metrics, and performance counters
- Identifying common error patterns, analyzing logs, and executing recovery procedures
- Optimizing Extract/Replicat parameters and managing resources for high throughput
Advanced Topics: High Availability, Cloud, and Migration
- Deploying high-availability and zero-downtime migration strategies using GoldenGate
- Integrating GoldenGate within cloud deployments and hybrid architectures (OCI, AWS, Azure)
- Planning GoldenGate upgrades, applying patches, and managing migration workflows
Hands-on Labs and Real-World Scenarios
- Lab: Installing GoldenGate 19c and setting up a one-way replication pipeline
- Lab: Implementing transformations and managing DML and DDL replication
- Scenario: Diagnosing replication latency and executing failover/recovery protocols
Summary and Next Steps
Requirements
- A solid grasp of relational database concepts
- Practical experience in administering Oracle Database or a similar RDBMS
- Proficiency in Linux/Unix or Windows server administration
Target Audience
- Database Administrators (DBAs)
- Data Replication and Integration Engineers
- Platform and Operations Engineers managing high-availability systems
Testimonials (1)
good explanation on each points and provide assignment for practices.
