Re: How would you layout the files?

From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 8 Dec 2008 14:35:36 -0800
Message-ID: <a9c093440812081435q5651f8a4qb60f318034e6fe60@mail.gmail.com>


SAME - stripe and mirror everything.

Redo and Data should be fine together. In fact, with only 4 spindles available for the db, I wouldn't have it any other way. RAID-10 the 4 drives and mount it up as a single volume. Pray for the best.

The problem that people create by separating redo, is they limit the number of spindles and thus reduce the IOPS that can be supported. While often one spindle is enough for space, it is rarely enough in terms of performance (IOPS).

On Mon, Dec 8, 2008 at 1:57 PM, Michael Fontana <mfontana_at_enkitec.com> wrote:
> 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.

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 08 2008 - 16:35:36 CST

Original text of this message