Schulungsübersicht
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
Voraussetzungen
- 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
Erfahrungsberichte (3)
Große Kommunikation, Łukasz hat alles auf eine einfache und verständliche Weise erklärt
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Kurs - ORACLE SQL Fundamentals
Maschinelle Übersetzung
Der Trainer war sehr hilfreich, der Rhythmus des Trainings war wirklich gut und die Übungen waren nicht zu schwer, aber auch nicht zu leicht. Sobald ich feststeckte, half er mir ausgezeichnet und stellte sicher, dass ich alles verstand.
Jade Stappaerts - KULeuven
Kurs - Oracle SQL Language
Maschinelle Übersetzung
die Übungen
Amna AlAli - Federal Demographic Council
Kurs - Oracle SQL for beginners
Maschinelle Übersetzung