Question

If you have two redo log groups with four members each, what’s the optimal number of disks you need to provide appropriate protection on the redo log files?
A. Eight

B. Four

C. Two

D. One

E. Operating system dependent

Answer 1

Answer is B: Four

It is best practice to place members of a group on a multiplexed redo log on different physical disks. For instance, if you have two groups of multiplexed redo log members, make sure to place each member on a different disk. This practice helps avoid contention between LGWR and ARCN. In this case, however, we have two redo log groups with four members each. Instead of having one member on each group disk, it is recommended that we have two members in each group. This will total up to four disks in total