Oracle GoldenGate Administration

Part - 1

Introduction to Oracle GoldenGate

• What is Oracle GoldenGate?

• Why do you need Oracle GoldenGate?

• When do you use Oracle GoldenGate?

• Topologies for Oracle GoldenGate

• Supported Databases

• Supported Operating Systems

• GoldenGate Vs Data Guard

• Oracle GoldenGate Product Family

Oracle GoldenGate Architecture

• Classic Architecture and Microservices Architecture (MA)

• When to use which Architectures?

• Components of Oracle GoldenGate Classic Architecture

• Manager, Extract, Data Pump, Collector, Replicat

• Extract Trail, Remote Trail, Checkpoints, Wallet, GGSCI

• Parameter Files – GLOBALS file, runtime parameter files

• Processing Types – online, source-is-table, special-run, remote process

• Processing Groups

• Commit Sequence Number (CSN)

• Types of Extracts - Classic Extract and Integrated Extract

• Types of Replicats - Classic, Integrated, Coordinated and Parallel Replicats

Installing Oracle GoldenGate

• Preparing the Practice Environment

• Downloading the software

• Installing and configuring Oracle GoldenGate software

Preparing the Database for Oracle GoldenGate

• Establishing GoldenGate Credentials

• Enabling GoldenGate in Oracle Databases

• Configuring Database Logging Options - Archive Log, Force Log, Supplemental logging

Securing GoldenGate Credentials

• Creating Credential Store

• Adding Credentials to Credential Store

• Using Secured Credentials in Parameter Files

Configuring Online Change Synchronization (Unidirectional)

• Overview of Online Change Synchronization

• Choosing Names for Processes and Files

• Creating Online Extract Group

• Creating a Trial

• Creating Parameter File for Online Extraction

• Creating an Online Replicat Group

• Creating a Parameter File for Online Replication

Configuring Initial Change Synchronization (Initial Load)

• Overview of Initial Load Procedure

• Initial Load in Classic Architecture

• Prerequisites for Initial Load

• Performing Initial Load

Managing and Monitoring Oracle GoldenGate

• Starting/Stopping GoldenGate

• Monitoring GoldenGate

• Monitoring Extract Recovery

• Monitoring Process Lag

• Monitoring Processing Volume

• Using the Error Log

• Using the Process Report

• Using the Discard File

• Maintaining Discard and Report Files

• Monitoring End-to-End Lag

Mapping and Manipulating Data

• Parameters that control Mapping and Data Integration

• Mapping Columns using TABLE and MAP

• Selecting Columns

• Selecting and Filtering Rows

• Testing and Transforming Data

Implementing DDL Replication

• Requirements and Restrictions

• DDL Replication Scope

• Setup DDL Replication

• Filtering DDLs

Implementing Bidirectional Replication

• Overview of an Active-Active Configuration

• Considerations for Active-Active Configuration

• Preventing Data Looping

• Managing Conflicts

• Configuring Conflict Detection and Resolution (CDR)

• Configuring Manual CDR

• Configuring Auto CDR

Implementing Heterogenous Replication

• What is Heterogenous Replication?

• What is Supported?

• What is different?

• Implementing Oracle to PostgreSQL Replication

• Implement PostgreSQL to Oracle Replication

• Implement Oracle to MySQL Replication

Part - 2: Oracle GoldenGate Microservices

Oracle GoldenGate Microservices Architecture

• Oracle GoldenGate Microservices Architecture (MA)

• Classic Vs Microservices Architecture

• Access Points for Microservices

Components of Microservices Architecture

• Service Manager

• Administration Service

• Distribution Service

• Receiver Service

• Performance Metrics Service

Deployments

• What is Deployment?

• Secure Deployment

• Non-Secure Deployment

• Local Deployment

• Remote Deployment

Installation of Oracle GoldenGate Microservices

• Preparing the Practice Environment

• Downloading Oracle GoldenGate Microservices Software

• Installing the Software

• Adding a Deployment

GoldenGate Microservices File Layout

• Installation Directories

• Top Level Directories

• Software Home Directory and Files

• Service Manager Home Directory and Files

• Deployment Home Directory and Files

• GoldenGate Daemon

Configuring Databases and GoldenGate for Replication

• Enabling Force Logging

• Enabling Supplemental Logging

• Configuring Archive Log mode

• Establishing GoldenGate Credentials

• Enabling GoldenGate in Database

• Configuring Oracle Net Service Names

Configuring Online Change Synchronization

• Overview of Online Change Synchronization

• Processing Groups and Naming Convention

• Adding Extract

• Adding Replicat

• Adding Distribution Path

• Testing Change Synchronization

Configuring Initial Change Synchronization

• What is Initial Load?

• Prerequisites for Initial Load

• Implementing Initial Load

• Adding Initial Load Extract

• Adding Replicat

• Adding Distribution Path

Using Admin client

• Becoming Familiar with Admin Client

• Using Admin Client