White Papers

Sizing an SC Series array for Oracle
69 Dell EMC SC Series: Oracle Best Practices | CML1114
5.8 Disk drives and RAID recommendations for Oracle
Table 16 shows some permutations of disk drive types and RAID mixes for Oracle implementations. The
information is provided only for illustration and not as a set of rules that govern the actual selection of disk
drives and RAID for Oracle file types. Business needs will drive the selection and placement process.
Disk drive types and RAID recommendations
Description
RAID 10 SSD
1
RAID 10
FC/SAS 15K
1
RAID 10
FC/SAS
10K
RAID 5
FC/SAS
15K
RAID 5
FC/SAS
10K
RAID 5
FC/SAS
7.2K
All RAID
2
FC/SAS/SATA
Data files
3
Recommended
Recommended
OK
DP
4
DP
4
DP
4
DP
4
Control files
Recommended
Recommended
OK
Avoid
Avoid
Avoid
Avoid
Redo logs
Recommended
Recommended
OK
Avoid
Avoid
Avoid
Avoid
Archived
redo logs
Recommended
Recommended
OK
Not
required
Not
required
Not
required
DP
4
Flashback
recovery
5
Recommended
Recommended
OK
Not
required
Not
required
Not
required
DP
4
OCR files /
voting disks
Recommended
Recommended
OK
Avoid
Avoid
Avoid
Avoid
1
Dell EMC recommends using SSDs whenever possible for Oracle environments. In the event SSDs are not available, 15K HDDs are
recommended.
2
RAID 6 is available for 900+ GB drives.
3
Data files include: system, sysaux, data, indexes, temp, undo.
4
Use single redundancy (RAID 5) for Data Progression (DP) unless business needs justify using dual redundancy (RAID 6, or RAID 10 DM).
A Dell EMC storage architect can assist in configuring the correct redundancy for the environment.
5
Flashback recovery assumes that ASM is used. If not, flashback recovery becomes the location of database disk image backups, archived
redo logs, and other infrequently accessed Oracle database files. In a hybrid array (SSDs and HDD), place the flashback recovery area on
RAID 10 FC/SAS 15K media after performing an analysis of the array and business requirements.