Switching a Log File

When a log switch occurs, the log writer (LGWR) process stops writing to the current online redo log group and starts writing to the next available redo log group. After a log switch, the current online redo log group becomes inactive, and the next available online redo log group becomes the current online redo log group.

You can force a log switch to make the current redo group inactive and available for redo log maintenance operations. Forcing a log switch is useful in configurations with large redo log files that take a long time to fill. For example, you might want to:

• Drop the current redo group, but are not able to do so until the group is inactive

• Archive the current online redo log group members immediately, even though they are not yet completely filled

To switch a log file:

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. At the top of the page, click Server to view the Server subpage.

3. In the Storage section, click Redo Log Groups.

   The Redo Log Groups page appears.

4. In the Actions list, select Switch logfile, and then click Go.

   A confirmation message appears. The status of the group that had been Current changes to Active, and the status of the next group in the list changes from Inactive to Current.