RE: How would you layout the files?

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Mon, 8 Dec 2008 15:52:02 -0700
Message-ID: <89FD2C8D7D551D4598EF20C7E42FEB457E4E8B@earthquake.ICAT.COM>

Just re-read the original post. Hey - if everything can fit in 300gb - I don't see why RAID10 wouldn't be viable as well....if not actually preferred.  

-joe

---

From: Sweetser, Joe
Sent: Monday, December 08, 2008 3:49 PM
To: 'andrew.kerber_at_gmail.com'; moabrivers_at_gmail.com Cc: oracle-l_at_freelists.org
Subject: RE: How would you layout the files?

Personally, I would auto-delete myself and go with RAID5. We are all know it's not ideal but given the situation I'd say it's better "nothing". It doesn't sound like you're talking about a terribly busy database so the performance impact might be worth it. Do you at least have the luxury of testing different configurations? Hopefully, the client would at least understand that. I wouldn't get so focused on performance in this scenario that you don't use any of the storage tools/options/whatevers available. After all, oracle databases do run on RAID5, you know. But I would be sure to stick a controlfile copy on the OS disks!  

running for cover before I get baarfed on :-) ,
-joe
   

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: Monday, December 08, 2008 3:07 PM
To: moabrivers_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: How would you layout the files?

I would say you are back to the old fashioned options. Dont raid the remaining drives, you dont have enough drives for that. Mirror the redo, control files, and archive logs, then distrbute everything else the best you can. Put the undo on drive that otherwise has very little activity

On Mon, Dec 8, 2008 at 3:51 PM, Brian <moabrivers_at_gmail.com> wrote:

        Say you have a client that for political reasons only bought 1 single server with 6 internal disks (the first 2 of which are RAID-1'd for the OS). Because you cannot apply any reasonable sense that the client should really look for better server/storage options (i.e., change the client's mind), how would you install Oracle 10g Enterprise Release 2? The underlying OS is Windows 2003 Enterprise Server 64-bit and the hardware is Dell PowerEdge 2950 with 8GB RAM. The disks are 15K 160GB disks. The actual db size is 100GB with about 100 end users and a peak redo rate of less than 100K/second. Again, you cannot tell the client to purchase new storage or a better server. So working with what

you have, how would you RAID the remaining disks and layout the Oracle
binaries, controlfiles, redo logs, archive logs (yes, archiving will be
enabled), and datafiles?  RAID options to RAID-10 are available. Emails

offering RAID-5 solutions will be auto-deleted. :)

	Looking forward to the discussion,
	Brian

--

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 08 2008 - 16:52:02 CST