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
 21 Stunden

Teilnehmerzahl


Preis je Teilnehmer (exkl. USt)

Erfahrungsberichte (3)

Kommende Kurse

Verwandte Kategorien