Page 3 - Contents; Tables
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems iii Contents Executive summary ..................................................................................................... 4 Introduction ..................................................
Page 4 - Executive summary
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 4 Executive summary Database migration has become a routine operation in most IT organizations for modernization, consolidation and platform migration. Migration delivers improved computing power...
Page 5 - Introduction; Dell Configurations for Oracle―; Technology Overview; Dell PowerEdge 12
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 5 Introduction The Dell PowerEdge 12 th Generation servers and Dell Compellent storage systems are ideal choices for hosting Oracle database workloads by providing not only superior performance, ...
Page 6 - Dell Compellent Storage Systems
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 6 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 perfo...
Page 7 - Reasons Why Customers Migrate to Dell Compellent
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 7 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 l...
Page 8 - Oracle Database Migration to Dell PowerEdge 12; Test Configuration; Figure 1. Reference configuration of Oracle database migration
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 8 Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Test Configuration The migration methodology provided in this paper is developed based on the re...
Page 9 - Table 2. Volume configuration of the source database; Migration Options
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 9 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 la...
Page 10 - Oracle Golden Gate software; Oracle Automatic Storage Management (ASM) Disk Rebalance
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 10 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 extend...
Page 13 - Preparing the Target System
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 13 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 configu...
Page 14 - Table 3. Volume configuration of the target database; Used for
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 14 Table 3. Volume configuration of the target database Used for Volume Size File system format ASM disk name Oracle RAC Clusterware disks 3 volumes of OCR disks 1 GB each Block device N/A 2 volu...
Page 16 - Presenting Dell|EMC Volumes to the Target Database Servers
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 16 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 tar...
Page 17 - Figure 7. Create a new storage group in Dell|EMC storage manager
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 17 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 ...
Page 18 - Starting Up Database on the Target System; Quick Application Switch Over to the Target Database
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 18 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|E...
Page 19 - Migrating Data to the Target System
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 19 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...
Page 21 - Post Migration Tasks; Key Benefits of the Migration Solution
Oracle Database Migration to Dell PowerEdge 12 th Generation Servers and Dell Compellent Storage Systems 21 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_00...
Page 22 - Dell IT Case Study
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 implementatio...