Re: Archive logs using NT \\Domain\Share, How?

Putting your Archived logs on anything other than a local drive is not a good idea. If the remote machine is down or your system can not communicate with the remote drive for any reason, your database will not be able to archive redo logs and your database will come to a halt. I would suggest archiving to a local drive and then running a periodic script to move the archived redo logs to your remote system. Or purchase another harddrive for your system. They aren't that expensive.

Just my 3.14159265 cents worth,
Brian

rushing65_at_my-deja.com wrote:
>
> From: rushing65_at_my-deja.com
> Subject: NT Archive Log on //domain/share, HOW?
> Date: Fri, 11 Aug 2000 17:20:25 GMT
> Newsgroups: comp.databases.oracle
> Organization: Deja.com - Before you buy.
> NNTP-Posting-Host: 208.158.253.242
> X-Article-Creation-Date: Fri Aug 11 17:20:25 2000 GMT
> X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 95)
> X-Http-Proxy: 1.1 x67.deja.com:80 (Squid/1.1.22) for client
> 208.158.253.242
> X-MyDeja-Info: XMYDJUIDrushing65
>
> I currently have an Oracle 8.1.5 database running on an NT Server.
> It's archive log files are stored on second server. The
> log_archive_dest parameter in init.ora is specified via drive mappings
> (M:\Oracle...). All is working successfully. The services are started
> under the System account on the NT Server. Unfortunately, the drive
> mapping only takes place after someone has logged in on the server.
> Thus, the services fail on startup. I attempted to use UNC naming
> conventions (\\ExShare\Oracle...) and changed the Oracle services to
> start using a Domain account that has rights to the share and admin
> rights on the local server.
>
> If I attempt to start the service under the new user account using UNC
> mappings, I get an ORA-16032 "parameter log_archive_dest destination
> string cannot be translated." (I also get ORA-09291 and OSD-04018, but
> I'm certain they are caused by the first error) I also get an os(3)
> "system cannot find path specified."
>
> Oddly enough, If I attempt to start the service under the new user
> account with the drive mapped, but not when logged into the server
> using the new user account, I get the same ORA-16302/ORA-09291/OSD-
> 04018, but I get an os(5) error "Access denied." When logged in using
> the oracle user account, I can access the share via Explorer. I even
> cut/pasted the share path directly from my init.ora file to make
> certain there wasn't a typo.
>
> I'm certain I'm missing something very simple here. Any thoughts or
> pointers to other info appreciated.
>
> ---Tim Rushing
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================