RelationalDBDesign RelationalDBDesign


Recovery File Structures   «Prev 

Using 2 redo log file groups

multiplex redo logs
multiplex redo logs
  1. g1_loga.ora:This is member 1 of group 1 stored on disk 1.
  2. g1_logb.ora:This is member 2 of group 1 stored on disk 2.
  3. g2_loga.ora:This is member 1 of group 2 stored on disk 1.
  4. g2_loga.ora:This is member 2 of group 2 stored on disk 2.
  5. LGWR:LGWR will write to members 1 & 2 of group 1. When a switch occurs, LGWR will write to members 1 & 2 of group 2.
  6. disk 1:If disk 1 fails, LGWR will continue writing to disk 2 without database failure.
  7. disk 2:If disk 2 fails, LGWR will continue writing to disk 1 without database failure.
  8. redo group 1:There must be at least 2 members of the same size in each group. Each group should contain the same number of members.
  9. redo group 2:There must be at least 2 members of the same size in each group. Each group should contain the same number of members.