Minimum size permitted for redo log file - Oracle Redo Log

Discussion

• Nirja Shah   -Posted on 24 Sep 15
  - When setting the size of redo log files, consider whether you will be archiving the redo log.
  
  - Redo log files should be sized so that a filled group can be archived to a single unit of offline storage media (such as a tape or disk), with the least amount of space on the medium left unused.
  
  - For example, suppose only one filled redo log group can fit on a tape and 49% of the tape storage capacity remains unused.
  
  - In this case, it is better to decrease the size of the redo log files slightly, so that two log groups could be archived on each tape.
  
  - All members of the same multiplexed redo log group must be the same size.
  
  - Members of different groups can have different sizes.
  
  - However, there is no advantage in varying file size between groups.
  
  - If checkpoints are not set to occur between log switches, make all groups the same size to guarantee that checkpoints occur at regular intervals.
  
  - The minimum size permitted for a redo log file is 4 MB.

➨ Post your comment / Share knowledge