Re: using (NT & W2K) networkdrives with oracle as log_archive_dest

Hi Adrian,

thx for answer, but it doesn't work, we use 8.1.7.1.1 on w2k-server, when I try to set log_archive_dest_3... another ora-error occurs (sorry in german):

SQL> alter system set log_archive_dest_3="T:\" ; alter system set log_archive_dest_3="T:\" *
FEHLER in Zeile 1:
ORA-02097: Parameter kann nicht verġndert werden, da angegebener Wert ung³ltig ist
ORA-16024: Parameter LOG_ARCHIVE_DEST_3 kann nicht analysiert werden

it seems that we can only use the standbyservice on a remote computer with a standbydatabase, it is Ok.

thanks Axel

On Thu, 29 Nov 2001 19:57:22 -0000, "Adrian Carlson-Hedges" <adrian.ch_at_btinternet.com> wrote:

>I think this ability was removed in either 8 or 8i. You can of course
>archive to a standyby database that is on another machine.
>
>However you cant do something like
>
>ARCHIVE_LOG_DEST2=\\machine\share\path\
>or even
>ARCHIVE_LOG_DEST3=P:\
>(where P: is a mapped network drive.)
>
>When I asked Oracle support about why this was, they said it was to remove a
>single point of failure (the network).
>
>Adrian
>
>"Axel" <ax_at_ivu.de> wrote in message
>news:3c026341.463638426_at_News.CIS.DFN.DE...
>> Hi all,
>>
>> is it possible to use mapped (highspeed) networkdrives for duplexing,
>> mirroring log archive files on different network-destinations (or for
>> multiplexing the online redo log files)? We are using archivelogmode
>> and want to copy the archive log files automaticly with e.g.
>> "log_archive_dest_2 = "location=*NETWORKDRIVE*:\archive",
>>
>> ORA-09291 sksachk: invalid device specified for archive destination
>> and OSD 4018 Unable to access the specified directory or device, also
>> when I try to use it for multiplexing the online redo log files an -->
>>
>> ORA-00301 error in adding log file 'string' - file cannot be created,
>> occurs
>>
>> is it generally not possible with oracle on w2k, or I`m to stupid :-)
>>
>> thks for help
>> Axel
>>
>> ps. we using Oracle 8.1.7 on W2K-Server with SP2
>> log_archive_dest_% with a standby-service is working correct
>
>
Received on Wed Dec 05 2001 - 02:07:47 CST