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
Fundamentals of Oracle GoldenGate Architecture
- Core components and process roles: Extract, Pump, Replicat, Manager, and Collector
- Exploration of GoldenGate Microservices architecture and how it contrasts with the classic model
Setup, Configuration, and Environment Readiness
- System prerequisites, supported platforms, and the installation process for GoldenGate 19c
- Setting up the Manager process, parameter files, and deployment directories
- Database dependencies, user permissions, and network configurations
Data Capture and Movement Workflows
- Capture techniques: Classic Extract, Integrated Extract, and Log-based CDC
- Trail file structure, transport mechanisms, and checkpoint management
- Configuring Extract, Data Pump, and Replicat processes
Data Mapping, Transformations, and Conflict Management
- Defining data mappings and column transformations via parameter files and mapping rules
- Managing data type conversions and character set compatibility
- Strategies for detecting and resolving conflicts in bidirectional replication
GoldenGate Microservices and Administrative Interface
- Deployment and management of the GoldenGate Microservices Manager and Admin Server
- Utilizing GoldenGate Studio and REST APIs for administrative tasks
- Security configuration: SSL/TLS, user role management, and secure connections
Oversight, Diagnostics, and Performance Optimization
- Tracking replication health, latency metrics, and performance indicators
- Analyzing common error patterns, logs, and recovery protocols
- Optimizing Extract/Replicat parameters and resource allocation for high throughput
Advanced Concepts: High Availability, Cloud, and Migration
- Establishing high-availability and zero-downtime migration strategies using GoldenGate
- Implementing GoldenGate in cloud environments and hybrid architectures (OCI, AWS, Azure)
- Upgrading GoldenGate, applying patches, and planning migrations
Practical Labs and Real-World Applications
- Lab: Installing GoldenGate 19c and setting up a one-way replication pipeline
- Lab: Implementing transformations and managing DML and DDL replication
- Scenario: Identifying replication latency issues and executing failover/recovery actions
Conclusion and Future Directions
Requirements
- A solid grasp of relational database concepts
- Practical experience in administering Oracle Database or similar RDBMS platforms
- Proficiency in Linux/Unix or Windows server management
Target Audience
- Database Administrators (DBAs)
- Data replication and integration specialists
- Platform and operations engineers overseeing high-availability systems
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
