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 Oracle 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 © 1999-2024 SS64.com
Some rights reserved