Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Wendy Chen, Dell Database Solutions Engineering Vinod Emmanuel, Dell Infrastructure and Cloud Computing July 2012
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems This document is for informational purposes only and may contain typographical errors and technical inaccuracies. The content is provided as is, without express or implied warranties of any kind. © 2012 Dell Inc. All rights reserved. Dell and its affiliates cannot be responsible for errors or omissions in typography or photography. Dell, the Dell logo, and PowerEdge are trademarks of Dell Inc.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Contents Executive summary ..................................................................................................... 4 Introduction ............................................................................................................. 5 Dell Solutions for Oracle Databases ................................................................................. 5 Technology Overview ...........
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Executive summary Database migration has become a routine operation in most IT organizations for modernization, consolidation and platform migration. Migration delivers improved computing power, faster performance, new functions, features, and lowered cost of ownership. But this essential operation invites a lot of risks as well as long operational outages.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Introduction The Dell PowerEdge 12th Generation servers and Dell Compellent storage systems are ideal choices for hosting Oracle database workloads by providing not only superior performance, but also lower TCO in terms of manageability, rack space, and power and cooling.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Deliver more throughput with major I/O performance enhancements Better application performance with dual internal RAID controller options for PowerEdgeT620 and R720 No compromise on performance with greater memory density and capacity along with Intel Xeon E5 processors Dell PowerEdge 12th Generation servers feature the Intel® Xeon® E5-2600 series processors based on the Sandy Bridge-EP architectu
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Reasons Why Customers Migrate to Dell Compellent Compellent has built-in virtualization to simplify management, maximize efficiency, provide flexibility to adapt to changing requirements, and lower the TCO. Many of these benefits are most noticeable at the time of a hardware refresh.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Test Configuration The migration methodology provided in this paper is developed based on the reference configuration shown in Figure 1. The Oracle Real Application Cluster (RAC) database is migrated from the source system to the target system.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Table 1 shows that the target Oracle database environment contains newer releases of both hardware and software compared to the source environment. The target system consists of not only the latest hardware including servers, storage systems, and SAN switches, but also newer operating system releases on the database servers. The Oracle database version remains unchanged on the target system.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems database. This method is typically faster than the export and import utility by avoiding extracting data and instead directly integrating datafiles into the target database. However, an extended downtime for large databases can still occur. Oracle Golden Gate software provides real-time data replication between Oracle databases.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems alter diskgroup diskgroup_name drop disk disk_name rebalance power n; For example, SQL> alter diskgroup data drop disk DATA_0006 rebalance power 10; A common use case of the Oracle ASM disk rebalance feature is the Oracle database migration to a different storage system while the database servers remain unchanged.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Figure 3. Attach Dell Compellent storage to the source database configuration 2. Create storage volumes in the Compellent storage for hosting Oracle clusterware OCR and voting disks, as well as Oracle data files. 3. Perform zoning in the McData switches to associate the Dell PowerEdge 2950 servers’ WWN’s with the Compellent front end ports WWN’s. 4.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems 11. Remove zoning to Dell|EMC disks from the McData switches. 12. Detach Dell|EMC storage from McData switches. See Figure 4. Figure 4. Detach Dell|EMC storage from the source database configuration Near Zero Downtime Oracle Database Migration to New Infrastructure and Operating Systems Another use case of the Oracle ASM disk rebalance feature is for the migration scenario depicted in Figure 1.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Table 3.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems instance has been created in the DBCA Storage Options window, abort DBCA after it reaches the DBCA ASM Disk Groups window so that only the ASM instance is created. The screenshots of DBCA are shown in Figure 5. NOTE: It is not necessary to pre-create any ASM disk groups in the target system. Figure 5. Create ASM instance without database instance on target systems using DBCA 9.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Ensure the init.ora file contains the location to the database spfile stored in the ASM disk group such as: $ more initmigrtst1.ora SPFILE='+DATA/migrtst/initmigrtst.ora' 11. Shut down the target ASM instances. Presenting Dell|EMC Volumes to the Target Database Servers Perform the following steps to present the volumes from the source Dell|EMC storage array to the target PowerEdge R720 servers: 1.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems Figure 7. Create a new storage group in Dell|EMC storage manager 5. Reboot target servers to discover the Dell|EMC disks. 6. Configure DM Multipath for the Dell|EMC disks. 7. Change ownership of the Dell|EMC disks to oracle:dba.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems FRA2 FRA3 FRA4 FRA5 FRA6 FRA7 FRA8 FRA9 Starting Up Database on the Target System The preparation steps described in the previous two sections Preparing the target system and Presenting Dell|EMC volumes to the target database servers do not impact the source database availability. All steps are performed while the source database is up and running.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems MIGRTST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = w23-r720-m-top-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = w23-r720-m-bot-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = migrtst) ) ) In a production environment, the manual update of TNS entries in the application clients is time consuming and tedious.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems /dev/mapper/fra8p1 0 CANDIDATE /dev/mapper/ocrvote3p1 0 FOREIGN /dev/mapper/fra12p1 0 CANDIDATE /dev/mapper/fra10p1 0 CANDIDATE DATA_0000 /dev/mapper/data1p1 102398 MEMBER DATA_0002 /dev/mapper/data3p1 102398 MEMBER DATA_0004 /dev/mapper/data5p1 102398 MEMBER FRA_0000 /dev/mapper/fra1p1 102398 MEMBER FRA_0001 /dev/mapper/fra2p1 102398 MEMBER FRA_0003 /dev/mapper/fra4p1 102398 MEMBER FRA_0004 /dev/mapper/f
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems alter diskgroup data drop disk DATA_0000, DATA_0001, DATA_0002, DATA_0003, DATA_0004, DATA_0005 rebalance power 10; alter diskgroup fra drop disk FRA_0000, FRA_0001, FRA_0002, FRA_0003, FRA_0004, FRA_0005 rebalance power 10; By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems 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.
Oracle Database Migration to Dell PowerEdge 12th Generation Servers and Dell Compellent Storage Systems 3. “Introduction to Oracle SCAN”. http://www.oracle.com/technetwork/products/clustering/overview/scan-129069.
