Oracle Exadata Migration

Oracle Exadata Storage Server is a revolutionary advancement in database technology where database intelligence has been implemented at the storage level resulting in significant application performance gains. 

There are many methods, tools and technologies for migrating your database to Oracle Exadata but generally speaking they fall into two broad categories: physical migration and logical migration. While there are several factors that determine which method is best, the decision making process is usually dominated by one factor, the available down time to complete the move. The good news is that DBORA Consulting has hands on experience in migrating life production databases to Oracle Exadata and have developed there are several strategies to help you get there. 

The following are the main phases we use for Oracle Exadata migration projects:-

1. Planning and Discovery phase.

In this phase we establish some perimeters on the best migration strategy given the business service level, system attributes and the source database version. A high level project plan would also be developed during this phase.

2. Data Collection and Analysis phase.

In this phase, I/O capacity analysis of the source database is performed using our in-house performance forecasting tools to ensure we define the Oracle ASM diskgroup and Oracle Exadata storage cells to ensure performance and capacity. Failures are also taken into account to ensure post-failure I/O capacity is sufficient to tolerate failures. CPU and Memory capavity analysis is also performed to ensure its sized appropriately. As Oracle Exadata comes in pre-configured server and storage configuration, information with regards to capacity is collected and comunicated to the customer. Several configuration choices determines the available storage capacity for use.  

3. Detail Migration Strategy and Plan phase. 

In this phase a detail technical discussion and analysis is conducted to develop the most appropriate migration strategy that meets the requirement of the business. Certain critical acid test would also be carried out to firm out migration plan timeline. The plan would also incorporate necessary migration checkpoint and fall-back strategy. 

4. Migration phase

In this phase the migration is executed as per the detail migration plan developed. This plan is assumed to have gone through the relevant change and risk management process and audit respectively.

5. Post migration phase

Although significant performance improvement is a pre-conceived expectation in moving to Oracle Exadata, its not uncommon to find some application codes not performing as expected. Hence there is a need to carry out the usually performance fine tuning.  In this phase, a complete performance analysis is conducted to fine-tune the business application from the Oracle Exadata perspective and establish a performance baseline.

Note:

We highly recommed customers to conduct SQL performance test using Oracle Real Application Testing tool (RAT) to quality assure the performance of the SQL code when migrating into Oracle Exadata. Although this is not part of our standard Oracle Exadata migration service, however we are more than capable of undertaking this task as part of the overall migration strategy. 

 

 

 

Key Benefits 

There is absolutely no substitute for experience. We have significant hand-on experience in undertaking Oracle Exadata migration to ensure it is succesfully completed. 

We promote high skills transfer in undertaking Oracle Exadata migration projects to ensure in-house DBA's are sufficiently trained to handle first level support.