Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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.

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 Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page