Oracle GoldenGate 12c: Fundamentals for Oracle

Course code

Orcl_GG

Duration

4 Days, 32 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

Course overview

This Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate architecture, walking you through various product features.

Objectives

Course objectives

Design replication solutions using Oracle GoldenGate products and environments
Install Oracle GoldenGate and prepare the source and target database (assumes Oracle-to-Oracle replication)
Issue GGSCI commands (batch Obey scripts and command-line interactive)
Configure, start, stop, and monitor Change Capture (Extract), Change Delivery (Replicat), and Initial Load
Manage Extract trails and files using Data Pump and utilities such as logdump
Control network transmission using compression and encryption
Transform data

Prerequisites

Audience

Administrator
Analyst
Architect
Database Administrator
Developer
Implementer
System Integrator

Course Outline

Course outline

1.Technology Overview

Creating Oracle GoldenGate Topologies
Reviewing Oracle GoldenGate Use Cases
Assembling Building Blocks
Listing Supported OS
Listing Supported Databases
Listing the Oracle GoldengGate Product Line
Describing GUI Management Options
Listing Non-Database Sources and Targets

2. Oracle GoldenGate Architecture

Describing Oracle GoldenGate Process Groups
Explaining Change Capture and Delivery (with and without a Data Pump)
Explaining Initial Data Load
Contrasting Batch and Online Operation
Explaining Oracle GoldenGate Checkpointing
Describing Commit Sequence Numbers (CSN)
Describing Oracle GoldenGate Files and Directories

3. Installing Oracle GoldenGate

Listing System Requirements
Performing Installation
Configuring Environment Variables
Using GGSCI
Running Oracle GoldenGate from the OS shell.

4. Configuration Overview and Preparing the Environment

Reviewing Configuration Overview
Configuring Manager Process
Creating Source Definitions
Preparing the Source Database
Assigning Oracle Database Roles/Privileges Required
Using DBMS_GOLDENGATE_AUTH Package

5. Configuring Change Capture (Extract)

Reviewing Extract Overview
Accessing Logs on Oracle ASM
Accessing Logs Remotely
Configuring Extract Tasks
Adding Extract Group
Editing Extract Parameters
Extracting Use of Archived Transaction Logs
Adding Trails

6. Configuring Change Delivery (Replicat)

Reviewing Replicat Overview
Configuring Replicat Tasks
Configuring a Sample Environment
Configuring New Integrated Replicat

7. Configuring Extract Trails and Files (Data Pump)

Reviewing Extract Trails and Files Overview
Describing Trail Formats
Using Logdump for Viewing Trails
Reversing the Trail Sequence
Configuring and Using Data Pumps

8. Performing Initial Load

Oracle GoldenGate Methods
Listing Database-specific Methods
Describing Resource Limitations
Listing Advantages of Oracle GoldenGate Methods
Configuring File Load Methods
Configuring Direct Load Methods
Handling Collisions with Initial Load

9. Editing Configuration Parameters

10. Filtering and Data Selection

11. Additional Transformation Concepts

12. Configuration Options

13. Bidirectional Replication

14. DDL Replication

Back to trainings (Oracle)

Request the training

Oracle GoldenGate 12c: Fundamentals for Oracle

Course code:

Orcl_GG

Duration:

4 Days, 32 Acad. Hours

Apply

Download pdf