Oracle Goldengate online training

Oracle Goldengate Online Training :

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 11g database for data replication

 Oracle Golden Gate Technology and Architecture

  • Understanding Golden Gate Components: Processes and Files
  • Process Data Flow
  • GoldenGate Architecture
  • Design Considerations

Configuring & Preparing the Environment

  • Configuring the Manager process
  • Describing the Manager Parameters
  • Starting the Manager process
  • Configuring GLOBALS file

Data Definitions File

  • Overview of Data Definitions File
  • When to use Data Definitions Files
  • Types of Data Definitions File
  • Configuring Data Definitions File

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

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

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

Managing Oracle Golden Gate – oracle goldengate online training

  • Managing trail files
  • Automating process startup
  • Using reporting and statistics

Where Do We Go From Here

  • Golden gate Director
  • Golden Gate Veridata
  • Logdump Utility
  • ETL using Golden Gate

Oracle Goldengate Training Online