Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

ARCHIVE LOG

Synopsis

The ARCHIVE LOG command controls or displays information about archive logging. You must be connected as SYSDBA or SYSOPER to use this command.

Syntax

ARCHIVE LOG { LIST
            | STOP
            | START [TO destination]
            | NEXT [TO destination]
            | ALL [TO destination]
            | log_sequence_number [TO destination]}

Parameters

LIST

Causes SQL*Plus to display information about the current state of archiving. This includes the current destination, an indication of whether automatic archiving is enabled (the ARCH process), the oldest online log sequence number, the sequence number of the next log to be archived, and the current log sequence number.

STOP

Stops log files from being automatically archived. You must manually archive redo log files as they fill; otherwise, you run the risk of the instance suspending operation because the log files have run out of space.

START

Turns on automatic archiving of redo log files.

NEXT

Manually archives the next log file group in the sequence provided that it is filled. Use ARCHIVE LOG LIST to see the sequence number of this file.

ALL

Manually archives all log file groups that have been filled but not previously archived.

log_sequence_number

Manually archives a specific log file group, provided that group is still online. Use ARCHIVE LOG LIST to find the sequence number of the oldest remaining log file group.

TO destination

Specifies a destination for archived log files. If used with ARCHIVE LOG START, this becomes the destination for all log files as they are archived. ...