Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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] ]
 [ DELAY[=minutes] ]
 [ NOREGISTER ]
 [ TEMPLATE=template] ]
 [ ALTERNATE=destination ]
 [ DEPENDENCY=destination ]
 [ MAX_FAILURE=count ]
 [ ARCH | LGWR ]
 [ SYNC | ASYNC ]
 [ AFFIRM | NOAFFIRM ]
 [ NET_TIMEOUT=seconds ]
 [ VALID_FOR=(redo_log_type,database_role) ]
 [ DB_UNIQUE_NAME ]
 [ VERIFY ]
 }
Default value There is no default value.
Modifiable Most attributes are modifiable by ALTER SESSION and ALTER SYSTEM, but some are not. See Oracle Data Guard Concepts and Administration for further information.
Basic Yes

The LOG_ARCHIVE_DEST_n initialization parameter defines up to ten (where n = 1, 2, 3, ... 10) destinations, each of which must specify either the LOCATION or the SERVICE attribute to specify where to archive the redo data. All other attributes are optional. Note that whether you are specifying the LOCATION attribute or the SERVICE attribute, it must be the first attribute supplied in the list of attributes.

If you choose not to enter any attributes, you can specify a null string by entering the following:

LOG_ARCHIVE_DEST_n=' ';

You set the attributes for the LOG_ARCHIVE_DEST_n initialization parameter to control different aspects of how redo transport services transfer redo data from a production or primary database destination to another (standby) database destination. You can query the V$ARCHIVE_DEST view to see the current attribute settings for each destination (n).

Note:

Some of the attributes for this parameter are deprecated, but are being retained for backward compatibility. See "Deprecated Attributes for LOG_ARCHIVE_DEST_n".

For every LOG_ARCHIVE_DEST_n initialization parameter that you define, you must specify a corresponding LOG_ARCHIVE_DEST_STATE_n parameter. The LOG_ARCHIVE_DEST_STATE_n (where n is an integer from 1 to 10) initialization parameter specifies whether the corresponding destination is currently enabled or disabled.

Values:

See Also:

Oracle Data Guard Concepts and Administration for detailed descriptions of all the values listed in this section

Deprecated Attributes for LOG_ARCHIVE_DEST_n

The following attributes are deprecated for the LOG_ARCHIVE_DEST_n parameter. They are retained for backward compatibility only.

Table 1-2 Deprecated Attributes on the LOG_ARCHIVE_DEST_n Initialization Parameter

Deprecated Attribute Alternative

NOALTERNATIVE

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.

NODB_UNIQUE_NAME

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.

NODELAY

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.

NODEPENDENCY

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.

NOMAX_FAILURE

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.

NONET_TIMEOUT

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.

QUOTA_SIZE and NOQUOTA_SIZE

Use the flash recovery area (see Oracle Database Backup and Recovery Basics).

QUOTA_USED and NOQUOTA_USED

Use the flash recovery area (see Oracle Database Backup and Recovery Basics).

REGISTER=filename

Use the TEMPLATE=filename attribute.

NOREOPEN

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.

NOTEMPLATE

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.

NOVERIFY

None. Respecify LOG_ARCHIVE_DEST_n with the desired attributes.


In addition, note the following changes to the ASYNC and SYNC attributes: