Migration options – Dell PowerEdge T110 II User 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