| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Raid 1 vs Raid 5 for tablespaces
For the record, I often suggest using RAID level 5 with the group size
set to 2.
:)=)
(In case you're interested, RAID level 5 with G=2 *is* RAID level 1.)
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details...
-----Original Message-----
Matthew Zito
Sent: Tuesday, August 12, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Depends on the storage array and your particular configuration. You
could
certainly create a bundle of RAID-1 luns/volumes and then create a
larger
concatenated volume across them, but you're very likely to end up with
hotspots on the first few disks. Whether that matters or not is
dependent
on your data locality and the craftiness of your storage array.
Ooooor, use the LVM to create a striped lv across the exposed RAID-1 volumes. Create a dedicated VG for your raid-1 PVs and then build some striped LVs out of them. Then take a vacation in your RV. :)
Also, be aware that many many storage arrays have limitations on the
number
of RAID groups/volumes you can create, so you could easily be shooting
yourself in the foot for the future by creating, say, 50 RAID-1 volumes
when
there's a limit of 64 raid groups on the array.
As far as RAID-5, I give all due respect and tithe to our BAARF leaders
(the
check's in the mail), but you might actually be able to do RAID-5. BUT
-
any array that can do RAID-5 but not RAID-0+1 makes me very skeptical of
the
quality of its RAID-5 implementation.
What kind of storage array is this that can't do raid 0+1?
Thanks,
Matt
-- Matthew Zito GridApp Systems Email: mzito_at_gridapp.com Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.comReceived on Tue Aug 12 2003 - 20:04:22 CDT
> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of Schauss, Peter
> Sent: Tuesday, August 12, 2003 3:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Raid 1 vs Raid 5 for tablespaces
>
>
> Our hardware people tell me that our disk array will not
> support Raid 10. Given a choice between Raid 1 or 5 for my
> tablespaces, which one is best? This is Oracle 8.1.7 on AIX
> 4.3.3. The application will have a mix of read and write activity.
>
> Thanks,
> Peter Schauss
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Schauss, Peter
> INET: peter.schauss_at_ngc.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net -- Author: Matthew Zito INET: mzito_at_gridapp.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Cary Millsap INET: cary.millsap_at_hotsos.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
 |
 |