Zero-Downtime Database Upgrade for a Global Fortune 500 Oil Company

Using Oracle GoldenGate for data replication and Veridata to enable real-time monitoring of data consistency.

Our client is a Polish oil refiner and petrol retailer. The corporation is a significant European publicly traded firm with major operations in Poland, Czech Republic, Slovakia, Germany, and the Baltic states as well as Canada. They decided to work with Goldenore to ensure business continuity and uninterrupted functioning of systems during the database upgrade.

DATA CONSISTENCY

ensured with Oracle VeriData 

8 TB TO 30 TB DATA MIGRATION

without shutting down any business-critical applications

SAP CERTIFIED

architecture for data replication

BUSINESS PERSPECTIVE

Challenges

  • Necessary migration to a new infrastructure puts the company at risk because of migration downtime ​
  • Possible negative consequences include:​ very high downtime costs (half hour costing millions of dollars)​, application errors in the new environment, loss of data generated during migration downtime​

Benefits

  • All business applications remain active during migration, there is no downtime​
  • There are no application errors caused by incompatibility with the new environment, and data consistency is confirmed after migration ​
  • Migration does not disrupt business at any time throughout the process​

ARCHITECTURE

The architecture of the solution is based on Oracle GoldenGate and Oracle GoldenGate Veridata:

Oracle GoldenGate solution to enable real-time data replication with zero downtime for business databases and applications,
Oracle GoldenGate Veridata to enable real-time monitoring of replicated data consistency validation.

Technology Partners

Oracle

Oracle is the company that has created the world’s first – and only – autonomous database that helps to organise and secure client data. Oracle Cloud Infrastructure provides increased efficiency, security and cost savings.

TECH PERSPECTIVE

Project Goals

  • Fit within the maintenance window for critical systems, which is only 30 minutes per quarter
  • Maintain continuity of the business-critical applications and reduce downtime to a minimum
  • The architecture needs to be certified by SAP in the context of its use for data replication to and from SAP systems

Outcomes

  • The migration process (from 8 TB to 30 TB of data) was performed without shutting down any business-critical applications
  • During the migration process, the source databases worked without any downtime
  • The replication process did not put any additional load on the existing hardware infrastructure
  • Data quality and consistency between replication sides were monitored and validated
  • The architecture of the solution is based on Oracle GoldenGate and Oracle GoldenGate Veridata

Schedule a free consultation

We’d love to learn about your business goals and guide you through optimal technology options.