Kurzusleírás
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
Követelmények
- 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
Vélemények (3)
A kiváló kommunikáció, Łukasz a dolgokat egyszerű és érthető módon magyarázta.
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Kurzus - ORACLE SQL Fundamentals
Gépi fordítás
A képző nagyon segítőkész volt. A képzés tempója valójában jó volt, és a feladatok nem voltak túl nehezek, de sem túl könnyűek. Minden alkalommal, amikor elakadtam, nagyon jól segített és biztosított, hogy mindenkit értettem.
Jade Stappaerts - KULeuven
Kurzus - Oracle SQL Language
Gépi fordítás
a gyakorlatok
Amna AlAli - Federal Demographic Council
Kurzus - Oracle SQL for beginners
Gépi fordítás