LOG_ARCHIVE_DEST_STATE_n

Property	Description
Parameter type	String
Syntax	LOG_ARCHIVE_DEST_STATE_[1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10] = { enable | defer | alternate }
Default value	enable
Modifiable	ALTER SESSION, ALTER SYSTEM
Basic	Yes

The LOG_ARCHIVE_DEST_STATE_n parameters (where n = 1, 2, 3, ... 10) specify the availability state of the corresponding destination. The parameter suffix (1 through 10) specifies one of the ten corresponding LOG_ARCHIVE_DEST_n destination parameters.

Values:

· enable

Specifies that a valid log archive destination can be used for a subsequent archiving operation (automatic or manual). This is the default.

· defer

Specifies that valid destination information and attributes are preserved, but the destination is excluded from archiving operations until re-enabled.

· alternate

Specifies that a log archive destination is not enabled but will become enabled if communications to another destination fail.

The LOG_ARCHIVE_DEST_STATE_n parameters have no effect on the ENABLE state for the LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST parameters.

The V$ARCHIVE_DEST dynamic performance view shows values in use for the current session. The DEST_ID column of that view corresponds to the archive destination suffix n.

Note:

1.  Parameter: LOG_ARCHIVE_DEST_N

    View: V$ARCHIVE_DEST

2. 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) like 'LOG_ARCHIVE_DEST_%';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
log_archive_dest_1	location=/mydb/archivelogs	FALSE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #1 text string
log_archive_dest_2		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #2 text string
log_archive_dest_3		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #3 text string
log_archive_dest_4		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #4 text string
log_archive_dest_5		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #5 text string
log_archive_dest_6		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #6 text string
log_archive_dest_7		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #7 text string
log_archive_dest_8		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #8 text string
log_archive_dest_9		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #9 text string
log_archive_dest_10		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #10 text string
log_archive_dest_state_1	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #1 state text string
log_archive_dest_state_2	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #2 state text string
log_archive_dest_state_3	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #3 state text string
log_archive_dest_state_4	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #4 state text string
log_archive_dest_state_5	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #5 state text string
log_archive_dest_state_6	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #6 state text string
log_archive_dest_state_7	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #7 state text string
log_archive_dest_state_8	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #8 state text string
log_archive_dest_state_9	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #9 state text string
log_archive_dest_state_10	enable	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	archival destination #10 state text string

Oracle initializatoin parameters