Oracle-L: RE: redo log file setup with mirrored drives

From: Deshpande, Kirti <kirti.deshpande_at_Verizon.com>
Date: Mon, 25 Nov 2002 20:43:46 -0800
Message-ID: <F001.0050B9E2.20021125204346@fatcity.com>

Having multiple redo log members has its advantages. The archiver process 'knows' these multiple members and it will optimize the archiving process, but it does not know about the mirrored copies of these logs. The other important thing to know is that Oracle issues a separate write for these log members and in an unlikely event a corrupted write will be restricted to just the affected member. Such corruption will affect all the mirrored copies.

Kirti

-----Original Message-----
Sent: Monday, November 25, 2002 7:54 PM
To: Multiple recipients of list ORACLE-L

Hi:

We have oracle 8173 running on Sun Solaris box. The current redo files are:

/oracle/oradata/RPT1/redo101.log
/oracle/oradata/RPT1/redo201.log
/oracle/oradata/RPT1/redo301.log
/oracle/u01/oradata/RPT1/redo102.log
/oracle/u01/oradata/RPT1/redo202.log
/oracle/u01/oradata/RPT1/redo302.log

The members of the same group are in different disks. Now we are going to set up new disks soon and they are mirrored drives (the sys admin told me). Because they are already mirrored, can I just create ONE redo member for each group (instead of two) in the new setup? Is there any "danger" to do that?

TIA. Guang

MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guang Mei
  INET: zlmei_at_hotmail.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.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_Verizon.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 Mon Nov 25 2002 - 22:43:46 CST