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

Controls or displays information about archive logging. This command is intended for DBAs.

Keywords

LIST

Specifies that SQL*Plus is to display information about the current state of archiving.

STOP

Specifies that the automatic archiving of log files be stopped.

START

Specifies that the automatic archiving of log files be started. If TO destination is specified, all archived log files will be written to this destination.

NEXT

Specifies that the next redo log file group is to be archived manually (if it is filled). If TO destination is specified, the redo log file group will be written to this destination for this command only.

ALL

Specifies that all filled redo log file groups be archived manually. If TO destination is specified, the redo log file groups will be written to this destination for this command only.

log_sequence

Specifies that the log file group identified by log_sequence be manually archived. If TO destination is specified, the redo log file group will be written to this destination for this command only.

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.