How would you layout the files?
Date: Mon, 8 Dec 2008 14:51:05 -0700
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,