LOG_ARCHIVE_DEST
Andreas Kesenheimer
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
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:
--
Slawomir Cichy (mailto:sci...@wp-sa.pl)
Wirtualna Polska S.A. http://www.wp.pl
ul. Traugutta 115a, 80-237 Gdansk
tel. (58) 52 15 625
Manuela Mueller
Hello Andreas,
additional to Slawomir's response, look at
http://tahiti.oracle.com
This is the online documentation for Oracle 8.1.7 and 9.0.1.
Create yourself a free account at OTN if you don't already have one
(tons of infos).
eg: did a search for "server", one of the resulting links:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch179.htm#43985
The server reference describe initSID.ora parameters.
Have a nice day
Manuela Mueller
Andreas Kesenheimer
helpfull hints.
Andreas