Oracle in a Nutshell

Name

LOG_ARCHIVE_DEST_n

Synopsis

Value: see description

Default: none

Dynamic: ALTER SYSTEM, ALTER SESSION

Specifies up to 10 archived log destinations. This parameter is valid for only the Oracle8i or Oracle9i Enterprise Edition. If you use this parameter, you must not also use LOG_ARCHIVE_DEST.

Syntax

LOG_ARCHIVE_DEST_n = ((SERVICE = service | LOCATION = location)
        [AFFIRM | NOAFFIRM]
        [ALTERNATE = destination | NOALTERNATE]
        [ARCH | LGWR]
        [DELAY[= minutes] | NODELAY]
        [DEPENDENCY = destination | NODEPENDENCY]
        [MANDATORY | OPTIONAL]
        [MAX_FAILURE = count | NOMAX_FAILURE]
        [QUOTA_SIZE = blocks | NOQUOTA_SIZE]
        [QUOTA_USED = blocks | NOQUOTA_USED]
        [REGISTER | NOREGISTER]
        [REOPEN=seconds | NOREOPEN]
        [SYNC | ASYNC=blocks])

Keywords

n

Number from 1 to 10 that identifies the destination.

SERVICE=service

Specifies the name of a network service used to transmit the archived log file to a standby instance.

LOCATION=location

Specifies a local filesystem destination. At least one location must be specified.

MANDATORY

Specifies that archiving to the destination must succeed before the redo log file can be reused.

OPTIONAL

Specifies that successful archiving to the destination is not required before the redo log file can be reused. This is the default.

REOPEN=seconds

Specifies the number of seconds that must pass before the destination can be used for archiving after an error. The default is 300 seconds.