Friday, October 17, 2008

LOG_ARCHIVE_DUPLEX_DEST

Property

Description

Parameter type

String

Syntax

LOG_ARCHIVE_DUPLEX_DEST = filespec

Default value

There is no default value.

Modifiable

ALTER SYSTEM

Range of values

Either a null string or any valid path or device name, except raw partitions

Basic

No

Note:

1. If you are using Oracle Enterprise Edition, this parameter is deprecated in favor of the LOG_ARCHIVE_DEST_n parameters. If Oracle Enterprise Edition is not installed or it is installed but you have not specified any LOG_ARCHIVE_DEST_n parameters, this parameter is valid.

LOG_ARCHIVE_DUPLEX_DEST is similar to the initialization parameter LOG_ARCHIVE_DEST. This parameter specifies a second archive destination: the duplex archive destination. This duplex archive destination can be either a must-succeed or a best-effort archive destination, depending on how many archive destinations must succeed (as specified in the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter).

The default setting of a null string ("") or (' ') indicates that a duplex archive destination does not exist.

2. Related:
  Parameter:LOG_ARCHIVE_MIN_SUCCEED_DEST
  Parameter:LOG_ARCHIVE_DEST_N
  View:V$ARCHIVE_DEST

3. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LOG_ARCHIVE_DUPLEX_DEST’;

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

log_archive_duplex_dest

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

duplex archival destination

text string

No comments:

Post a Comment