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 functions: Extract, Pump, Replicat, Manager, and Collector.
- Common topologies: unidirectional, bidirectional, cascaded, and hub-and-spoke models.
- Introduction to the GoldenGate Microservices architecture and how it contrasts with the classic model.
Setup, Configuration, and Environment Readiness
- System specifications, compatible platforms, and the installation process for GoldenGate 19c.
- Setting up the Manager process, parameter files, and directory structures.
- Preparing database prerequisites, defining user privileges, and addressing network requirements.
Change Data Capture and Data Transfer
- Capture techniques: Classic Extract, Integrated Extract, and Log-based CDC.
- Trail file structures, transport methods, and checkpoint mechanisms.
- Setting up Extract, Data Pump, and Replicat processes.
Mapping, Transformations, and Conflict Management
- Establishing data mappings and column transformations via parameter files and rules.
- Managing data type conversions and character set implications.
- Strategies for detecting and resolving conflicts in bidirectional replication.
GoldenGate Microservices and Administrative Interface
- Deployment and administration of the GoldenGate Microservices Manager and Admin Server.
- Leveraging GoldenGate Studio and REST APIs for administrative tasks.
- Implementing security features: SSL/TLS, role-based access, and secure connections.
Monitoring, Diagnostics, and Performance Optimization
- Tracking replication status, latency indicators, and performance metrics.
- Identifying common errors, analyzing logs, and executing recovery actions.
- Optimizing Extract/Replicat parameters and managing resources for high throughput.
Advanced Concepts: High Availability, Cloud Integration, and Migration
- Applying high-availability and zero-downtime migration techniques using GoldenGate.
- Utilizing GoldenGate in cloud environments and hybrid setups (OCI, AWS, Azure).
- Upgrading GoldenGate, adhering to patching best practices, and planning migrations.
Practical Labs and Real-World Case Studies
- Exercise: Installing GoldenGate 19c and establishing a unidirectional replication pipeline.
- Exercise: Applying transformations and managing DML and DDL replication.
- Case Study: Investigating replication latency and performing failover/recovery procedures.
Conclusion and Future Directions
Requirements
- A solid grasp of relational database principles.
- Practical experience in administering Oracle Database or a similar RDBMS.
- Proficiency with Linux/Unix or Windows server management.
Target Participants
- Database Administrators (DBAs).
- Engineers specializing in data replication and integration.
- Platform and operations engineers tasked with maintaining high-availability systems.
21 Hours
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
