Redo Logs - Raid 1 or No Raid

From: Dave Phillips <dphillips_at_gasper-corp.com>
Date: Fri, 15 Aug 2003 07:49:29 -0800
Message-ID: <F001.005CAEC3.20030815074929@fatcity.com>

Hello all

Oracle 8.1.7
Windoze 2000
Archive Mode - OLTP System

Which do you think is a better set up for the Redo Logs:  2 Groups on 2 Raid1 or 4 Groups on 4 separate non-raid disks? Granted you gain fault tolerance with the mirriored pair, but is that really needed if you multiplex group members over 4 different disks? As usual we are working with clients that have limited number of disks to work, so 4 Raid1's is not an option ;)

Does anyone have multiple log groups on the same physical drive(s). For example, 4 log groups, 2 members each, with group 1&3 on drive A, and 2&4 on drive B? Does this really gain you anything?

Any ideas and comments are welcome. Thanks for all the help.

David Phillips
Support DBA

--

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

Author: Dave Phillips
  INET: dphillips_at_gasper-corp.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). Received on Fri Aug 15 2003 - 10:49:29 CDT