LOG_ARCHIVE_DEST_n

{ null_string |
 { LOCATION=path_name | SERVICE=service_name }
 [ { MANDATORY | OPTIONAL } ]
 [ REOPEN[=seconds] | NOREOPEN ]
 [ DELAY[=minutes] | NODELAY ]
 [ REGISTER[=template] | NOREGISTER ]
 [ TEMPLATE=template] | NOTEMPLATE ]
 [ ALTERNATE=destination | NOALTERNATE ]
 [ DEPENDENCY=destination | NODEPENDENCY ]
 [ MAX_FAILURE=count | NOMAX_FAILURE ]
 [ QUOTA_SIZE=blocks | NOQUOTA_SIZE ]
 [ QUOTA_USED=blocks | NOQUOTA_USED ]
 [ ARCH | LGWR ]
 [ SYNC[=PARALLEL|NOPARALLEL] | ASYNC[=blocks] ]
 [ AFFIRM | NOAFFIRM ]
 [ NET_TIMEOUT=seconds | NONET_TIMEOUT ]
 [ VALID_FOR=(redo_log_type,database_role) ]
 [ DB_UNIQUE_NAME | NODB_UNIQUE_NAME ]
 [ VERIFY | NOVERIFY ]
 }

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

Values:

• SERVICE

  Specifies a standby destination. Oracle Net (IPC or TCP) transmits the archivelog. A standby instance must be associated with the destination. The value represented by 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 log file 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," set with LOG_ARCHIVE_MIN_SUCCEED_DEST, is met, the redo logfile is marked for reuse. This is the default.

• REOPEN

  Specifies the minimum number of seconds before the archiver process (ARCn, foreground, or log writer process) should try again to access a previously failed destination. Future attempts are made when the next redo log file is archived. If a destination is MANDATORY, then Oracle recommends that you specify a REOPEN time that reduces the possibility of primary database shutdown due to lack of available online redo log files.

  If you do not specify seconds, then the default value is 300 seconds.

It is recommended that the destination be explicitely enabled once it is dynamically set. For example, after defining a LOG_ARCHIVE_DEST_n parameter, an ALTER [ SESSION | SYSTEM ] SET LOG_ARCHIVE_DEST_STATE_n statement should be issued to properly enable the destination.