RAID implementation standards for Oracle

From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
Date: Thu, 14 Sep 2000 17:05:41 +0200
Message-Id: <10619.116976@fatcity.com>

I'm "attempting" to put together an Oracle implementation guideline standards document for my company. One section of which related to RAID and below is what I have come up with. The document is attempting to be as generic as possible. If you have time I would appreciate feedback on same.

File Type		Acceptable RAID (best first)	Comments
----------------	----------------------------
---------------------------------------------------
Redo Logs		None
			RAID 0 (single disk array)
			RAID 1
			RAID 5				Always Mirror at

Oracle-level

Data and Index 	RAID 10				For high write capacity.
			RAID 1 				Moderate write
capacity.
			RAID 5				Moderate write,
heavy read.
			RAID 0				Best write

performance but no fault tolerance!

SYSTEM TS		RAID 10
			RAID 1 
			RAID 5
			RAID 0	

RBS			RAID 10
			RAID 1 
			RAID 5
			RAID 0	

TEMP			RAID 10				If little loss of
functionality due to loss of TEMP
			RAID 1 				and can be easily
relocated then consider RAID 0
			RAID 5
			RAID 0					

Archive Logs	RAID 5
			RAID 10				For high change

activity.

Control Files Non-specific Always mirror at Oracle-level

Oracle Software
and
Configuration
Files RAID 1

Sean :)

######   ######  ######  ###### 
#    #   #    #  #    #  #    #  Rookie
####     #    #  ######  ######  Data
#   #    #    #  #    #  #    #  Base 
#    #  #######  ######  #    #  Adminstrator
-------------------------------- ------------ 

Organon (Ireland) Ltd.
E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

The only man who never makes a mistake is the man who never does anything. Received on Thu Sep 14 2000 - 10:05:41 CDT