Contact Premier Online Trainings Today
Premier Online Trainings

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
  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle GoldengGate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets
  • Describing Oracle GoldenGate Process Groups
  • Explaining Change Capture and Delivery (with and without a Data Pump)
  • Explaining Initial Data Load
  • Contrasting Batch and Online Operation
  • Explaining Oracle GoldenGate Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle GoldenGate Files and Directories
  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell
  • Reports(.rpt)
  • Parameters (.prm)
  • Stdout (.out)
  • Replicate checkpoints (.cpr)
  • Extract checkpoints (.cpe)
  • Process Status (.pcs)
  • SQL Scripts (.sql)
  • Database Definitions (.def)
  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDENGATE_AUTH Package
  • Reviewing Extract Overview
  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails
  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat
  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps
  • Oracle GoldenGate Methods
  • Listing Database-specific Methods
  • Describing Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • Configuring File Load Methods
  • Configuring Direct Load Methods
  • Handling Collisions with Initial Load
  • Editing Parameter Files
  • Contrasting GLOBALS versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters
  • Filtering and Data Selection
  • Mapping Columns Between Different Schemas
  • Using Built-in "@" (at) Functions
  • Using SQLEXEC to Interact Directly with a Database
  • Configuring New Coordinated Replicat
  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences
  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security
  • Importance of Discard file
  • Overview of Data Definition File
  • When to use Data Definition File
  • Configuring Data Definition File
  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues
  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL
  • 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