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

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 Thu Nov 29 2001 - 13:57:22 CST