Re: Recommended RAID Setup

This is impossible to determine without doing some I/O analysis on the system. The "ideal" setup for a DSS system could be horrible for OLTP. Even an "ideal" setup for one OLTP system could be horrible for another!

Two rather general and universal comments may apply though:

1. If there is any significant update|delete|insert performance-critical activity on the database, the redo logs should not be on RAID5. The write penalty of RAID5 is high and redo I/O is intensely write.
2. The disk with archive should not be used for datafiles since if that disk is lost, the datafiles are lost and so is the ability to recover.

The important thing about Loney's examples is not to take them as gospel, it is to understand the reasoning behind the decisions and apply similar reasoning to your own situations. With 21 disks, I would probably never use the exact layout in the book. The examples don't even mention some significant options - like striping. This is not to fault the examples though, for the reasons stated earlier. There are very few canned answers in this business. Understanding is infinitely more valuable than "knowledge".

-Don Granaman
[OraSaurus - Honk if you remember UFI!]

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 17, 2001 7:05 AM

>
> Hi,
>
> I would like to ask everybody's opinion regarding the ideal setup
for an
> NT setup to reside in a machine with 7x18GB disk and its
corresponding
> RAID setup. I was able to see one of the recommendations for 5 disks
setup
> but unfortunately it did not mention on how the RAID setup will be
done.
> Btw, I will use software instead of hardware RAID.
>
>
> DISK 1 DISK 2
> DISK 3
> Executables Data files Index data files
> Redo logs Temporary user data files Control file copy
> SYSTEM tablespace data files Control file copy
> Control file copy
>
> DISK 4 DISK 5
> Rollback segment data files Archive log files
> Export files
>
> Thanks in advance!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: granaman_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).