Online Oracle Goldengate Training Classes And Courses  BISP 

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


Oracle Goldengate 12c Training

INTRODUCTION TO ORACLE GOLDENGATE

  • History of Oracle GoldenGate
  • Databases supported by Oracle GoldenGate
  • Oracle GoldenGate related products(Veridata, monitor, Director, OEM plugin

ORACLE GOLDENGATE ARCHITECTURE

  • Modular and Logical Architecture
  • Commit Sequence Number
INSTALLING ORACLE GOLDENGATE

  • Preparing environment for Oracle GoldenGate(Download windows and Linux builds and install DB on laptop)
  • Installing Oracle GoldenGate 11g on windows and Linux
  • Installing Oracle GoldenGate 12c using Graphical Environment
  • Installing Oracle GoldenGate 12c using Silent Mode
  • Applying patches for Oracle GoldenGate 11g
  • Applying patches for Oracle GoldenGate 12c
  • Upgrade from Oracle GoldenGate 11g to 12c

INITIAL LOAD

  • Different Types of Initial Load
  • Considerations before Doing Oracle GoldenGate Initial Load
  • Configuring Direct Initial load
  • Configuring File To Replicate Method
  • Recommended Methods for Initial Load Outside of Oracle GoldenGate

ONLINE CHANGE SYNCHRONIZATION

  • Prerequisites
  • Configuring Change Capture Without Data Pump
  • Configuring Change Capture With Data Pump
  • Using Source Definitions file
  • Configuring GLOBALS file

DDL and SEQUENCE Replication

  • Trigger Based DDL Replication
  • Native DDL Replication (Triggerless)
  • Sequence Replication
  • DDL INCLUDE/EXCLUDE parameters

TYPES OF EXTRACT AND REPLICATE

  • Overview on type of Extracts
  • Overview on type of Replicate
  • Configuring Classic Extract
  • Configuring Integrated Extract
  • Configuring Classic Replicate
  • Configuring Integrated Replicate
  • Configuring Coordinated Replicate

MANAGING ORACLE GOLDENGATE

  • GGSCI Commands
  • Native Commands
  • GLOBALS parameters
  • Oracle GoldenGate parameters
  • Collector Parameters
  • Column Conversion Functions
  • Using Obey Files
  • Macros and Stored Procedures
  • Filtering and Manipulation

USING LOGDUMP UTILITY


IMPLEMENTING SECURITY ON ORACLE GOLDENGATE

  • Password Encryption
  • Trail File Encyrption

TROUBLESHOOTING ORACLE GOLDENGATE

  • What to check for Extract Issues?
  • What to check for Replicat Issues?
  • Data Issue
  • Performance Issues of Extract
  • Performance Issues of Replicat

NEW FEATURES IN ORACLE GOLDENGATE 12.2

  • Self Describing Trail Files
  • Automatic Heartbeat Table
  • Automatic Trail File Recovery
  • Trail File 9 Digit Sequence

BIDIRECTIONAL REPLICATION (ACTIVE-ACTIVE)

  • Considerations for ACTIVE-ACTIVE
  • Managing Conflicts
  • Conflict Detection and Resolution

USE-CASES OF ORACLE GOLDENGATE

  • Add a new Table in Existing Replication
  • Disaster Recovery (Active-Passive)
  • Zero Downtime Upgrade and Migrations
  • ALO Mode

Course Id:
ODI002 
Course Fees:
301 USD