Re: Setup archived log unsuccessful.

In article <pan.2001.11.10.15.12.30.214.1208_at_earthlink.net>, "Mladen says...
>
>In article <tuq8v79d62b4f_at_corp.supernews.com>, "Sybrand Bakker"
><postbus_at_sybrandb.demon.nl> wrote:
>
>> "hkchan" <hkchan_at_singnet.com.sg> wrote in message
>> news:9sj22o$bkp$1_at_coco.singnet.com.sg...
>>> Greetings,
>>>
>>> I am running Oracle 8i 8.1.6 Standard Edition on Solaris 8 with raid-1
>>> configured system.
>>>
>>> I tried to configure the server to archived log enabled, so in
>>> initlivedb.ora
>>> log_archive_start = true
>>> log_archive_dest = "location=/ora8/m01/app/oracle/admin/livedb/arch"
>>> log_archive_format = arch_%t_%s.arc
>>>
>>> But, I just could not start the service,
>>>
>>> SVRMGR> connect internal
>>> Connected
>>> SVRMGR> startup mount
>>> ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be
>>> translated
>>> ORA-07286: sksagdi: cannot obtain device information. SVR4 Error: 2: No
>>> such file or directory
>>>
>>> Please help and advice
>>>
>>> Many thanks in advance.
>>>
>>> Gerald
>>>
>>>
>>>
>> You are running standard edition. This doesn't support the location=
>> syntax, and multiple archive destinations.
>> You need to remove location=
>>
>> Hth
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>>
>> to reply remove '-verwijderdit' from my e-mail address
>
>This is not entirely correct answer.

neither is this ;)

> The LOG_ARCHIVE_DEST parameter has
>never supported "location=" syntax, it is reserved for log_archive_dest_1
>to log_archive_dest_5 parameters, together with the state parameter
>(log_archive_dest_state_x, x in {1,2,3,4,5}). The log_archive_dest parameter
>itself is a legacy parameter inherited from v6 and v7 and it should be
>replaced by the new parameters which allow for the log multiplexing.

log_archive_dest is the only one you can use in STANDARD edition as it does not support archive log multi-plexing and does not support the log_archive_dest_n init.ora parameters.

This parameter is depreciated in Enterprise Edition in favor of the setting that allows for >1 copy of the archive to be made. In Standard -- it is alive and kicking.

So, whilst true that log_archive_dest doesn't support location= (but log_archive_dest_n does) - it is not true that log_archive_dest is a legacy parameter and should be replaced.

>--
>Mladen Gogala
>I love the smell of napalm in the morning. It smells like victory.
>Apocalypse Now

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp