Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Archivelogs to a network drive ?

Re: Archivelogs to a network drive ?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Fri, 25 Jun 1999 11:35:14 +0200
Message-ID: <7kvie5$lm3$1@news3.saix.net>


hogana_at_my-deja.com wrote in message <7ktla8$9up$1_at_nnrp1.deja.com>...
>Hi,
> I am running 7.3.3 on NT4 with one physical disk and daily hot
>backups. To maximise recoverability in the event of a disk failure, I am
>trying to set the archivelog destination to a network drive. This is
>causing an "end-of-file on communication channel" error when I startup.

IMHO using any kind of network file system (NFS, mapped drives etc.) for Oracle files is a Bad Idea (tm). Sooner or later the network will be down when Oracle is up and this will cause problems.

If you do have a space problem.. well, harddisk drives are very cheap. Especially on Wintel. Bought myself a 8.4GB for far under $200 a week ago. Surely your database's well being is worth it? :-)

Another option will be to use the NT command language and some creative scripting to either copy completed archive logs directly to tape (you can call the NT tape backup program with command line parameters), or copy it across to the mapped drive.

Hmmm.. what about using NT's built in file replication feature for login scripts..? I know it's not intended for this type of thing, but it just may work. This may just allow you to automatically replicate the logs across to another machine with NT doing all the work.

regards,
Billy Received on Fri Jun 25 1999 - 04:35:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US