File Architecture (contd)
Atleast two log files are required. Contains information about changes made to enable recovery. When file #1 gets filled Oracle switches to the file #2. File #1 is archived before reusing.
Checkpointing is done to ensure that all buffers are written out before switching from one log file to other.
If file #2 fills up before checkpoint completed then all activities will come to halt. This means we must increase the number of log files.