Oracle-L: Re: duplexing redos and archives

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Tue, 06 Aug 2002 10:38:24 -0800
Message-ID: <F001.004AC6F0.20020806103824@fatcity.com>

FWIW, one of the best ways to kill performance is to put the redo logs and rollback segments on raid5 (or any other tablespace that is write intensive).

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro

                                                                                                                                               
                      Joseph.Armstrong-Cham                                                                                                    
                      p_at_tufts.edu                  To:       ORACLE-L_at_fatcity.com                                                              
                      Sent by:                     cc:                                                                                         
                      root_at_fatcity.com             Subject:  duplexing redos and archives                                                      
                                                                                                                                               
                                                                                                                                               
                      08/06/02 11:13 AM                                                                                                        
                      Please respond to                                                                                                        
                      ORACLE-L

Currently we are duplexing our redo logs and archive logs through oracle. We do this at the oracle level because we are using mirroring
(raid0?) and if we lose a redo log or archive file the database will not
be affected.

We will be moving to raid5 arrays in the future and are wondering whether we still need to do the duplexing. Since the arrays are made up of data disks plus a parity disk plus a hot swap do we need to worry about losing a redo log? Our sys admins are telling us we don't and I tend to agree with them but we want to get other opinions on the subject.

How are shops handling this who are using raid5?

Thanks.
Joe

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Armstrong-Champ
  INET: Joseph.Armstrong-Champ_at_tufts.edu

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: Ron Thomas
  INET: rthomas_at_hypercom.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 Tue Aug 06 2002 - 13:38:24 CDT