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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
