About Parameter Files, Checkpoint Files, CSN, GGSCI

About Parameter Files, Checkpoint Files, CSN, GGSCI

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