Re: LOG_ARCHIVE

From: Slawomir Cichy <slawas_at_wp-sa.pl>
Date: Tue, 15 Jan 2002 16:26:17 +0100
Message-ID: <3C444A19.7060205@wp-sa.pl>

Hi
First - Sample clause in init<SID>.ora:

log_archive_start     = TRUE
log_archive_min_succeed_dest    = 1
log_archive_dest_1    = 'LOCATION=/redologi MANDATORY REOPEN=5'
log_archive_dest_2    = 'SERVICE=STANDB.WORLD OPTIONAL REOPEN=120'
log_archive_dest_state_1        = enable
log_archive_dest_state_2        = enable
log_archive_format              = ORAWP01%S.arc

Second - In documentation you have read:

LOG_ARCHIVE_DEST_n

Parameter type 		String
Syntax: 		LOG_ARCHIVE_DEST_[1 | 2 | 3 | 4 | 5] = "null_string" |

((SERVICE=tnsnames_service | LOCATION=local_pathname) [MANDATORY | OPTIONAL] [REOPEN[=integer]] )

Parameter class: 	Dynamic. Scope = ALTER SYSTEM, ALTER SESSION.
Default value:  	None
Range of values: 	Valid keyword definitions (see syntax below)

Note: This parameter is valid only if you have installed Oracle Enterprise Edition. You may continue to use LOG_ARCHIVE_DEST if you have installed 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,4,5) define up to five archive log destinations. The parameter integer suffix is defined as the handle displayed by the V$ARCHIVE_DEST dynamic performance view.

SERVICE specifies a standby destination. Net8 (IPC or TCP) transmits the archivelog. A standby instance must be associated with the destination. 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 logfile 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" (LOG_ARCHIVE_MIN_SUCCEED_DEST) is met, the REDO logfile is marked for reuse. This is the default.
REOPEN specifies an interval of time (in seconds) that must pass after an error has been encountered during archiving to the destination before future archives to the destination can be attempted. Future attempts are made when the next REDO logfile is archived. If a destination is MANDATORY, Oracle Corporation recommends that you specify a REOPEN time that reduces the possibility of primary database shutdown due to lack of available online REDO logfiles.

If you do not specify integer, the default value is 300 seconds. If you do not specify REOPEN, the archiver process will never reopen a destination after an error.

Andreas Kesenheimer wrote:

> Hi,
>
> for "feeding" of a standby database I would like to set up a
> second destination for archived redo-logs.
>
> In my documentation (DBA Handbook from ORacle Press) I
> find a pair of two parameters which must be used in "initSID.ora":
>
> LOG_ARCHIVE_DEST_n=<path>
>
> and
>
> LOG_ARCHIVE_STATE_DEST_n=ENABLED
>
> First, second parameter is rejected from server during startup with:
>
> 'ENABLED' is not an allowable value for 'log_archive_dest_state_1'
>
> could anyone tell me what value is allowed (maybe a link to a
> complete reference of parameters and allowed values in initSID.ora
> would help a lot)?
>
> Second, the only destination that is actualy used is that path which
> comes last in my configuration file - no matter what number
> "n" it has.
>
> Any clue?
>
> Thanx in advance.
>
> Andreas
>
>
>

-- 
  Slawomir Cichy (mailto:scichy_at_wp-sa.pl)
  Wirtualna Polska S.A. http://www.wp.pl
  ul. Traugutta 115a, 80-237 Gdansk
  tel. (58) 52 15 625

Received on Tue Jan 15 2002 - 09:26:17 CST

Re: LOG_ARCHIVE_DEST