Contact Premier Online Trainings Today

Oracle Golden Gate Admin

  • Home
  • Oracle Golden Gate Admin
Course Overview
Premier Online Trainings Institute provides best Oracle Golden Gate Admin training in Hyderabad, Banglore by our Highly Professional certified trainers.

Oracle Golden Gate is Oracle's strategic solution for real time data integration. Golden Gate software enables mission critical systems to have continuous availability and access to real-time data. It offers a fast and robust solution for replicating transactional data between operational and analytical systems. Oracle Golden Gate captures, filters, routes, verifies, transforms, and delivers transactional data in real-time, across Oracle and heterogeneous environments with very low impact and preserved transaction integrity.

Oracle Golden Gate provides five data replication solutions:
High Availability

Live Standby for an immediate fail-over solution that can later re-synchronize with your primary source. Active-Active solutions for continuous availability and transaction load distribution between two or more active systems.

Zero-Downtime Upgrades and Migrations

Eliminates downtime for upgrades and migrations.

Live Reporting

Feeding a reporting database so as not to burden the source production systems with BI users or tools.

Operational Business Intelligence (BI)

Real-time data feeds to operational data stores or data warehouses, directly or via Extract Transform and Load (ETL) tools.

Transactional Data Integration

Real-time data feeds to messaging systems for business activity monitoring, business process monitoring, and complex event processing. Uses event-driven architecture and service-oriented architecture (SOA).

* We also provide Online Training for Normal Track, Fast Track and Weekend Batches
Course Curriculum
  • Oracle High Availability Techniques
  • Datagaurd/Streams Vs Golden Gate
  • Definition
  • Real Time Use Cases
  • Supported databases and platforms
  • Building Blocks of Golden Gate
  • Manager
  • Extract(Capture)
  • Datapump(Routing)
  • Replicate(Delivery)
  • Trails (Extract) Files
  • Checkpoints – Detailed explanation of checkpoints
  • Collector (Server collector)
  • Data Source
  • Groups
  • Transformation
  • Preparation & Installation of GG S/W on Source Server
    • -Very Important pre-requisites on Source DB
    • -Installing OGG S/W on Source Server
    • -Creating of working /mandatory directories
    • -Verifying DB connectivity from GG S/W
  • Preparation & Installation of GG on Target server
    • -Very Important Pre-requisites on Target DB
    • -Installing OGG S/W on Target Server
    • -Creating of working /mandatory directories
    • -Verifying DB connectivity from GG S/W
  • Reports (.rpt)
  • Parameters (.prm)
  • Stdout (.out)
  • Replicate checkpoints (.cpr)
  • Extract checkpoints (.cpe)
  • Process Status (.pcs)
  • SQL Scripts (.sql)
  • Database Definitions (.def)
  • Memory Requirements
  • Disk Requirements
  • Storage for Oracle Golden Gate Trails
  • To estimate required trail space
  • Temporary Disk requirements
  • Network
  • Operating System Privileges
  • Checkpoint table
  • Configuring the Manager Process
  • Describing the Manager Parameters
  • Starting the Manager Process
  • Describing the Extract process
  • Explaining Extract checkpoints
  • Extract Creation on source side
  • Adding Extract on GG Interface
  • Adding remote trail at GG Interface on source side
  • Registering Extract at GG Interface on source side
  • Starting Extract process
  • Describing GGSCI commands
  • Describing Extract trails and files
  • Configuring Replicate on target side
    • -Describing the Replicate process
    • -Explaining Replicate checkpoints
    • -Replicate Creation on target side
    • -Adding Replicate on GG Interface
    • -Starting replicate process on target side
  • Observing Unidirectional Replication
    • -Describing GGSCI commands
    • -Describing Extract trails and files
  • Extract Configuration on Source side
    • -Describing the Extract process
    • -Explaining Extract Checkpoints
    • -Extract Creation on Source side
    • -Adding Extract on GG Interface
    • -Registering Extract at GG Interface on source side
    • -Adding local trail at GG Interface on source side
    • -Starting a Extract process
    • -Describing GGSCI commands
    • -Describing Extract trails and files
  • Datapump (Secondary Extract-Optionla) Configuration on Source side
    • -Describing the Datapump process
    • -Explaining Datapump checkpoints
    • -Datapump Creation on source side
    • -Adding Datapump on GG Interface
    • -Adding remote trail at GG Interface on source side
    • -Starting Datapump process
    • -Describing GGSCI commands
    • -Describing Extract trails and files
  • Configuring Replicate target side
    • -Describing the Replicate process
    • -Explaining Replicate Checkpoints
    • -Replicate Creation on target side
    • -Adding Replicate on GG Interface
    • -Starting replicate processes on target side
  • Observing Unidirectional Replication
    • -Describing GGSCI Commands
    • -Describing Extract trails and files
  • Instantiation through Initial Load (table level)
  • Instantiation through exp & Imp (Schema/table)
  • Instantiation through RMAN cloning (FULL DB)
  • Importance of Discard file
  • Overview of Data Definition File
  • When to use Data Definition File
  • Configuring Data Definition File
  • Handing Data missing errors on target side
  • Handing TCP/IP Errors
  • Troubleshooting process startup failures
  • Troubleshooting Extract problems
  • Troubleshooting missed transactions
  • Using the discard file
  • Using SHOWSYNTAX to view Replicate SQL statements
  • Using the Log dump utility