Section 1: Goldengate 12c Architecture

GG Components

Architecture Basics

Processes

Parameters

Topologies

Role Of Datapump In GG

Integrated Extract

Data Load

Section 2: Setting Of Up Linux Server And Installation Of Oracle DB 12c

Install Oracle Enterprise Linux Servers

Install Oracle 12c Database Software

Setup Goldengate OS Add-On

Clone Linux Servers

Configure Oracle Databases

Goldengate Use Cases

Section 3: Install GoldenGate 12c

Supported DB’s

OS Combinations

Software And OS Requirements

Installation – OUI

Directories

New In 12c GG

Section 4: Oracle To Oracle Configuration Basics

Steps To Configure

Preparing Environment – Character Set

Configure User – Oracle Database

Network Diagnostics

Preparing Environment – Supplemental Logging

Configuring Manager

Section 5: Extract Data

Change Capture

Datapump Options

Process Groups

Configure Wallet

Integrated Capture

Extract Trails

Start Extract

Section 6: Replicate Data

Change Delivery Basics

CDD Activities

Treat Collisions

Integrated Apply

Monitoring

Reports & Diagnostics de33

Section 7: Trail Files

Extract Trails And Files

Formats

Substitutes

Logdump

Logging Trails

Reverse Utility

Section 8: Replication With Initial Load

Initial Load

Kick Start Load

Pre-Checks

Methods

File Based Loading

Direct Load

Section 9: Data And Configurations

GLOBAL & Manager Parameters

Extract & Replicat Parameters

Data Selection: WHERE, FILTER

Data Mapping: Columns

RANGE

SQLEXEC Functionalities

Functions Specific To Goldengate

Section 10: Other Considerations In GG

Macros & Tokens

User Exits & Sequences

Batchsql In GG

Data Compression In GG

Daa Encryption & Events

Section 11: Bi-Directional Replication Configuration ( Active - Active )

Configurations

Data Loopings

CDR ( Conflict Detection And Resolution )