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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.