Re: Fwd: RE: RAID or NOT to RAID?

In a previous job I had to deal with this issue. WinNT 4.0 on a dual
processor Dell box with 24G of RAID. I had specified RAID 0 + 1 but
"someone" knew better and got it with RAID 5 (5 is obviously better than
0). The SA wouldn't or couldn't reconfigure and the job needed to get
done.

It was for a decision support system (basically read-only) and it may be
that sort of a system is less impacted. I abandoned any thought of OFA.
Just stick all the datafiles out on one directory branch (makes cold
backups easier) and let the RAID sort out the contention.

I didn't like it because I was basically trusting to someone else's
decisions but performance was adequate and the task was successful. I'm
not sure that this would be true with an OLTP system.

I've seen the notation RAID 10 (which is RAID 0 + 1). Perhaps we should
standardize on that. Obviously RAID 10 has to be twice as good as RAID 5.
Right?

I hope I'm not opening a can of worms, but I'd like your feedback on the
issue of using RAID 5 on NT 4.0 with Oracle 8.0.5.
I have worked with Solaris and RDBMS before switching to this job using the
NT platform. So I'm having to adjust and revisit the issues that was of
concern on the unix platform.
The NT and RAID configuration does not allow you to locate your datafiles
and logs on seperate specific disks. Also I don't know if the use of raw
devices on NT is possible if RAID 5 is enabled.
I've read about the performance loss inherent with RAID 5 because of the
writes to the parity disk.
I'd like to find out more about these issues and how you all are dealing
with them on the NT 4.0 platform?

Thanks in advance for your time.

Regards,

"Knowledge is power, but it is only useful if it is shared!"

>From: Paula_Stankus_at_doh.state.fl.us>To: "LazyDBA.com Discussion" <oracledba_at_lazydba.com>>Subject: RE: RAID or NOT to RAID?>Date: Tue, 7 Aug 2001 13:22:48 -0400>>Can you forward me the info. you received on this? I am wondering about>the>issue as well - esp. as regards threads.>>-----Original Message----->From: Michael Porter [mailto:MPorter_at_pgahq.com]>Sent: Tuesday, August 07, 2001 8:33 AM>To: LazyDBA.com Discussion>Subject: RAID or NOT to RAID?>>>I don't want to start the proverbial war over RAID use in general but, I
am
>seriously considering using RAID-10 (stripping + mirroring) for an Oracle>11.x application (AIX 4.3.3 and at least 8.0.5.2.1 db). IF I have several>(more than 2) RAID10's and put redo on non raid volumes am I likely to get>nearly as good performance with this as opposed to just straight mirroring>OR individual volumes, possible stripped?>>Any points to other documentation or threads would be appreciated.>>Thanks,>>Mike>>>-------->Oracle documentation is here:>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage>To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com>To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl>Tell yer mates about http://www.farAwayJobs.com>By using this list you agree to these>terms:http://www.lazydba.com/legal.html

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denmark Weatherburne
INET: denmark_weatherburne_at_hotmail.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: tday6_at_csc.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).