log file switch (archiving needed)

Waiting for a log switch because the log that the LGWR will be switching into has not been archived yet. Check the alert file to make sure that archiving has not stopped due to a failed archive write. To speed archiving, consider adding more archive processes or putting the archive files on striped disks.

Excessing waits for this wait indicates that the ARCH process is not keeping up with LGWR writing to redo log files. When operating the database in archive log mode, the LGWR process cannot overwrite, or switch to, the redo log file until ARCH process has archived it by copying it to the archived log file destination. A failed write to the archive log file destination may stop the archiving process. Such an error will be reported in the alert log file. Parameters:

• P1 = Not used
• P2 = Not used
• P3 = Not used

Wait Time:

1 second