Re: Help With Disk Layout

Real DBAs don't use RAID 5. Oracle already provides load balance and recovery capabilities. If you want to stripe your data tablespaces across many disks, consider RAID 3. But make sure your data and indexes are on different controllers.

Control files are so small that it should matter where you put them. Just make sure you keep three copies on three different data channels.

If you do use RAID, keep your redo logs on disks that are not RAIDed, and keep a duplexed copy of them. By using RAID to duplicate your redo logs, there is no assurance that your redo logs will be good if the RAID controller dies.

Most of the activity under $ORACLE_HOME is read-only. The alert log is written to sequentially and can be buffered.

There was a good article on Technet written in 1995 about RAID and Oracle.

My25/c.

"Sidhe" <sidhe_at_home.net> wrote in message news:39351657.93010A42_at_home.net...
> This is my first install on a RAIDed array and I could use some
> recommendations. I am planning on
> just mirroring my transaction logs (no RAID) but I've been told to make
> sure everything else is RAID
> 5. I don't like it but we've got huge amounts of mirrored write behind
> cache so that makes up for
> some of it. I know these questions are subjective but even general
> answers will be helpful to me. Anyway here are my questions...
>
> 1. Is there a problem with putting my System and Temp tablespaces on the
> same RAID 5 set along
> with one copy of my Control file?
>
> 2. If I'm using RAID 5 then is there really any reason to keep multiple
> members of my Redo Log
> Groups?
>
> 3. I will have the Oracle app itself ($ORACLE_HOME) installed on it's
> own RAID 5 set. Is there any
> problem putting one of my control files on this drive set? How heavily
> are the $ORACLE_HOME
> subdirectories really used?
>
> 4. Any further advice you may have on this subject is appreciated.
>
> Thanks in advance,
> Roger Westbrook
> Dollar General Corp
> rwestbrook_at_dollargeneral.com
> (615)855-4378
Received on Sun Jun 04 2000 - 00:00:00 CDT