Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archivelogs to a network drive ?
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