Description

Introduction to Oracle Exadata & GoldenGate19c

Welcome to the Oracle Exadata & GoldenGate19c Admin! In today’s enterprise landscape, efficient data management and seamless integration are paramount. This training is designed for database administrators and IT professionals who want to gain in-depth knowledge and hands-on experience with Oracle Exadata, a powerful database machine, and Oracle GoldenGate, a leading solution for real-time data integration and replication.

Throughout this course, you will learn how to configure, manage, and optimize Oracle Exadata environments, as well as leverage GoldenGate for data replication and migration. We will cover best practices for performance tuning, high availability, and disaster recovery, empowering you to maximize the capabilities of Oracle’s technologies in your organization.

By the end of Oracle Exadata & GoldenGate19c Admin the training, you will be equipped with the skills needed to administer Oracle Exadata and GoldenGate effectively, enhancing your value as a database management professional.

Prerequisites

To ensure a productive learning experience, we recommend the following prerequisites:

1. Familiarity with Oracle Database: A basic understanding of Oracle Database concepts and architecture is essential.
2. SQL Knowledge: Proficiency in SQL and PL/SQL will help you navigate the training material effectively.
3. Basic Linux Skills: Familiarity with Linux command line operations is beneficial, as Oracle Exadata often runs on Linux systems.
4. Experience with Database Administration: Some prior experience in database administration is helpful but not mandatory.

TABLE OF CONTENT 

1 . Introduction to Oracle Exadata and GoldenGate

Overview of Oracle Exadata(Ref: Oracle- On-Prem Application Mastery)
Overview of Oracle GoldenGate 19c
Key Features and Benefits

2 . Oracle Exadata Administration

Exadata Architecture
Hardware Components
Software Components
Storage Configuration
Network Configuration
Monitoring and Diagnostics

3 . Oracle GoldenGate 19c Installation

System Requirements
Pre-installation Tasks
GoldenGate Software Installation
Configuration Options

4 . GoldenGate Configuration

Extract and Replicate Processes
Configuration Files
Data Pump and Trail Files
Parameter Files
Credential Store

5 . Oracle GoldenGate Operations

Start and Stop Processes
Monitoring and Troubleshooting
Lag and Checkpointing
Conflict Resolution
Performance Tuning

6 . Integration with Oracle Database

Database Integration (Ref: Spring Integration)
Data Types and Synchronization
DDL Replication
Filtering and Transformation

7 . High Availability and Disaster Recovery

Configuring GoldenGate for High Availability
Oracle GoldenGate Veridata
Disaster Recovery Strategies

8 . Security and Auditing

Securing GoldenGate
Auditing and Logging
Role-Based Access Control

Reference