Oracle GoldenGate 12c: Fundamentals for Oracle

Код курсу

OGFO

Тривалість

4 Днів, 32 Ак. Годин

Завантажити pdf

Опис курсу

Цілі

Вимоги

Програма курсу

Опис курсу

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 product suite, walking you through various product features. Oracle GoldenGate 12.3 for Oracle introduces the Microservices architecture, which allows for browser-based, REST interaction with Oracle GoldenGate. Both Classic and Microservices architectures are covered by the course, which starts by explaining replication concepts using the familiar, Classic architecture. After solid replication foundations and concepts are explained and explored, the course delves into Microservices, and students are made quickly familiar with the new architecture. Hands-on practices help solidify the theoretical knowledge acquired during the lessons. Students will implement end-to-end replication environments using both architectures, testing the established replication channels with real data, to verify that replication is taking place.

Цілі

Course Objectives

Configure, start, stop, and monitor Change Capture (Extract), Change Delivery (Replicat), and Initial Load using the Classic architecture
Configure, start, stop, and monitor Change Capture (Extract), and Change Delivery (Replicat) using the Microservices architecture
Filter, map, transform and encrypt in-transit data
Design replication solutions using Oracle GoldenGate products and environments
Install Oracle GoldenGate and prepare the source and target database for replication (assumes an Oracle-to-Oracle environment)
Learn and make use of GGSCI commands
Use the browser-based interface to configure and manage replication occurring within a Microservices architecture
Manage Extract trails and files using utilities such as logdump

Вимоги

Suggested Prerequisite

Familiarity with Oracle Database and basic SQL using SQL*Plus
Familiarity with editing Linux text files using gedit or vi
Familiarity with basic encryption techniques

Audience

Database Administrators
Database Designers
System Integrator
Data Warehouse Analyst
Technical Consultant
Data Warehouse Developer
Configuration Consultant
Data Warehouse Administrator

Програма курсу

Course Topics

1. Introduction

Oracle GoldenGate Use-Cases for Oracle Database
Supported Databases
Reviewing Oracle GoldenGate Use Cases
Uses of Oracle GoldenGate
Topologies
Oracle GoldenGate Technology Suite
Supported Platforms
Technology Overview

2. Oracle GoldenGate Architecture

Checkpoints
Extracts
The Two Oracle GoldenGate Architectures
Classic Architecture
The Interaction Between Oracle GoldenGate and Oracle RDBMS
Initial Loads

3. Installing Oracle GoldenGate

Performing Installation
Configuring Environment Variables
Use Obey files to automate tasks
Using Oracle GoldenGate Software Command Interface (GGSCI)
Listing System Requirements
Running Oracle GoldenGate from the OS shell.

4. Preparing the Environment and Configuring Integrated Extract

Enabling Oracle GoldenGate in the Database
Starting the Manager
Enabling Supplemental Logging
Configuring Data Capture
Preparing the Environment
Defining Roles and Permissions
Configuration Overview

5. Configuring Initial Load

Setting Up the Initial Load by Using the “File to Replicat” Method
Initial Load Overview
Configuring Initial Load
Setting Up the Initial Data Load by Using the “Direct Load” Method

6. Configuring Change Delivery (Replicat)

Configuring Replicat Tasks
Troubleshooting: Report FIles and Log FIles
Initial Load: Handling Collisions with Initial Load
Replicat Overview
Using Checkpoints
Troubleshooting: GGSCI Process Information
Initial Load: Avoiding Collisions with Initial Load
Adding Checkpoints

7. Managing Extract Trails and Files

Trail Format: Local and Remote
Trail Format: Cleanup
Alternative Trail Formats: Logical Change Records (LCRs)
logdump: Opening, Viewing, and Filtering
Alternative Trail Formats: Text, SQL, and XML
Trail Format: Record Header Area
Trail Format: Record Data Area

8. Oracle GoldenGate Parameters

GLOBALS
Manager
Source Manager Parameters
Target Manager Parameters
Extract
Replicat
Extract Parameters on the Source Database
Options Common to Both Replicat and Extract

9. Data Selection and Filtering

Definition Files
Where
Filter
Data Selection
SQLEXEC
Mapping and Manipulation
Mapping

10. Additional Transformation and Configuration Options

Compress Data Across the Network
Set and Retrieve Useer Tokens
Automatically Trigger Actions Based on Event Records
Run User Exits in GoldenGate Processes
Encrypt Messages, Trails, and Passwords
Create and Invoke Macros

11. Installing Oracle GoldenGate Microservices Architecture

List the Operating System Pre-Requisites Needed for a Microservices Architecture installation
Perform an Oracle GoldenGate Microservice Architecture Installation and Verify its Successful Completion
Identify and Describe the Various Components of the Oracle GoldenGate Microservices Architecture

12. Oracle GoldenGate Microservices Architecture – Administration Server

Using the Administration Server Embedded Web Application to Create Extract and Replicat Groups
Accessing Extract/Replicat Process Parameters, Statistics, Checkpoints and Reports Using the Administration Server Embedded Web Application

13. Oracle GoldenGate Microservices Architecture – Distribution Server

Accessing the Data Path Parameters, Statistics, SCN / RBA Positions in Trail Files, and Data Filters Using the Distribution Server Embedded Web Application
Using the Distribution Server Embedded Web Application to Create, Start and Stop Paths

14. Oracle GoldenGate Microservices Architecture – Receiver Server and Performance Metrics Server

The Role and Functionality of an MA Performance Metrics Server
The Role and Functionality of an MA Receiver Server

15. MA Admin Client

Performing Common Administrative Tasks by Using the Admin Client
Using the Admin Client to Connect to an MA Deployment

16. Database Sharding Support, Metadata Encapsulation, Replication Lag Management, Invisible Column Support

Implementing a Lag Management Policy
Handling Replication of Invisible Columns
Metadata Encapsulation Features and Advantages
Database Sharding Concepts and GoldenGate MA Support for It

Назад до курсів (Oracle)

Реєстрація на найближчий курс

Oracle GoldenGate 12c: Fundamentals for Oracle

Код курсу:

OGFO

Тривалість:

4 Днів, 32 Ак. Годин

Зареєструватися

Завантажити pdf