beautypg.com

Migration options – Dell PowerEdge T110 II User Manual

Page 9

background image

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