Legacy System Migration to Oracle with Golden Gate

This case study outlines the migration of legacy systems to the latest Oracle version using Oracle Golden Gate. The process involves real-time data replication between Oracle, Mainframe and other systems, ensuring minimal downtime and data integrity.

Golden Gate facilitates seamless data transfer, supporting both homogeneous and heterogeneous systems. Key features include data extraction, trail file management and distribution services for smooth migration. This solution enhances system availability, scalability and performance.

Problem

Statement

The migration of legacy systems to the latest Oracle version requires a seamless data transfer process. To achieve this, Golden Gate technology is being utilized for real-time data replication. Data is being migrated through three key replication methods: Mainframes to Oracle, Oracle to Oracle and Oracle to Mainframes. The source data originates from various systems, including Manhattan, the Cigarette Warehouse System, the Labour Management System and Mainframe and is transferred accurately to the OMS destination systems. This ensures data integrity, accuracy and minimal downtime during the migration process.

Solution

Proposed

Oracle Golden Gate Implementation

What: Oracle Golden Gate is a replication tool that enables real-time data transfer between source and target databases, including transactional data.

Why: Golden Gate facilitates seamless data movement between homogeneous (Oracle to Oracle) and heterogeneous (Oracle to Mainframe or other RDBMS databases) systems with zero downtime.

Replication Process

  • Data replication is established between Oracle to Oracle, Mainframe to Oracle and Oracle to Mainframe.
  • Extracts and Replicate: Extract processes capture changes from the source database, while Replicate processes apply those changes to the target database.
  • Trail Files: Data is stored in trail files at both source and target locations, which are transferred over the network.
  • Logging Mechanism: Table-level logging and supplemental logging enable transactional data to be recorded in trail files.
  • Distribution Service: Heterogeneous databases use a distribution service for seamless trail file transfer to target systems.

Process Workflow

  • Extract: Captures changes from the source database and stores them in a trail file on the hub server.
  • Replicate: Applies changes from the trail file to the target database, ensuring data synchronization.
  • Data Pump/Distribution Service: Transfers trail files between GoldenGate environments, facilitating replication between the hub server and I-Series GoldenGate.
  • Initial Load (Optional): A one-time data transfer process to sync source and target tables before replication begins. If both tables are initially empty, they remain in sync after the process.

Business

Values

01

High Availability & Scalability Oracle Golden Gate ensures continuous data transfer with zero downtime, improving system scalability and availability.

02

Real-Time Data Movement Data is replicated in real-time, reducing latency and enhancing performance.

03

Multi-Database Support Golden Gate enables replication across Oracle and other database systems, including Mainframe, ensuring smooth data migration.