Description

The Oracle GoldenGate 11g: Fundamentals for Oracle Edition 2 training program emphasis on Oracle-to-Oracle database replication. This training program introduces the Oracle GoldenGate architecture and different product features. Professionals learn to install Oracle GoldenGate and prepare the source and target environments. The training program teaches way to use the Oracle GoldenGate command line interface (GGSCI) efficiently. Professionals configure Change Capture (Extract), Change Delivery (Replicat), and Initial Load. They learn to extract trails as well as files using Data Pump, create parameter files, and to manage and maintain Oracle GoldenGate instances. Capture of both DDL and DML will be configured for both bi-and uni-directional replication.

Radiant Teachlearning offers Oracle GoldenGate 11g: Fundamentals for Oracle Training Program in Classroom and Virtual instructor Led/Online mode.

 

Duration: 4 days

 

Learning Objectives

  • Install Oracle GoldenGate on Linux and Windows platforms
  • Issue GGSCI commands
  • Configure, start, stop, and monitor Change Capture and Delivery processes
  • Manage Extract trails and files using Data Pump and logdump
  • Create parameter files to transform data
  • Manage multiple Oracle GoldenGate instances
  • Design replication solutions using Oracle GoldenGate products and environments
  • Install Oracle GoldenGate on Linux and Windows platforms (the labs are Linux)
  • Prepare the source and target database environments (assumes Oracle-to-Oracle replication)
  • Configure, start, stop, and monitor Change Capture (Extract)
  • Configure, start, stop, and monitor Change Delivery (Replicat)
  • Issue GGSCI commands (batch Obey scripts and command-line interactive)
  • Configure, start, stop, and monitor Initial Load
  • Manage Extract trails and files using Data Pump and utilities such as logdump
  • Control network transmission using compression and encryption
  • Create parameter files
  • Transform data
  • Manage multiple Oracle GoldenGate instances

This training program is based on Oracle Golden Gate version 11.2.1.

Pre-requisites

Audience Profile

  • Administrator
  • Analyst
  • Architect
  • Database Administrator
  • Developer
  • Implementer
  • System Integrator

Course Content

Introduction

  • Technology Overview
  • Oracle GoldenGate Architecture

Installing Oracle GoldenGate

  • Configuration Overview and Preparing the Environment
  • Configuring Change Capture (Extract)

Configuring Change Delivery (Replicat)

  • Configuring Extract Trails and Files (Data Pump)
  • Performing Initial Load

Editing Configuration Parameters

  • Filtering and Data Selection
  • Additional Transformation Concepts

Configuration Options

  • Bidirectional Replication
  • DDL Replication

FAQs

Q: What kind of audience is expected for this training?

 

A: This training is recommended for the following professionals:-

  • Administrator
  • Analyst
  • Database administrator
  • Developer
  • Implementer
  • System Integrator

 

Q: What is the role of Golden gate?

 

A: The Golden Gate is high performance software for real time data transactional change and offers bidirectional data replication.

 

Q: What is the role of Data pump?

 

A: Data pump enables a very high speed data transfer from one database to another database.

 

Q: What is the meant by log dump?

 

A: Log dump is the standard utility which allows users to scan and save the transaction records with the OGG trails.

 

Q: What is meant by Golden Gate RBA?

 

A: Relative Byte Address is the exact location of the trail file of the current transaction.

 

Q: What is Bi-Directional replication in Golden Gate?

 

A: It’s active to active replication which captures data from multiple databases and concludes with a single format synchronized data. This replication is implemented for the result of high availability.

 

Q: Why one should prefer Radiant Techlearning ?

 

A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.

 

Q: What if I/we have doubts after attending your training program?

 

A: Radiant team of experts would be available on the e-mail support@radianttechlearning.com to answer your technical queries even after the training program.

 

Q: Does this training program include any project?

 

A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.

 

Q: If I face technical difficulty during the session then is there any remedy for that?

 

A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.

 

Q: What is schedule of training program?

 

A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch