Lab Practice: Preparing Oracle Databases for GoldenGate Replication

Lab Practice: Preparing Oracle Databases for GoldenGate Replication

Preview unavailable

You must log in or sign up to view this lesson.

LoginSign up

Oracle GoldenGate Administration

Buy nowLearn more

Course Materials (Downloadable)

  • Activity Guide-v11.0
  • GG_slides_v7.0

Part 1: GoldenGate Classic

  • What you will learn?

Introduction to Oracle GoldenGate

  • Overview of Oracle GoldenGate

GoldenGate Architecture

  • Overview of GoldenGate Architecture
  • Overview of Classic Architecture

Components of GoldenGate Classic Architecture

  • Manager, Extract, Trail, Data Pump, Collector, Replicat

GoldenGate Key Terms and Concepts

  • About Parameter Files, Checkpoint Files, CSN, GGSCI

Types of Extracts and Replicats

  • Types of Extracts and Replicats

Preparing Practice Environment and Downloading GG Software

  • Link to download pre-built VMs3
  • Preparing Practice Environment and Downloading GoldenGate Software

Installing Oracle GoldenGate

  • Installing GoldenGate for Oracle Database

Becoming Familiar with GGSCI

  • Becoming Familiar with GGSCI

Preparing Oracle Databases for GoldenGate Replication

  • Overview of Preparing Databases for GoldenGate Replication
  • Lab Practice: Preparing Oracle Databases for GoldenGate Replication

Configuring Online Change Synchronization (DML)

  • About Configuring Online Change Synchronization
  • Lab Practice: Configuring Online Change Synchronization
  • How to Start GoldenGate Processes?

Implementing Initial Load

  • Overview of Initial Load
  • Lab Guide: GoldenGate Initial Load Methods
  • Lab Practice: Initial Load using Oracle Data Pump
  • Lab Practice: Initial Load using File to Replicat
  • Lab Practice: Initial Load using GoldenGate Direct Load Method
  • Lab Practice: Initial Load using Direct Bulk Load to SQL* Loader

Configuring Credentials Store

  • Configuring Credential Store

Monitoring GoldenGate Processing

  • Overview of Monitoring GoldenGate Processing
  • Lab Practice: Monitoring GoldenGate Processing

Mapping and Manipulating Data

  • Overview of Mapping and Manipulating Data
  • Lab Practice: Mapping and Manipulating Data

Implementing DDL Synchronization

  • Overview of DDL Replication
  • Lab Practice: Configuring DDL Replication

Implementing Bidirectional Replication

  • Overview of Bidirectional Replication
  • Overview of Data Looping
  • Lab Practice: Implementing Bidirectional Replication
  • About Conflicts in Active-Active Configuration
  • Overview of CDR - Conflict Detection and Resolution
  • Lab Practice: Implementing CDR
  • Overview of Auto CDR
  • Lab Practice: Implementing Auto CDR

Part 2: Oracle GoldenGate Microservices

  • What you will learn?

Overview of Oracle GoldenGate Microservices

  • Overview of Oracle GoldenGate MA

Installing Oracle GoldenGate Microservices

  • Preparing the Practice Environment
  • Installing GoldenGate MA Software and Adding Deployment
  • Configuring Databases and GoldenGate for Replication

Configuring Online Change Synchronization

  • Configuring Online Change Synchronization in GGMA

Implementing Initial Load

  • Implementing Initial Load in GGMA

How to Stop/Start VMs with GGMA Installed?

  • Starting and Stopping VMs

Admin Client

  • Using Admin Client

Performance Metrics Service

  • About Performance Metrics Service