Re-platform databases to Oracle Exadata Database Machine or Oracle Exadata Cloud using Migration Workbench

January 30, 2024 | 5 minute read
Rajendra Patil
Product Manager
Text Size 100%:

Many Enterprises are in the midst of large-scale digital transformation. Strategic projects involve re-platforming of business-critical Applications and underlying database infrastructure to new generation cloud-based technologies like Oracle Exadata Database Service or Exadata Cloud@Customer, and even to traditional on-premises Exadata Database Machine.

Re-platforming Oracle Databases involves rebuilding databases on upgraded operating systems on new-generation hardware or technology platforms. Re-platforming databases require minimal change to the code structure and ensures no changes in the functionality it provides for existing applications to continue to perform.  This allows a re-platform journey to be confined to end-to-end applications for infrastructure validation and performance analysis with minimal downtime.

The main drivers for re-platforming to new generation Oracle Exadata systems are primarily for consolidation to reduce the overall CapEx, and build out an automated secure environment to lower OpEx and keep data secure with an elevated security posture.

Challenges for re-platforming are complexity, predictability, repeatability, application testing, and duration of the migration project.

Typical re-platforming use cases are: 

  • Migrating from commodity hardware to on-premises Oracle Exadata Database Machine or Oracle Exadata Cloud
  • Migrating from non-multitenant to multitenant-based architecture

Enterprise Manager Database Migration Workbench is your one solution to accomplish the above use cases with ease and consistent user experience.

Migration Workbench offers two options to re-platform Oracle Databases to Oracle Exadata Database Machine or Oracle Exadata Cloud

  1. With Transportable Tablespace (TTS) using Logical or Physical Migration method
  2. With the Data Pump Logical Migration method

Migration Workbench selects the best re-platform option based on source and target choices

Migration Workbench
Figure 1:  Migration Workbench best re-platform option based on source and target choices

 

Re-platform the Oracle Database Using Transportable Tablespace (TTS) Logical or Physical Migration method

  • With minimum downtime
  • With Tablespace or full database migration choice
  • By using either a multi-phase or single-phase TTS migration approach
  • To new, or existing pluggable database (PDB) or non-multitenant database In a cross-platform environment
  • With near zero downtime to take care of 24*7 transactional systems

Re-platform the Oracle Database Data Pump Logical Migration method

  • With limited downtime
  • By either schema or full database migration choice
  • To new, or existing pluggable database (PDB) or non-multitenant database
  • In cross-platform environment

There are 3 simple steps to migrate your databases using Migration Workbench:

  1. Plan
  2. Migrate and
  3. Analyze 

Plan:

In the Plan step, Migration Workbench offers a pre-migration analysis of source databases using the pre-migration readiness check for Data Pump or TTS migration methods. The readiness performs pre-migration checks against the source database and provides success or failure results with severity-wise advisory recommendations. 

Pre-migration Readiness Report  

 

Replatform readiness

 

 

Migrate:

In the Migrate step, based on the business requirement, start migration using a derived method. You can perform a multi-phase or single-phase Transportable Tablespace migration to optimize the downtime requirements. Another important activity during the migration phase is the validation. Migration Workbench automatically validates source and destination logins, database status, disk space, and privileges and provides recommendations for database administrators to resolve issues before proceeding with migration. The automatic validation step is very critical and useful during consolidating a fleet of databases.

Analyze:

In the Analyze step, step-by-step analysis and real-time tracking of migration jobs can be performed with pre and post-validation summaries with details. If an object fails, more insights are available to determine the cause of failure. 

Migration Workbench offers automated pre and post-migration analysis after migration with

  • Automatic validation report before or during migration
  • Pre-migration analysis of source database with severity-wise report and recommendation to fix each impacted category
  • Post-migration analysis of source database compared with migrated database with severity-wise report and recommendation to fix each impacted category

How Migration Workbench Automatically carries out pre and post-migration analysis report

 

View Analysis

 

Once the migration job is completed, to avoid ending up with a performance-degraded database after migration, Workbench generates an SQL performance analysis report. This report does SQL Performance analysis and provides precise recommendations to tune regressed SQLs. Workbench does automated workload Analysis with the root cause of changes like plans, higher volume, etc.

This will enable your database administrators to remediate to ensure business applications perform at the expected level.

How Migration Workbench Workbench does workload analysis before and after database migration and provides a performance comparison report

 

 

Compare performance

 

 

Benefits of using Enterprise Manager Migration Workbench to re-platform Oracle databases

  • One tool for all re-platform use cases, including cross-platform environment
  • Best data movement technology based on the source and target choices
  • Non-multitenant to multitenant
  • Near zero downtime for Applications during re-platform
  • No or little changes for Applications
  • Improved Application performance

Try out Migration Workbench on Oracle Livelabs to get hands-on experience with the tool by visiting Migrate Oracle Databases using Migration Workbench to learn how the migration of Oracle Databases using Migration Workbench works and help DBAs automate migrations.

Resources:

Rajendra Patil

Product Manager


Previous Post

Optimize the user experience in real-time using OCI Application Performance Monitoring - Real User Monitoring

Daniela Hansell | 2 min read

Next Post


Migration Workbench’s Automatic pre and post-migration analysis report

Rajendra Patil | 5 min read