Dell PowerEdge T110 II - Manual (Page 9)

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 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
switches Brocade 5300 FC 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 the source 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 volumes of
Voting disks 1 GB each Block device N/A
Oracle database 6 volumes for data
area 100 GB each ASM data1; data2;
data3; data4;
data5; data6
6 volumes for
Flash Recovery
Area (FRA) 100 GB each ASM fra1; fra2; fra3;
fra4; fra5; fra6
1 volume for spfile
of ASM instance 1 GB Block device N/A
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:
 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.
 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