Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fwd: RE: RAID or NOT to RAID?

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

From: <tday6_at_csc.com>
Date: Wed, 08 Aug 2001 13:37:13 -0700
Message-ID: <F001.00365075.20010808132232@fatcity.com>

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?

                                                                                       
               
                    "Denmark Weatherburne"                                             
               
                    <denmark_weatherburne_at_ho        To:     Multiple recipients of 
list ORACLE-L      
                    tmail.com>                      <ORACLE-L_at_fatcity.com>             
               
                    Sent by:                        cc:                                
               
                    root_at_fatcity.com                Subject:     Fwd: RE: RAID or NOT 
to RAID?        
                                                                                       
               
                                                                                       
               
                    08/08/2001 02:47 PM                                                
               
                    Please respond to                                                  
               
                    ORACLE-L                                                           
               
                                                                                       
               
                                                                                       
               




Hi DBA's,

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



Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
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).
Received on Wed Aug 08 2001 - 15:37:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US