Dell T110 White Paper
Contents
1. add disk dev mapper data7pl dev mapper data8pl1 dev mapper data9pl1 dev mapper datal0pl1 dev mapper datallpl1 dev mapper datal2p1 rebalance power 0 alter diskgroup fra add disk dev mapper fra7pl dev mapper fra8pl dev mapper fra9p1 dev mapper fral0pl dev mapper frallipl dev mapper fral2p1 rebalance power 0 20 Oracle Database Migration to Dell PowerEdge 12 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 Query the V ASM_OPERATION view to monitor the status of the ASM disk rebalance operation Post Migration Tasks T 2 3 4 As user oracle register the database and database instances as the cluster resources from node 1 of the target RAC cluster srvctl add database d db unique name o oracle home srvctl add instance d db unique name i inst name n node name For example srvctl add database d migrtst o u01 app oracle product 11 1 0 db 1 srvctl add instance d migrtst i migrtstl n w23 r720 m top srvctl add instance d migrtst i migrtst2 n w23 r720 m bot Remove access to the Dell2. EMC disks from the target PowerEdge R720 servers Remove zoning to Dell EMC disks from the Brocade switches Detach Dell EMC storage from Brocade switches Key Benefits of the Migration Solution To summarize the key strengths of the migration solution provided in this paper are The migration solution is near zero downtime typically less than one minute and in most cases only seconds The migration solution utilizes native Oracle database feature without incurring additional license cost to purchase additional migration tools 21 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems e 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 e The migration solution avoids the complexity involved in moving Oracle RAC Clusterware disks by building a separated Oracle RAC cluster on the target system e 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 sto
3. higher cost higher performing tiers Compellent offers tiering based on historical access patterns so that application performance is more dependable The tiering uses an appropriate granularity much lower than a GB reducing over provisioning yet large enough to avoid creating a resource penalty at the controller level The tiering can not only can mix RAID levels but shift the RAID levels used within a tier based on the type of data access Compellent can tier within a disk to prevent seek times from growing as much as disks fill up hot data is more concentrated on the disk With automatic provisioning the initial setup does not determine the cost of the resources that will be consumed Therefore Compellent provides charge back reporting so that the departments driving the expenses can be charged appropriately and departments with efficient application deployments can benefit from the savings that tiering delivers Dell has found that a demonstration of how Compellent is set up and managed is typically the tipping point that moves people to make a change Ultimately the decision to migrate often flows naturally from having seen a Compellent demonstration By using Dell to provide the complete data center solution it becomes easier to make sure that everything needed to support the application requirements are met Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems Oracle Database Migrati
4. E STATE DATA MOUNTED FRA MOUNTED 3 Start up the database instances on both target database servers using SQL Plus For example SQL gt startup Quick Application Switch Over to the Target Database Database applications connect to databases by specifying a database connection string in the tnsnames ora file of the Oracle client After the database is brought up on the target servers one can manually update the connection string in the tnsnames ora file to reflect the target system information For example the connect string to the source database is MIGRTST DESCRIPTION ADDRESS PROTOCOL TCP HOST w21 2950 m top vip PORT 1521 ADDRESS PROTOCOL TCP HOST w21 2950 m bot vip PORT 1521 LOAD BALANCE yes CONNECT DATA SERVER DEDICATED SERVICE NAME migrtst After database is brought on the target servers the connect string should be updated to 18 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems MIGRTST ESCRIPTION DI ADDRESS PROTOCOL TCP HOST ADDRESS PROTOCOL TCP HOST w23 r720 m bot vip PORT 1521 LOAD BALANCE yes CONNECT DATA w23 r720 m top vip PORT 1521 SERVER DEDICATED SERVICE NAME migrtst In a production environment the manual update of TNS entries in the applicati
5. Oracle Database Migration to Dell PowerEdge 12 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 12 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 Intel and Xeon are registered trademarks of Intel Corporation in the U S and other countries Microsoft Windows and Windows Server are either trademarks or registered trademarks of Microsoft Corporation in the United States and or other countries Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products Dell disclaims proprietary interest in the marks and names of others July 2012 Rev 1 0 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems Contents EX CULIVE SUMIMANY sasnsceaceciscennnadecdscnasasanneasead nanan bea smaannsd sen sasagnnanbed same nasaseeadondmmnmmocesienenes 4 IINEFODUC
6. 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 e Oracle Golden Gate software provides real time data replication between Oracle databases Golden Gate software enables the capability to migrate Oracle database with zero database downtime and minimal application switchover downtime Golden Gate software is licensed separately from Oracle databases e Compellent Thin Import is an array based data migration tool provided by the Dell Compellent storage systems Thin Import migrates data from external storage systems to thin provisioned volumes on the Compellent system This helps eliminate the allocated but unused space in the source data and deliver more usable capacity on the Compellent system Thin Import is primarily an offline activity that incurs database downtime Oracle Automatic Storage Management ASM Disk Rebalance Oracle ASM is a volume manager and a file system for Oracle database files that supports single instance Oracle database and Oracle RAC configurations Oracle ASM is Oracle s recommended storage management solution which provides an alternative to conventional volume managers file systems and raw devices Oracle ASM uses disk groups to store data files Oracle ASM disk group is a collectio
7. UON s 05aiciincsinscasnascsesceimnainSandicie sais niente sincie nails ETAREN wukina cle sass eats EAREN 5 Dell Solutions for Oracle DatabAases as sccssessssieveseseven sons sseeecesswaeenedeneaee edeeesessdeeeseessedesveeden 5 TECHNOLOGY OVENVIOW citecssadticncasacvseabediadsdaneasnacsuedeuis shandecedsadcius ESE ENRERE 5 Dell PowerEdge 12 Generation Servers sssccsssssccccssccccsecccecssscecnscceceesceeensccnenscesensses 5 Dell Compelllent Storage Systems asics seins sivas ans cients antes sniis arene seni senesini nanniet aceite cients sE a grein gine eee 6 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage 8 Test CONSUPATION i serseri erinra eresi oa Eina cies cae ednees ESETA eke EENE EEES NE PEEN TOES 8 Migration Options xcs iisiinescusiecsscngiones r NETEN AEN ENEN EENEN AEN 9 Oracle Automatic Storage Management ASM Disk Rebalance sssssssssssssseseesssseseeessssseeee 10 Near Zero Downtime Oracle Database Migration to New Infrastructure and Operating Systems 13 Key Benefits of the Misration Solution 0csccoscsecesesscsoceuresssecebasetebeterebeceerescensseeesecnceees 21 Dell IT Case Study tcasesacacasteacevatesacacastecsesaseeasacaeteaeewasceacacauteaeavatesaraceuteaeavasesacacauteaeade 22 SUIMIMALY ssessis sinis sieve scents insien Enn EE aiding aferne sie ta EEE ine eleine EEEE EEE Ginna eleine alesis nE acne Soba Sle 22 REFERENCES ass sicis divine seins si
8. ability of applications during Oracle database migration References 1 Oracle Automatic Storage Management Administrator s Guide 119 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 22 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems 3 Introduction to Oracle SCAN http www oracle com technetwork products clustering overview scan 129069 pdf 23
9. ce power n For example SQL gt alter diskgroup data add disk dev mapper data1p1 rebalance power 0 The SQL syntax to drop disks into a disk group is 10 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems alter diskgroup diskgroup_name drop disk disk_name rebalance power n For example SQL gt 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 In the migration scenario illustrated in Figure 2 below the source Oracle 11g R1 RAC database runs on two PowerEdge 2950 servers Dell EMC CX3 80 Fibre Channel storage system and McData Fibre Channel switches The Dell EMC CX3 80 Fibre Channel storage system is being replaced with the Dell Compellent storage system while other components in the configuration remain unchanged Figure 2 Oracle ASM disk rebalance to move Oracle database to a different storage system Source Oracle RAC Database Oracle Cluster Private Network Dell PowerEdge 2950 Servers McData Sphereon 4400 FC switches w x Dell EMC Dell Compellent CX3 80 FC Series 40 FC Storage Storage The Oracle ASM disk rebalance feature can be effectively utilized for this type of migration scenario The high level steps for migration are 1 Cable the Dell Compellent s
10. 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 Migrating Oracle database presents many unique challenges for IT administrators such as the complexity data integrity requirements and 24x7 availability requirements of critical database applications To address these challenges Dell offers a near zero downtime migration strategy to move Oracle databases into a new infrastructure with near zero downtime impact This methodology has been proven to be reliable and repeatable with the adoption by Dell IT for a large scale Oracle database migration project This methodology brings out the best of Dell Compellent storage features like thin provisioning and a well tested reference architecture using the latest generation Dell PowerEdge servers Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems Introduction The Dell PowerEdge 12 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 For customers who are interested in moving their existing Oracle databases to new Dell hardware performing a seamless migration is the first challenge they face In the following sections this pap
11. dell com oracle and the Dell Oracle Solutions wiki page at http delltechcenter com enterprise Technology Overview Dell PowerEdge 12 Generation Servers Dell PowerEdge 12 Generation servers are the newest addition to the PowerEdge server family Dell PowerEdge 12 Generation servers can help improve the IT experience with the following notable features e Manage anywhere and anytime with agent free server management e Reduce maintenance time with auto update for replacement parts e Control cooling costs with better power monitoring and control e Tailor network to applications with fabric flexibility e Access information quicker via SATA SAS SSD and PCI Express Flash drives e Data protection using best in class RAID e Protect data at rest with malware resistance and faster encryption e Keep data safer with firmware signing and encrypted credentials e Accelerate high performance computing HPC and virtual desktop infrastructure VDI through integrated graphics processing unit GPU technology Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems e Deliver more throughput with major I O performance enhancements e Better application performance with dual internal RAID controller options for PowerEdgeT620 and R720 e No compromise on performance with greater memory density and capacity along with Intel Xeon E5 processors Dell PowerEdge 12 Generation servers feature the Inte
12. dev mapper datallpl 0 CANDIDATE dev mapper fra7pl 0 CANDIDATE dev mapper data9p1 0 CANDIDATE dev mapper fra9pl 0 CANDIDATE dev mapper frallpl 0 CANDIDATE dev mapper ocrvote4pl 0 FOREIGN dev mapper data8pl1 0 CANDIDATE dev mapper datal2pl1 0 CANDIDAT dev mapper datal0pl 0 CANDIDAT Fl Fl 19 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems dev mapper fra8pl 0 CANDIDATE dev mapper ocrvote3p1 0 FOREIGN dev mapper fral2p1 0 CANDIDATE dev mapper fral0pl 0 CANDIDATE DATA 0000 dev mapper datalpl 102398 MEMBER DATA 0002 dev mapper data3p1 102398 MEMBER DATA 0004 dev mapper data5p1 102398 MEMBER FRA 0000 dev mapper fralpl 102398 MEMBE FRA 0001 dev mapper fra2pl 102398 MEMBE FRA 0003 dev mapper fra4pl1 102398 MEMBER FRA 0004 dev mapper fra5pl 102398 MEMBE DATA 0001 dev mapper data2p1 102398 MEMBER DATA 0003 dev mapper data4pl 102398 MEMBER DATA 0005 dev mapper data6pl 102398 MEMBER FRA 0002 dev mapper fra3pl1 102398 MEMBER FRA 0005 dev mapper fra6pl 102398 MEMBER Use the following commands to add target ASM disks into the disk group without a disk rebalance and drop the source ASM disks with specifying a rebalance power This helps to restrict the disk rebalance to run only one time when dropping disks alter diskgroup data
13. dge Dell PowerEdge 2950 Servers R720 Servers Brocade 5300 4400 FC switches Feawitchas Oracle Database Migration Dell EMC Dell Compellent CX3 80 FC Series 40FC Storage Storage Oracle Database Migration to Dell PowerEdge 12 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 It is beyond the scope of this paper to discuss the Oracle database upgrade process You can find Oracle database upgrade best practices in Oracle documentation Table 1 Hardware and software configurations of the source and the target Oracle systems Source system Target system Hardware Server Dell PowerEdge 2950 servers Dell PowerEdge R720 servers Storage Dell EMC CX3 80 FC storage Dell Compellent Series 40 FC storage SAN switch McData Sphereon 4400 FC Brocade 5300 FC switches switches Software OS on database servers OEL 5 2 x86_64 OL 5 7 x86_64 Oracle database Oracle RAC 11 1 0 7 Oracle RAC 11 1 0 7 Table 2 shows the Dell EMC storage volume configuration of the source database Table 2 Volume configuration of
14. er examines various Oracle database migration options including the pros and cons of each option It details a migration solution adopted by Dell IT that can help customers migrate their existing Oracle databases to the latest releases of Dell hardware with near zero interruption to data availability A key technology component used in this solution is the Oracle Automatic Storage Management ASM disk rebalance feature This paper provides the recommended best practices on how to implement the migration methodology Dell Solutions for Oracle Databases Dell solutions for Oracle products are designed to simplify operations improve usability and provide cost effective scalability as your needs grow over time In addition to providing server and storage hardware Dell solutions for Oracle include e Dell Configurations for Oracle in depth testing of Oracle configurations for high demand solutions documentation and tools that help simplify deployment e Integrated Solution Management standards based management of Dell solutions for Oracle that can lower operational costs through integrated hardware and software deployment monitoring and updating e Oracle Licensing licensing options that can simplify customer purchase e Dell Enterprise Support and Infrastructure Services for Oracle planning deployment and maintenance of Dell solutions for Oracle database tools For more information concerning Dell Solutions for Oracle Database visit www
15. f Oracle ASM rebalance in this type of migration is less familiar to most administrators The following sections provide a detailed discussion of a near zero downtime migration methodology developed and tested by Dell engineers Preparing the Target System The target database volumes must be of equal or larger size than the source database volumes Table 3 shows the Compellent volume configurations that are similar to the source database volumes shown in Table 2 NOTE The ASM disks must be named differently than the source database otherwise the ASM disk rebalance will not work in a later step 13 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems Table 3 Volume configuration of the target database Used for Volume Size File system ASM disk name format Oracle RAC 3 volumes of OCR 1 GB each Block device N A Clusterware disks disks 2 volumes of 1 GB each Block device N A Voting disks Oracle database 6 volumes for data 100 GB each ASM data7 data8 area data9 data10 data11 data12 6 volumes for 100 GB each ASM fra7 fra8 fra9 Flash Recovery fra10 fra11 fra12 Area FRA 1 volume for spfile 1 GB Block device N A of ASM instance The high level steps to prepare the target system include 1 Create volumes in the Compellent storage and map to the target servers PowerEdge R720 2 Perform zoning in the Brocade switches to associate
16. includes the two PowerEdge R720 servers 16 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems Figure 7 Create a new storage group in Dell EMC storage manager E Storage Groups gx r720_CX380 E g Hosts BY w23 r720 m bot dblab com 172 16 168 62 Fibre 6 w23 1720 m top dblab com 172 16 168 61 Fibre LUNs SAN Copy Connections Snapshots S w2950_Cx330 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 For example brw rw brw rw brw rw brw rw brw rw brw rw brw rw brw rw brw rw brw rw brw rw brw rw rrerrrrrrrrr rre oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle dba dba dba dba dba dba dba dba dba dba dba dba 253 253 253 293 253 253 253 253 253 253 293 253 67 J 58 J 64 J 57 J 63 J 56 J 62 J 61 J 55 g 60 J 59 J 49 J ul ul ul ul ul ul ul ul ul ul ul ul U 0a aUa nnn on 174 Eis Ls LT T7 17 16 16 05 05 05 05 05 205 16 163 16 L5 2d s21 31 31 21 44 dev m dev m dev m dev m dev m dev m dev m dev m dev m dev m dev m dev m apper datalpl apper data2pl apper data3pl1
17. l Xeon E5 2600 series processors based on the Sandy Bridge EP architecture which deliver more computations per second Intel Xeon E5 2600 series processors provide up to 8 physical cores or 16 logical cores through hyper threading and up to 20 MB cache Intel Xeon E5 2600 series processors also include features such as the new Intel advanced vector extensions and the optimized turbo boost technology Dell PowerEdge 12 Generation servers include the express flash PCle solid state drives to deliver better internal storage performance by connecting directly to the processor via PCle bus These PCle solid state drives have up to 3x performance of standard SAS SSDs and 1000x performance of 15K SAS hard drives The PowerEdge R720 12 generation servers were used in the test configuration for this paper The R720 server is a two socket 2U rack server emphasizing performance and scalability R720 servers are designed for mid to large size data centers and are ideal for use as a virtualization or database server Some highlighted features of the R720 include e Large memory footprint 24 DIMMs 768GB e Dual SD cards for redundant hypervisor e CacheCade RAID enhancement to boost I O e Internal storage capacity up to 16 x 2 5 HDD or 8 x 3 5 HDD e Maximum of four optional PCle flash SSD drives e Redundant power supply units PSU e Hot plug and swappable PSU HDDs and fans Dell Compellent Storage Systems The Dell Compellent Storage Center S
18. l apper data4pl apper data5pl apper data6pl apper fralpl apper fra2pl apper fra3pl apper fra4pl apper fra5dpl apper fra6pl 8 The ASM disks from the source database can now be seen from the service oracleasm listdisks command output In the following example ASM disks data 1 6 and fra 1 6 are from the source Dell EMC storage system ASM disks data 7 12 and fra 7 12 are from the target Dell Compellent storage system DAT DAT DAT DAT TA12 TA2 TA3 TA4 DAT DAT DAT TA5 DATA6 DATA7 TA8 TA9 FRA1 FRA10 FRA11 FRA12 service oracleasm listdisks DATA1 DATA10 DATA11 17 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems RA2 RA3 RA4 RA5 RA6 RA7 RA8 RAQ rata a yay yy 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 At this point the target database is ready to be brought up 1 Shut down the source database instances and ASM instances 2 Start up the ASM instances on the target database servers The ASM disk groups from the source database should be automatically mounted upon the ASM instance startup SQL gt select name state from vSasm_diskgroup NAM
19. migrtstl 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 Cable the Dell EMC storage front end ports to the Brocade switches in the target system as shown in Figure 6 Figure 6 Attach Dell EMC storage to the target database configuration Source Oracle RAC Database Target Oracle RAC Database racle Cluster Oracle Cluster Private Network Private Network Dell PowerEdge Dell PowerEdge 2950 Servers R720 Servers Oracle Database Migration Dell Compelient a Series 40 FC Storage Dell EMC CX3 80 FC Storage 2 Perform zoning in the Brocade switches to associate the PowerEdge R720 servers WWN s with the Dell EMC front end port WWN s 3 Install EMC NaviAgent client on both PowerEdge R720 servers and start up the NaviAgent client For example rpm Uvh naviagentcli 6 24 2 5 0 1 noarch rpm Service naviagent start 4 Create a new storage group in the Dell EMC storage manager to include the two PowerEdge R720 servers add the LUNs of the source database into the storage group Only the 6 volumes of the data area and the 6 volumes of the FRA area in Table 2 need to be added to the new storage group In the example below a new storage group called r720_CX380
20. n of disks that Oracle ASM manages as a unit Within a disk group Oracle ASM exposes a file system interface for Oracle database files The content of files that are stored in a disk group is evenly distributed to eliminate hot spots and to provide uniform performance across the disks The performance is comparable to the performance of raw devices Oracle ASM provides the disk rebalance feature where disks can be added or removed from a disk group while a database continues to access files from the disk group When adding or removing disks from a disk group Oracle ASM automatically redistributes the file contents and eliminates the need for downtime when redistributing the content The adding or removing disks from a disk group can be executed using the ALTER DISKGROUP SQL statement within the ASM instance To control the speed and resource consumption of the rebalance operation you can include the REBALANCE POWER clause in the ALTER DISKGROUP statement The REBALANCE POWER clause specifies the degree of parallelism and thus the speed of the rebalance operation It can be set to a value from 0 to 11 for Oracle database versions 11 2 0 2 or lower A value of 0 halts a rebalancing operation The default rebalance power is set by the ASM_POWER_LIMIT initialization parameter with a default value of 1 The SQL syntax to add disks into a disk group is alter diskgroup diskgroup_name add disk disk path rebalan
21. on clients is time consuming and tedious You can solve this challenge by using a variety of technologies F5 Big IP Global Traffic Manager formerly 3DNS technology Big IP Global Traffic Manager GTM provides capability to seamlessly direct application to a different data source Users are not aware of the switch CNAME A CNAME is a type of resource record in the Domain Name System DNS that specifies that the domain name is an alias of another CNAME can facilitate quick application switch over to a different database Oracle Single Client Access Name SCAN is a new Oracle RAC 119 Release 2 feature that provides a single name for clients to access Oracle databases running in a cluster The benefit is that the client s connect information does not need to change if you add or remove nodes in the cluster Migrating Data to the Target System Once the application is pointed to the target database data access can immediately resume while data is being migrated in the background from the source ASM disks to the target ASM disks Data migration with ASM disk rebalance is an online procedure that does not impact the database availability The ASM disk names and disk paths can be viewed in the ASM instance For example SQL gt select name path total_mb header status from vSasm_ disk NAME PATH TOTAL MB HEADER STATUS dev mapper data7pl 0 CANDIDATE dev mapper ocrvote5pl1 0 FOREIGN
22. on disruptively without interruption in snapshot and instant restore options all from within the storage GUI To eliminate economically disruptive transitions and premature obsolescence several features are helpful Future disk interconnects as well as SAN interconnects can be added to existing controllers The aforementioned incremental migration allows old and new resources to be effectively managed together with less hassle and less over provisioned resources than a single frame model Disks can be gracefully removed from a virtually provisioned pool without destroying the pool so that disk refreshes are easy routine and deferred until the disks are too old In this way older disks can continue to deliver performance benefits competitively even if their capacity is lower than the newer disks Compellent customers can upgrade the hardware indefinitely simply by replacing the hardware the software does not have to be re purchased This greatly reduces the budgetary hit from an upgrade To reduce wasteful over provisioning of capacity moving to Compellent built in virtualization enables thin provisioning without imposing a performance reduction To use disk performance more efficiently Compellent s space efficient snapshots come without the extra work to move old data out of the way known as copy on write Compellent has a long history of high customer adoption rates of advanced snapshot technology To reduce wasteful over provisioning of
23. on to Dell PowerEdge 12 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 The reference configuration consists of the following components e Source environment o Two Dell PowerEdge 2950 servers running Oracle Enterprise Linux 5 Update 2 OEL 5 2 x86_64 and Oracle 11g R1 RAC database version 11 1 0 7 o Redundant Dell PowerConnect Gigabit Ethernet switches for Oracle cluster interconnect private network o Server storage interconnect using redundant McData Sphereon 4400 Fibre Channel switches o Dell EMC CX3 80 Fibre Channel storage system where the physical data resides e Target environment o Two Dell PowerEdge R720 servers running Oracle Linux 5 Update 7 OL 5 7 x86_64 and Oracle 11g R1 RAC database version 11 1 0 7 o Redundant Dell PowerConnect Gigabit Ethernet switches for Oracle cluster interconnect private network o Server storage interconnect using redundant Brocade 5300 Fibre Channel switches o Dell Compellent Series 40 Fibre Channel storage system where the physical data resides Figure 1 Reference configuration of Oracle database migration Source Oracle RAC Database Target Oracle RAC Database Oracle Cluster Oracle Cluster Private Network Private Network Dell PowerE
24. rage 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 avail
25. sks The following My Oracle Support MOS note at https support oracle com provides detailed step by step instructions on how to perform the move therefore the steps are not repeated in this paper ID 428681 1 OCR Vote disk maintenance operations add remove replace move Move the Oracle data files from Dell EMC disks to Compellent disks using Oracle ASM disk rebalance 10 Remove access to Dell EMC disks from the PowerEdge servers 12 Oracle Database Migration to Dell PowerEdge 12 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 Source Oracle RAC Database Oracle Cluster Private Network Dell PowerEdge 2950 Servers McData Sphereon 4400 FC switches pg nd Move Oracle data to Dell EMC Dell Compellent CX3 80 FC Series 40 FC Storage Storage 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 Unlike the migration scenario in Figure 2 the Oracle database is migrated to a completely separated infrastructure with newer storage servers SAN switches as well as a newer release of operating systems running on the database servers The use o
26. stance without database instance on target systems using DBCA Database Configuration Assistant xi u DBCA will now create and start the ASM instance After the ASM instance is started you can create disk groups to be used as storage for your database Cancel f ASM Creation xi ASM Instance Creation Using the ASM Disk Groups page you can view and manage existing disk groups You can choose to create a new disk group or add disks to an existing disk group Available Disk Groups Select Disk Group Name Size MB Free MB Redundancy State Note Free MB reflects the free space avaiable by taking mirroring into account Create New Add Disks Mount MountAll 9 Set the ASM_DISKGROUPS parameter in the ASM instance to include the disk group names of the source database For example SQL gt ALTER SYSTEM SET asm_diskgroups DATA FRA SCOPE BOTH SID 10 Copy the database init ora files from the source database servers to the target database servers under SORACLE HOME dbs For example run the following command from the source database servers scp lt filename ora gt oracle lt target server IP gt lt target server destination gt 15 Oracle Database Migration to Dell PowerEdge 12 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 init
27. the Dell PowerEdge R720 servers WWN s with the Compellent front end ports WWN s 3 Create volume partitions on the two PowerEdge R720 servers 4 Configure DM Multipath to the volumes on the two PowerEdge R720 servers 5 Stamp the volumes as ASM disks on the two PowerEdge R720 servers Again ASM disks need to have different names as the source database or data migration does not work later The screen output of the service oracleasm listdisks command is shown below Service oracleasm listdisks DATA10 DATAI11 DATA12 DATA 7 DATA8 DATA9 FRA10 FRA11 FRA12 FRA7 FRA8 FRAY 6 Install Oracle RAC Clusterware 11 1 0 7 on the two PowerEdge R720 servers 7 Install Oracle Database 11 1 0 7 binary on the two PowerEdge R720 servers 8 Use the Oracle tool Database Configuration Assistant DBCA to create the Oracle ASM instance without creating the database instance In Oracle release 11 1 0 7 the creation of the ASM instance and the creation of the database instance are combined in the DBCA tool Once ASM 14 Oracle Database Migration to Dell PowerEdge 12 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 in
28. the source database Used for Volume Size File system ASM disk name format Oracle RAC 3 volumes of OCR 1 GB each Block device N A Clusterware disks disks 2 volumes of 1 GB each Block device N A Voting disks Oracle database 6 volumes for data 100 GB each ASM data1 data2 area data3 data4 data5 data6 6 volumes for 100 GB each ASM fra1 fra2 fra3 Flash Recovery fra4 fra5 fra6 Area FRA 1 volume for spfile 1 GB Block device N A of ASM instance Migration Options There are many different ways to migrate the Oracle database described in the above reference configuration Among them some commonly used technologies are e Oracle Data Pump Export and Import utility is a feature of the Oracle database that enables data and metadata movement between Oracle databases This method involves the exporting of the source database into export dump files presenting the dump files to the target database and then importing them into the target database This method can be slow for large systems and can incur an extended downtime during the migration process e Oracle Transportable Tablespace is an Oracle database feature to copy a set of tablespaces from one database to another This method involves exporting the metadata transporting the datafiles from the source database to the target database and then importing the datafiles to the target Oracle Database Migration to Dell PowerEdge 12 Generation
29. torage Area Network SAN provides a highly efficient and flexible foundation for enterprise and the cloud Dell Compellent storage features an innovative Dell Fluid Data architecture to put the right data in the right place at the right time It enables the storage system to dynamically adapt to changes in your business environment Dell Compellent Storage Center provides a fully virtualized storage platform that includes e Storage virtualization that abstracts and aggregates resources across the array providing a high performance pool of shared storage e Thin provisioning and automated tiered storage to deliver optimum disk utilization and intelligent data movement e Space efficient snapshots and thin replication for continuous data protection without wasted capacity e Built in automation and unified storage management to streamline storage provisioning management migration monitoring and reporting Oracle Database Migration to Dell PowerEdge 12 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 To eliminate the need for future migration projects once data is on Compellent it can be migrated to additional or future hardware incrementally easily n
30. torage front end ports to the McData switches See Figure 3 11 Oracle Database Migration to Dell PowerEdge 12 Generation Servers and Dell Compellent Storage Systems Sy oY oo e Figure 3 Attach Dell Compellent storage to the source database configuration Source Oracle RAC Database Oracle Cluster Private Network HH eH Dell PowerEdge 2950 Servers McData Sphereon 4400 FC switches a Dell EMC Dell Compellent CX3 80 FC Series 40 FC Storage Storage Create storage volumes in the Compellent storage for hosting Oracle clusterware OCR and voting disks as well as Oracle data files Perform zoning in the McData switches to associate the Dell PowerEdge 2950 servers WWN s with the Compellent front end ports WWN s Create volume partitions on the PowerEdge 2950 servers Configure Device Mapper Multipath DM Multipath to the volumes on the PowerEdge 2950 servers Stamp the volumes as ASM disks on the PowerEdge 2950 servers Convert the source Dell EMC volumes from using EMC PowerPath to DM Multipath on the PowerEdge 2950 servers This step is necessary to ensure the Dell EMC disks and Compellent disks use unified multipathing software The Dell Professional Services DPS team has developed an automation script for the conversion of EMC PowerPath to DM Multipath DPS can be engaged at www dell com services Move the Oracle RAC Clusterware OCR and voting disks from Dell EMC disks to Compellent di
31. vas veniens arts aunts erence giving EE ENA ENEE OENE gh aves ENE EE ESEE gina SEa aaa 22 Tables Table 1 Hardware and software configurations of the source and the target Oracle systems 9 Table 2 Volume configuration of the source database esssessessossscesesossssessososssesssosossses 9 Table 3 Volume configuration of the target database sesssesssesosssesesoossssesesoossssssososeses 14 Figures Figure 1 Reference configuration of Oracle database migration esssesssosossssessooosssssseoossses 8 Figure 2 Oracle ASM disk rebalance to move Oracle database to a different storage system 11 Figure 3 Attach Dell Compellent storage to the source database configuration ssssssseseseseees 12 Figure 4 Detach Dell EMC storage from the source database configuration cceeeeeeee eee ees 13 Figure 5 Create ASM instance without database instance on target systems using DBCA 15 Figure 6 Attach Dell EMC storage to the target database configuration ceeeeee scene eee ees 16 Figure 7 Create a new storage group in Dell EMC storage Managel sceeeeeeeee eee eee eee eeeees 17 iii Oracle Database Migration to Dell PowerEdge 12 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
Download Pdf Manuals
Related Search