ARCHIVE LOG
The ARCHIVE LOG command is used to control, or display information about, archive logging. It’s discussed in Chapter 10 and may be used to start archiving, stop archiving, manually archive one or more log files, or display information about the current archive log state. You must be connected as SYSDBA, SYSOPER, or INTERNAL in order to use this command.
ARCHIVE LOG {LIST
|STOP
|START [TO destination]
|NEXT [TO destination]
|ALL [TO destination]
|log_sequence_number [TO destination]}where:
- ARCHIVE LOG
Is the command.
- LIST
Causes SQL*Plus to display information about the current state of archiving. This includes the current destination, an indication of whether or not 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 logs 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 ...