Log Mode
Use
By setting the Log Mode you can decide how the log entries are backed up:
-
Simple
-
Mirrored
Mirrored Log Areas
The advantage of this configuration is that the system can continue operating even if one log area is temporarily out of action, and this log area can be reincorporated into the system while the system is running.
Single Log Area
If you are using hardware-based RAID-5 or RAID-1 systems, you can use a simple log area, as these systems provide adequate operating backups for productive operation. Accesses to the log volume greatly influence the performance of the system as a whole. For this reason, please ensure when you choose your RAID system that it has a high data throughput.
Only one log area is configured in this case. Back up this log area regularly.
More Information
Database System Concepts, Logging Data Changes