Initialization Parameters, 80 of 188

LOG_ARCHIVE_DEST_n

Parameter type
String

Syntax:
LOG_ARCHIVE_DEST_[1 | 2 | 3 | 4 | 5] =
"null_string" |
((SERVICE=tnsnames_service
| LOCATION=local_pathname)
[MANDATORY | OPTIONAL]
[REOPEN[=integer]] )

Parameter class:
Dynamic. Scope = ALTER SYSTEM, ALTER SESSION.

Default value:
None

Range of values:
Valid keyword definitions (see syntax below)

Note: This parameter is valid only if you have installed Oracle Enterprise Edition. You may continue to use LOG_ARCHIVE_DEST if you have installed Oracle Enterprise Edition. However, you cannot use both LOG_ARCHIVE_DEST_n and LOG_ARCHIVE_DEST, as they are not compatible.

The LOG_ARCHIVE_DEST_n parameters (where n = 1,2,3,4,5) define up to five archive log destinations. The parameter integer suffix is defined as the handle displayed by the V$ARCHIVE_DEST dynamic performance view.

SERVICE specifies a standby destination. Net8 (IPC or TCP) transmits the archivelog. A standby instance must be associated with the destination. tnsnames_service corresponds to an appropriate service-name in TNSNAMES.ORA.

LOCATION specifies a local file-system destination. You must specify this parameter for at least one destination.

MANDATORY specifies that archiving to the destination must succeed before the REDO logfile can be made available for reuse.

OPTIONAL specifies that successful archiving to the destination is not required before the REDO log file can be made available for reuse. If the "must succeed count" (LOG_ARCHIVE_MIN_SUCCEED_DEST) is met, the REDO logfile is marked for reuse. This is the default.

REOPEN specifies an interval of time (in seconds) that must pass after an error has been encountered during archiving to the destination before future archives to the destination can be attempted. Future attempts are made when the next REDO logfile is archived. If a destination is MANDATORY, Oracle Corporation recommends that you specify a REOPEN time that reduces the possibility of primary database shutdown due to lack of available online REDO logfiles.

If you do not specify integer, the default value is 300 seconds. If you do not specify REOPEN, the archiver process will never reopen a destination after an error.

See Also: Oracle8i Backup and Recovery Guide and Oracle8i Administrator's Guide for more information and examples.

Parameter type	String
Syntax:	`LOG_ARCHIVE_DEST_[1 \| 2 \| 3 \| 4 \| 5] =` `"null_string" \|` `((SERVICE=tnsnames_service` `\| LOCATION=local_pathname)` `[MANDATORY \| OPTIONAL]` `[REOPEN[=integer]] )`
Parameter class:	Dynamic. Scope = `ALTER SYSTEM, ALTER SESSION.`
Default value:	None
Range of values:	Valid keyword definitions (see syntax below)
Note: This parameter is valid only if you have installed Oracle Enterprise Edition. You may continue to use `LOG_ARCHIVE_DEST` if you have installed Oracle Enterprise Edition. However, you cannot use both `LOG_ARCHIVE_DEST_`n and `LOG_ARCHIVE_DEST`, as they are not compatible.
`The LOG_ARCHIVE_DEST_`n parameters (where `n` = 1,2,3,4,5) define up to five archive log destinations. The parameter integer suffix is defined as the handle displayed by the `V$ARCHIVE_DEST` dynamic performance view.
`SERVICE` specifies a standby destination. Net8 (IPC or TCP) transmits the archivelog. A standby instance must be associated with the destination. `tnsnames_service` corresponds to an appropriate service-name in `TNSNAMES.ORA`. `LOCATION` specifies a local file-system destination. You must specify this parameter for at least one destination. `MANDATORY` specifies that archiving to the destination must succeed before the REDO logfile can be made available for reuse. `OPTIONAL` specifies that successful archiving to the destination is not required before the REDO log file can be made available for reuse. If the "must succeed count" (`LOG_ARCHIVE_MIN_SUCCEED_DEST`) is met, the REDO logfile is marked for reuse. This is the default. REOPEN specifies an interval of time (in seconds) that must pass after an error has been encountered during archiving to the destination before future archives to the destination can be attempted. Future attempts are made when the next REDO logfile is archived. If a destination is `MANDATORY`, Oracle Corporation recommends that you specify a `REOPEN` time that reduces the possibility of primary database shutdown due to lack of available online REDO logfiles. If you do not specify integer, the default value is 300 seconds. If you do not specify `REOPEN`, the archiver process will never reopen a destination after an error.
See Also: Oracle8i Backup and Recovery Guide and Oracle8i Administrator's Guide for more information and examples.