Mirroring redo log groups or not ?

  • From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 7 Apr 2009 12:16:42 -0400

I am dealing with a possible performance issue with "redo log sync
wait".    This is for 10g 10.2.0.4 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 ?   

Other related posts: