Highly-available Retail OLTP Database migration and High Availability solution design

Project goals:

  • Migrate of 50+ TB Highly-Available OLTP database from Europe to Russia
  • Migrate the DB from IBM Power AIX-based servers to Oracle Exadata X7
  • Setup a high-availability solution, based on geo-replication between Russian and European datacenters
  • Ensure the migration downtime window to be less than 4 hours
  • Migrate Weblogic-based enterprise application

Highly-available Retail OLTP Database migration and High Availability solution design

Highly-available Retail OLTP Database migration and High Availability solution design

Accomplishments:

  • Highly-available, scalable architecture has been developed, comprising Oracle RAC, geo-distributed DataGuard system, Cascade Active DataGuard for offloading reporting workload
  • A custom two-phase migration approach has been developed to ensure downtime windows of less than 4 hours
  • The migration solution based on XTTS for Phase One and on Data Guard switch-over for phase 2
  • The migration procedure has been scripted to minimize the downtime and manual work
  • The load testing plan has been developed, using Oracle Database Replay
  • The solution has been implemented within 4 months, meeting the deadline requirements

Technologies:

  • Oracle Database
  • Oracle Exadata
  • Oracle Cross-Platform Transportable Tablespaces (XTTS)
  • Oracle Enterprise Manager Cloud Control
  • Oracle Grid Infrastructure
  • Oracle Real Application Clusters
  • Oracle DataGuard
  • Weblogic Server
  • Oracle Database Replay
  • AIX
  • Oracle Enterprise Linux

Workload:

  • 945 hours

Project team:

  • 2 x Senior Oracle Exadata Administrator
  • 2 x Senior Oracle Middleware Administrator
  • Senior Oracle Database Architect
  • Project Manager

Want to make a successful project?

Need to save costs and consolidate your data assets? Tweak the database performance or execute 0% downtime database migration? Our creative approach unlocks business potential and focus on creating newer possibilities