Cursusaanbod
Introduction to Oracle GoldenGate Architecture
- GoldenGate components and process roles: Extract, Pump, Replicat, Manager, and Collector
- GoldenGate topologies: one-way, bi-directional, cascaded, and hub-and-spoke
- Overview of GoldenGate Microservices architecture and key differences from classic architecture
Installation, Configuration, and Environment Preparation
- System requirements, supported platforms, and installation steps for GoldenGate 19c
- Configuring Manager process, parameter files, and deployment directories
- Database prerequisites, user privileges, and network considerations
Change Data Capture and Data Movement
- Capture methods: Classic Extract, Integrated Extract, and Log-based CDC
- Trail file architecture, transport strategies, and checkpointing
- Configuring Extract, Data Pump, and Replicat processes
Mapping, Transformations, and Conflict Handling
- Data mapping and column transformations using parameter files and mapping rules
- Handling data type conversions and character set considerations
- Conflict detection and resolution strategies for bidirectional replication
GoldenGate Microservices and Administration UI
- Deploying and managing the GoldenGate Microservices Manager and Admin Server
- Using the GoldenGate Studio and REST APIs for administration
- Configuring security: SSL/TLS, user roles, and secure connections
Monitoring, Troubleshooting, and Performance Tuning
- Monitoring replication health, latency metrics, and performance counters
- Common error patterns, log analysis, and recovery procedures
- Tuning Extract/Replicat parameters and resource management for high throughput
Advanced Topics: High Availability, Cloud, and Migration
- Implementing high-availability and zero-downtime migration strategies with GoldenGate
- GoldenGate in cloud deployments and hybrid architectures (OCI, AWS, Azure)
- Upgrading GoldenGate, patching best practices, and migration planning
Hands-on Labs and Real-World Scenarios
- Lab: Installing GoldenGate 19c and configuring a one-way replication pipeline
- Lab: Implementing transformations and handling DML and DDL replication
- Scenario: Diagnosing replication latency and executing failover/recovery steps
Summary and Next Steps
Vereisten
- An understanding of relational database concepts
- Experience administering Oracle Database or equivalent RDBMS
- Familiarity with Linux/Unix or Windows server administration
Audience
- Database administrators (DBAs)
- Data replication and integration engineers
- Platform and operations engineers responsible for high-availability systems
Getuigenissen (3)
Goede communicatie, Łukasz legde alles uit op een eenvoudige en begrijpelijke manier
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Cursus - ORACLE SQL Fundamentals
Automatisch vertaald
De trainer was erg behulpzaam, het tempo van de training was echt goed en de oefeningen waren niet te moeilijk, maar ook niet te makkelijk. Wanneer ik vastliep, hielp hij me uitstekend en zorgde ervoor dat ik alles begreep.
Jade Stappaerts - KULeuven
Cursus - Oracle SQL Language
Automatisch vertaald
de oefeningen
Amna AlAli - Federal Demographic Council
Cursus - Oracle SQL for beginners
Automatisch vertaald