• admin@thetechmaster.in
  • |
  • +919676516545

admin@thetechmaster.in

+919676516545

Oracle Goldengate (weekend batch)

Faculity Name : Ashish

Experience : 10 Years

Course Duration : 20 days

Price : 17000 INR

Course Details

  • About Course
  • About Instructor
  • Course Content
  • Videos

Oracle Goldengate is the emerging and enhanced replication tool to connect multiple RDBMS. It is now very hot course in the market and knowledge on this is going to get better job and high paid packages.

Pre-requisite: Good knowledge on Oracle DBA

Training highlights:

Hands on vmware dump for practice

Handy materials and documents

In depth knowledge on replication

Ashish

Experience : 10 Years

Ashish is having 10+ years of experience as Oracle Goldengate Specialist and Oracle DBA. He is currently based out of Canada and implemented Goldengate in more than 50 projects by now. 

He has been in training industry for 6+ years and trained 600+ individuals and 20+ corporate clients.

With his vast experience, he deals with many real time issues and test cases in his training sessions

Oracle Goldengate (weekend batch) Course Content

Oracle GoldenGate Course Content

 

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

Performance of Oracle Goldengate

  • How to monitor Goldengate
  • Monitor lag

For Quick Contact Please Call Us : +919676516545

Batch Timings

Course Features

  • Live Instructor Led Course
  • Real Time oriented training
  • Guidance on Resume preparation
  • Mock Interviews
  • Training on latest version
  • Guidance on certification
  • Coverage of extended topics
  • Lower price