Re: Can database files be NFS mounted.

Charles Jardine wrote:
>
> Is it OK for the files which make up an Oracle database to be
> NFS mounted, or must they be on discs directly attached to
> the server machine?
>
> I have always believed that NFS mounting of database files was
> forbidden. However, I cannot now find any reference to this
> restriction in the documentation. I am sure that I once read it
> somewhere (perhaps back in Oracle 6 days).
>
> I would be very grateful if anyone can give a definitive answer
> to this question (particularly with a documentation reference).
>

This restriction still holds in Oracle 7. If you mount your datafiles through NFS, Oracle cannot guarantee that writes will occur when requested. This can affect atomicity and corrupt your database.

The only reference I could find was in Chapter 5 of the Oracle Parallel Server manual (but it applies to any Oracle database):

"You can use NFS to enable access to Oracle executables, but not access to the database files or log files."

Regards,
Vince Received on Fri Jun 07 1996 - 00:00:00 CEST