Get in Touch
 Duration 21 hours

Course Outline

Overview of Oracle GoldenGate Architectural Foundations

  • Core components and operational responsibilities: Extract, Pump, Replicat, Manager, and Collector
  • Architectural patterns: unidirectional, bidirectional, cascading, and hub-and-spoke configurations
  • Foundational details of the Microservices architecture and its distinctions from the traditional classic model

Deployment, Configuration, and Operational Environment Setup

  • System specifications, supported operating systems, and installation protocols for GoldenGate 19c
  • Configuration of the Manager process, parameter file management, and directory structures
  • Database prerequisites, required user privileges, and network infrastructure requirements

Change Data Capture Mechanisms and Data Transmission

  • Capture methodologies: Classic Extract, Integrated Extract, and Log-based CDC approaches
  • Trail file structures, transmission strategies, and checkpoint management
  • Configuration and optimization of Extract, Data Pump, and Replicat processes

Data Mapping, Transformation Logic, and Conflict Resolution

  • Establishing data mapping and column transformations via parameter files and mapping rules
  • Managing data type conversions and character set alignment
  • Detection and resolution strategies for conflicts in bidirectional replication environments

GoldenGate Microservices Framework and Administrative Interface

  • Deployment and lifecycle management of the Microservices Manager and Admin Server
  • Utilization of GoldenGate Studio and REST APIs for operational administration
  • Security configuration including SSL/TLS protocols, role-based access control, and secure connection standards

Performance Monitoring, Diagnostics, and Optimization

  • Tracking replication health, latency indicators, and performance metrics
  • Analysis of common error patterns, log review, and recovery protocols
  • Tuning of Extract and Replicat parameters and resource allocation for high-throughput scenarios

Advanced Topics: Resilience, Cloud Integration, and Migration Strategies

  • Implementation of high-availability architectures and zero-downtime migration plans using GoldenGate
  • Deployment of GoldenGate in cloud and hybrid infrastructure environments (OCI, AWS, Azure)
  • Version upgrades, patch management best practices, and strategic migration planning

Practical Exercises and Operational Case Studies

  • Exercise: Installation of GoldenGate 19c and configuration of a unidirectional replication workflow
  • Exercise: Implementation of data transformations and management of DML/DDL replication events
  • Case Study: Diagnosis of replication latency and execution of failover and recovery procedures

Conclusion and Recommended Operational Next Steps

Requirements

  • A solid understanding of relational database management concepts
  • Practical experience administering Oracle Database or equivalent Relational Database Management Systems
  • Familiarity with Linux/Unix or Windows server administration protocols

Target Audience

  • Database Administrators (DBAs)
  • Data replication and integration specialists
  • Platform and operations engineers responsible for maintaining high-availability systems

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories