Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

LOG_ARCHIVE_DEST_n

Property Description
Parameter type String
Syntax LOG_ARCHIVE_DEST_[1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10] =
{ 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 ]
 }
Default value There is no default value.
Modifiable ALTER SESSION, ALTER SYSTEM
Basic Yes


Note:

This parameter is valid only if you have installed the Oracle Enterprise Edition. You may continue to use LOG_ARCHIVE_DEST if you have installed the 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, ... 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:

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.