Online Oracle Goldengate Training Classes And Courses  BISP 

60% Complete Courses » Oracle Goldengate
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


Duration: 20 hours hours

Who Should Attend:
DBAs, PL/SQL Developers, Technologists responsible for data replication, High availability technologists.

Salient Features:
Implementation and configuration of the Oracle Golden Gate replication

Objective:
The objective of this training is to explain the fundamental concepts of Oracle GoldenGate used for data replication and integration. At the end of this training, the participants are expected to have Goldegate knowledge and will be able to start working on live projects.

Environment:
Version: Oracle 12c GoldenGate
Platform: UNIX / Any flavor of Linux supported by Oracle 11.x.x.x GoldenGate/12c
Database: Oracle 12.1.2.0.1 multitenant Architecture
a) Oracle 12c Database server
b) Two instances of Oracle GoldenGate

Hands on:
Oracle GoldenGate concepts will be explained by demonstration programs wherever required on Oracle Database running on Linux/Windows Platform.

Course Contents:

Overview of Oracle Database
• Architecture

Introduction to Oracle Golden Gate
• Oracle Golden Gate Replication Solutions for Live Reporting, Real Time Data Warehousing, Live Standby Database, and High Availability.
• Supported databases and platforms
• Advantages of Oracle Golden Gate

Installing Oracle Golden Gate
• Downloading the software from Oracle website.
• Installing Oracle Golden Gate
• Explaining Subdirectories
• Preparing Oracle 12c database for data replication

Oracle Goldengate Architecture

• Concepts and Components
• Process Data Flow
• Design Considerations

Configuring & Preparing the Environment

• Configuring the Manager process
• Describing the Manager Parameters
• Starting the Manager process
• Configuring GLOBALS file

DML Replication - Online Change Synchronization
• Description and Demo
• Integrated Extract vs Classic Extract
• Integrated Replicat vs Classic Classic Replicat

Initial Load
• Getting two databases into sync initially

Zero Downtime Migration and Upgradation using Goldengate
• Strategy

Goldengate 12c new features

Parameter files
• Parameters
• How to Comprehend Parameter File
• How to configure Parameter File

Data Definitions File
• Overview of Data Definitions File
• When to use Data Definitions Files
• Types of Data Definitions File
• Configuring Data Definitions File

DDL Replication
• Alter, Drop, Create Overview of DDL synchronization
• Configuring Extract and Replicat for DDL replication

Bidirectional Replication
• CDR(Conflict detection and Resolution)
• Active Active
• Active Passive

Oracle Goldengate Security
• Wallet Creation
• Password Encryption

Troubleshoot Goldengate Issues
• Discard File Creation
• Add a new table in already running goldengate config
• Adjusting the extract and replicat based on SCN/DB logs/Timestamp

Managing Oracle Golden Gate
• Managing trail files
• Automating process startup
• Using reporting and statistics

Reading trail files
• Logdump Utility

2. Performance of Oracle Goldengate
• How to monitor Goldengate
• Monitor lag

Q And A session
• Along, with this training Virtual Machine setup along with Linux image loaded with Oracle Database and oracle Goldengate will be shared.
• We will be sharing documentations, test cases and interview questions as well with this training. Also, will help student in setting up their own lab on their machine.

Certification:
• Oracle Goldengate Implementation Specialist
• Oracle Goldengate 12c Essentials
Course Id:
ODI002 
Course Fees:
301 USD