ARCHIVE Clause

Make changes to Archive Log mode - called by ALTER SYSTEM.

Syntax:

   ARCHIVE LOG [THREAD int] options

options:
The options used with this command can be either

    STOP

OR any combination of the following

    START
    ALL
    NEXT
    SEQUENCE int
    CHANGE int
    CURRENT
    GROUP int
    LOGFILE 'filename'
    TO 'location'

Related Commands:

Starting ARCHIVELOG mode
ALTER SYSTEM ARCHIVE LOG STOP
ALTER SYSTEM ARCHIVE LOG START
These commands start/stop auto archiving (equivalent to init.ora: LOG_ARCHIVE_START=TRUE)

Related Views:

V$ARCHIVE
V$ARCHIVED_LOG
V$ARCHIVE_DEST
V$ARCHIVE_PROCESSES


© Copyright SS64.com 1999-2014
Some rights reserved