Mirroring redo log groups or not ?

From: Crisler, Jon <Jon.Crisler_at_usi.com>
Date: Tue, 7 Apr 2009 12:16:42 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB0675041A7B79_at_mds3aex08.USIEXCHANGE.COM>

I am dealing with a possible performance issue with "redo log sync wait". This is for 10g on Linux 64. In troubleshooting this problem, one of the things I did was to cut down the redo logs so that there is only 1 member per group rather than 2 (i.e. redo log mirroring). Each member goes to a different LUN, and the LUN's are Raid-5.  

Here is the layout-  

LUN 1 is 1 TB approx, Raid-5 used for database files

LUN 2 is 500 gb Raid 5 used for RMAN backups to disk,

LUN 3 is 500 gb Raid 5 used for archive log destination  

All are SAN connected via 2 - 4gb Qlogic HBA's with multipath.  

Now, currently online redo logs are going to Lun 2 for the first member and Lun 3 for the second. So there is going to be a little bit of contention when archiving, but whichever LUN I point to is going to encountered contention. It would be very difficult to add more LUN's due to SAN restrictions, but I have the option of converting either LUN 2 or 3 to Raid 1 / 0. If I converted to Raid 1/0 I could point one or both members to this LUN. There appears to be some performance difference with our hardware between Raid 1 and Raid 5, but not a great deal in actual testing.  

So, if the LUN that holds the online redo logs is already protected (raid 1, 5 etc) do I really need to mirror the online redo logs ? Should I convert the LUN to Raid 1 / 0 ? if I convert to Raid 1/ 0 should I keep redo log mirroring and point to the same LUN ?

Received on Tue Apr 07 2009 - 11:16:42 CDT

Original text of this message