RE: Question concerning RAID0+1 and redo logs.

From: Mohan, Ross <Ross.Mohan_at_PictureVision.com>
Date: Mon, 16 Oct 2000 14:39:35 -0400
Message-Id: <10651.119369@fatcity.com>

and the punchline is............

....you can afford to "lose" ALOT more disks under 1+0 than you can under 0+1.

( and for you "disk in single point of failure" fans, yes, oddly enough, even though the disks are a "single point of failure, you can lose up to almost HALF of them and keep on ticking! )

hth

Ross Mohan

-----Original Message-----

From: Jeffery Stevenson [mailto:jeff_at_mpv.com] Sent: Monday, October 16, 2000 1:56 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Question concerning RAID0+1 and redo logs.

With 1+0 you mirror every disk with another disk and then stripe all of the mirrored disk sets together (mirror first then stripe). With 0+1, you create sets of striped disks and then you use one striped set at the mirror for the other (stripe first then mirror).

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----

Martin
Sent: Monday, October 16, 2000 12:36 PM
To: Multiple recipients of list ORACLE-L

Okay, I have to ask. What is the distinction between 0+1 and 1+0? To be honest, I didn't know there was a difference.

Thanks.
-km

-----Original Message-----

Sent: Monday, October 16, 2000 12:10 PM
To: Multiple recipients of list ORACLE-L

I'd get 2 mirrored and dedicated disks not on the RAID array, (maybe in the host cabinet). They don't need to be raw but redo's are the best candidates for raw if you need the performance boost. Also, as pointed out by Gaja Krishna Vaidyanatha at OOW, you want RAID1+0 not RAID0+1.

Steve Orr

-----Original Message-----

(CGI)
Sent: Friday, October 13, 2000 3:06 PM
To: Multiple recipients of list ORACLE-L

We are in the process of installing new disks and upgrading our software and I was looking for some opinions and/or facts. We are upgrading to AIX 4.3.3 and Oracle 8.1.6 on a basically OLTP system. We will also be adding SSA disks with a RAID0+1 configuration.

My questions are :
In RAID5 it is recomended to put the redo logs on raw devices, now with RAID0+1 should I do this?

Is the performance or RAID0+1 good enough so as not to effect my redo logs?

Are there any other files (ie, : rbs,archive logs,temp, etc) that I should consider not putting on RAID0+1 also,

that is if the concensus is to leave them off?

More questions to come.

Thanks
Chris Sarka
Oracle DBA
CGI pour SLVQ
* (514)761-3619
* chris.sarka_at_slvq.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sarka Chris (CGI)
INET: Chris.Sarka_at_slvq.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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steve Orr
INET: sorr_at_arzoo.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: Kevin Martin
INET: kevin.martin_at_catapultsystems.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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jeffery Stevenson
INET: jeff_at_mpv.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 Received on Mon Oct 16 2000 - 13:39:35 CDT