Dell PowerEdge T110 II - Manual (Page 22)

Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage
Systems
22
 The migration solution is applicable to Oracle databases using the Oracle ASM file system. Oracle
ASM is the recommended file system by Oracle with the majority of the customer implementations.
 The migration solution avoids the complexity involved in moving Oracle RAC Clusterware disks, by
building a separated Oracle RAC cluster on the target system.
 The migration solution moves Oracle database from the traditional storage system to the thin
provisioned Dell Compellent storage that delivers optimum disk utilization.
Dell IT Case Study
In the past, to support the data growth of global applications, Dell IT was required to provision storage
to accommodate at least 18 months of estimated growth. It was a challenge to support growing
applications on IT infrastructure. With the traditional storage system, the provisioning process had to
cater for the estimated growth, resulted a far more storage needed to be provisioned than was
immediately required.
In the last 6 months, Dell IT has successfully migrated 500 Oracle databases and 200 SQL Server
databases that are using 700TB of storage space to Dell Compellent storage systems.
By leveraging the Dell Compellent thin provisioning feature, Dell IT teams are now able to provision
less upfront storage for applications and increase capacity when needed. Additional storage is being
allocated to Oracle databases with the Oracle ASM rebalancing methodology described in the paper,
which is seamless to the application users.
This allows the storage administrator to execute provisioning requests on a much faster basis. Getting
the benefit of Dell Compellent Fluid Data architecture is what facilitates true storage virtualization and
a highly-granular approach to storage tiering. Applications on Dell Compellent storage experiencing
200% performance increases in IOPs on random reads and writes, and 15% performance increasing on
sequential reads and writes.
Summary
Traditional Oracle database migration methods often cause major disruptions to data access, or may
incur high costs involved in purchasing additional migration tools. By taking advantages of the native
Oracle database ASM disk rebalance feature, this paper presents a near zero downtime migration
methodology, which can help maintain the availability of applications during Oracle database
migration.
References
1. “Oracle Automatic Storage Management Administrator’s Guide”, 11g Release 2 (11.2), E18951-
03. http://docs.oracle.com/cd/E11882_01/server.112/e18951/toc.htm
2. “OCR / Vote disk maintenance operations: add / remove / replace / move”, My Oracle Support
document ID # 428681.1. https://support.oracle.com