RE: How would you layout the files?

  • From: "Michael Fontana" <mfontana@xxxxxxxxxxx>
  • To: <moabrivers@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 8 Dec 2008 15:57:56 -0600 (CST)

Being that this appears to be a 2002 solution, it's not so bad.  I would
look at your OFA guidelines for disk placement in an 8i administrators
guide.  You're going to want to keep the redo away from the datafiles, and
make sure you have multiple copies of same.  Do all that and then pray you
don't have a significant hardware failure, all the while, having good
recovery procedures in place with measurably tested results;  inform the
client as to expectations along those lines, as well as performance, and
you'll be fine.





From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Brian
Sent: Monday, December 08, 2008 3:51 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: How would you layout the files?


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,


Other related posts: