Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

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

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

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata