Choose the right RAID level for DBMS

Oracle Corp. recommends using the following RAID levels for different components of an Oracle 9 or 10 installation:

• Operating system -- RAID 1.
  Oracle suggests using RAID 1 (mirroring) for the disk holding the operating system and Oracle binary files. In the event of failure, it's much easier to restore the OS and binaries than to rebuild the volume using something like RAID 5. This cuts down the time necessary to restore the system.
• Redo log files -- RAID 1 or RAID 10.
  These files are sequential rather than random, so RAID 1 or RAID 10 (striping and mirroring) provide better performance than RAID 5 (striping with distributed parity). These files are also small enough that the higher cost of RAID 10 isn't a major factor.
• Data files -- RAID 5 or RAID 10.
  The key here is a combination of cost and ratio of reads to writes. RAID 5 is significantly less expensive than RAID 10, but because of the differences in write performance, RAID 5 extracts a performance penalty. Oracle recommends using RAID 10 if fewer than 90% of the I/O operations are reads. If more than 90% of the operations are reads, then RAID 5 is an acceptable option. Of course, because of the cost penalty associated with RAID 10 (the need for twice the disk capacity as the amount of data storage), some installations will go with RAID 5 for cost reasons and accept the performance hit.
• Archive log files -- RAID 10 or RAID
  5. Here again, RAID 10 will give better performance, but the penalty associated with RAID 5 in writing and rebuilding a failed drive may be slight enough that RAID 5 is acceptable.

Installing Oracle ...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Windows Hardware Strategies Availability in the virtualized Windows server Hardware considerations for Windows server virtualization Scaling Windows server resources for virtualization Troubleshooting your toughest Windows server crashes High-tech solutions for monitoring computer heat Server virtualization at the hardware level with Hyper-V Virtualization and 64-bit: A match made in Windows heaven How to use the g4u network-based hard disk cloning utility Multi-core processors on the desktop offer major boost When and how to migrate to a 64-bit platform Disk Drives and Disk Arrays for Windows Case Study: Building a low-cost SATA array How to use the g4u network-based hard disk cloning utility Create a script to check integrity of your server's drives Can freezing a hard drive that's crashed restore it to life? Move from PATA to SATA could complicate data recovery Use RAID to increase write performance on three-drive arrays Stop disk drive overload to increase system performance A Windows administrator's guide to Diskpart commands Use RoboCopy to copy files from crashed hard disk drives Findpart utility locates lost partitions on disk

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

databases on Windows systems is discussed in a joint white paper from Oracle, Microsoft and Dell Inc., "Deployment Guide: Oracle on Microsoft Windows and Dell PowerEdge Servers," which is available on Dell's Web site (www.Dell.com). As the title implies, the paper is specific to Dell servers, but the information is generally useful to anyone installing Oracle on Windows.