Oracle Golden Gate 11G

Oracle Golden Gate 11G

Oracle golden gate picObjective

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 beginner level knowledge and should be able to start working on live projects. Focus Training services, Pune is the only center who train Professionals at Professional level In this technology.

Salient Features:    

You will be given a set of servers to install, implement and configure the Oracle Golden Gate replication from Oracle-to-Oracle database.

Prerequisites:

Fundamentals of Oracle 11g,  SQL,  PL SQL and UNIX basic commands.

Environment:

Version:     Oracle 11.1.1.1 GoldenGate

Platform:    UNIX / Any flavor of Linux supported by Oracle 11.1.1.1 GoldenGate

Database:     Oracle 11g R2 (11.2.0.3)

  1. a) Oracle 11g R2 database Server
  2. b) Two instances of Oracle GoldenGate

Course Contents:

  1. 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
  1. Installing Oracle Golden Gate
    • Downloading the software from Oracle website.
    • Installing Oracle Golden Gate
    • Explaining Subdirectories
    • Preparing Oracle 11g database for data replication
  1. Oracle Golden Gate Technology and Architecture
    • Understanding Golden Gate Components: Processes and Files
    • Process Data Flow
    • GoldenGate Architecture
    • Design Considerations
  1. Configuring & Preparing the Environment
    • Configuring the Manager process
    • Describing the Manager Parameters
    • Starting the Manager process
    • Configuring GLOBALS file
  1. Data Definitions File
    • Overview of Data Definitions File
    • When to use Data Definitions Files
    • Types of Data Definitions File
    • Configuring Data Definitions File
  1. Configuring Change Capture Delivery – With and Without Data Pump
    • Preparing a source database for transaction capture
    • Describing the high-level configuration steps
    • Explaining change capture and delivery with a data pump
    • Explaining change capture and delivery without a data pump
    • Explaining Oracle Golden Gate Checkpoints
    • Describing the Extract process
    • Configuring and starting an Extract process
    • Adding local and remote trails
    • Configuring and starting a data pump
    • Explaining the Replicate process
    • Configuring a Replicate process
    • Starting a Replicate process
    • Describing GGSCI commands
    • Describing Extract trails and files
  1. Configuring Change Capture Delivery – DDL Replication and Initial Data Load
    • Overview of DDL synchronization
    • Preparing a source database for transaction capture
    • Describing the high-level configuration steps
    • Configuring Extract and Replicat for DDL replication
    • Configuring Initial Data Load using Oracle GoldenGate Extract and Replicat
  1. Oracle Golden Gate Commands
    • Running Golden Gate commands from the GGSCI prompt
    • Running Golden Gate commands from the obey files
    • Running Golden Gate commands from the OS shell
    • Identifying the types of GGSCI commands available
  1. Managing Oracle Golden Gate
    • Managing trail files
    • Automating process startup
    • Using reporting and statistics
  1. Where Do We Go From Here
    • Golden gate Director
    • Golden Gate Veridata
    • Logdump Utility
    • ETL using Golden Gate

Upcoming Batches

Upcoming Batches Schedule

12 SeptRegular7.30 am To 9.30 am
23 SeptWeekend10.30 am To 02.30pm
25 SeptRegular7.30 am To 9.30 am
30 septWeekend10.30 am To 02.30pm
This table shows all the upcoming batches for the month of December 2016.

This table shows all the upcoming batches for the month of Aug 2016.

Contact – Call us at 9372005897/ 8956930899 or fill out this form, and we will be happy to contact you back

Will See you soon in center, Happy Learning!!!

Shekhar KulkarniTraining quality is good, having a great experience of learning with Kapil Jadhav sir. very good infrastructure. surely join this center for oracle Courses.