RE: redo log file setup with mirrored drives

From: Steve McClure <smcclure_at_usscript.com>
Date: Tue, 26 Nov 2002 15:05:29 -0800
Message-ID: <F001.0050CDC4.20021126150529@fatcity.com>

"While all this is true, this is all based on the forgone conclusion that mirroring outside Oracle will result in file loss. It is that conclusion with which I disagree."

I believe the forgone conclusion you are talking about is that "mirroring outside of Oracle MAY result in data loss" MAY is a very important word. The multiplexing of redo logs across multiple disks and controllers is a simple way protect your database from potential failure. It is simply irresponsible to dismiss it out of hand. Sure you might cite performance concerns, but for most databases in most enterprises redo log multiplexing does not constitute a performance bottleneck.

Your position appears to be that hardware mirroring, software mirroring, RAID hardware, and the controllers feeding them all are infallible. Multiplexing redo logs is simply a form of insurance, and should be considered a default element of Oracle database design.

Steve

--

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

Author: Steve McClure
  INET: smcclure_at_usscript.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 Tue Nov 26 2002 - 17:05:29 CST