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

February 1, 2024 | 5 minute read
Rajendra Patil
Product Manager
Text Size 100%:

 

Consolidation of Oracle databases and other systems has emerged as a common IT operations strategy to drive agility and reduce costs and risks. This blog reviews Oracle Enterprise Manager Migration Workbench as the best solution for the consolidation and migration of Oracle Database environments. The example illustrated below is a migration scenario to Oracle Multitenant in a hybrid cloud environment.

Why consolidate the database using Oracle Multitenant?

When considering strategic initiatives, it is important to look ahead and ensure the database infrastructure can support your goals and objectives. Oracle Multitenant architecture is Oracle’s foundation for supporting such projects.  It’s also important to note that non-Multitenant (non-CDB) architecture was deprecated starting with Oracle Database 12c and was desupported in Oracle Database 21c. Oracle Database 23c is the first long-term release that doesn’t support non-CDB architecture and hence it’s an important consideration for long-term planning.

Migration Workbench is a solution that helps migrate on-premises databases to different Oracle database destinations non-multitenant to multitenant, on-premises to autonomous. Migration Workbench also provides the ability to migrate databases from legacy to new generation Exadata Database Machine. It has built-in capabilities for automatic pre and post-migration analysis. With SQL Performance Analyzer (SPA) integrated, each migration activity will go through comprehensive performance analysis with deep insights into performant SQL statements on the migrated database.

Migration Workbench's intuitive and guided user interface helps in migrating databases with ease. One can leverage JSON to automate fleet-level database migration using REST APIs via any DevOps tools like Chef, Ansible, Terraform, etc. 

Migration Workbench supports

  1. Logical or Physical near-zero downtime migration using RMAN Transportable Tablespace (TTS) migration method for complex large-size databases
  2. Logical Migration with limited downtime using the Data Pump migration method for the simple smaller size databases
  3. Cross-platform database migrations. One can migrate databases on AIX, Solaris, or Windows platforms to Linux

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

  1. Plan
  2. Migrate 
  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  

Premigration gif

 

Migrate:

In the Migrate step, based on business requirements, migration can be started using a derived method. Perform a multi-phase or single-phase Transportable Tablespace migration to optimize downtime requirements. Another important activity during the migration phase is 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 critical for consolidating a fleet of databases.

 

How database administrators centrally track and control migration activities using the Activity Page in the Migration Workbench 

Activity page

 

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. One can leverage JSON to automate fleet-level database migration using REST APIs via any DevOps tools like Chef, Ansible, Terraform, etc.

Analyze:

In the Analyze step, step-by-step analysis and real-time tracking of migration jobs can be performed where pre and post-validation summaries with details are generated. If an object fails, more insights are available to help understand the reason for the 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 Automatic 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 carries out workload analysis before and after database migration and provides a performance comparison report

Performance Comparison

 

Benefits of using Enterprise Manager Migration Workbench for database consolidation

  • One tool for all types of migrations
  • Near zero downtime for application during migration
  • Accuracy, Predictability & Repetitiveness

Migration Workbench helps in database consolidation 

  • Reduces CapEx with optimal utilization of infrastructure resources
  • Operational efficiency with automated day-to-day operations
  • One tool for migrating databases to multiple destinations

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

Resources:

Get hands-on migration experience with Oracle LiveLabs:

Rajendra Patil

Product Manager


Previous Post

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

Rajendra Patil | 5 min read

Next Post


Implement automated risk governance, security compliance, and audit reporting for Oracle Databases

Shiva Prasad | 4 min read