Re: Archivelogs to a network drive ?

Try this:

Have a set destination for archived log files on your hard drive. Then create a batch job that will periodically (once an hour?) copy all archived log files in that directory to a network drive and if the copy is successful then unlink the log on the hard drive. If you have the batch job maintain a log of its own activities then you'll be able to see when failures occur.

Ken

Billy Verreynne wrote:

> 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 - 07:23:00 CDT