Re: Can database files be NFS mounted.
Date: 1996/06/13
Message-ID: <4pp4jk$a00_at_corona.calgary.chevron.com>#1/1
In article <31BDEAC9.1011_at_thomtech.com>, ashok kapur <akapur_at_thomtech.com> writes:
|> Chuck Hamilton wrote:
|> >
|> > Charles Jardine <cj10_at_cam.ac.uk> 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).
|> > >
|> > >Charles Jardine - Univ. of Cambridge (UK) Computing Service
|> >
|> > I've never tried it but I would think this would be a bad idea just
|> > for performance reasons, both for the database and the network. You'll
|> > probably suck up all your bandwidth, not to mention that few networks
|> > are going to be as fast as a local disk drive.
|> >
|> > Why not create a test database and try it? Make sure to test
|> > everything though: queries, updates, backup & recovery, etc. If you
|> > do, please post the results. I'd be interested in hearing what
|> > happened
|> > --
|>
Chuck Hamilton
|> > chuckh_at_dvol.com
|> >
|> > Never share a foxhole with anyone braver than yourself!
|>
|> Been there and done it!! Yes, it works, but as Chuck said, it is very
|> slow.
|> --
|> Ashok Kapur (akapur_at_thomtech.com)
|> Thomson Technology Consulting Group
|> 1375 Piccard Drive, Suite 250
|> Rockville, MD 20850
The last time I checked ORACLE did not support the use of NFS mounted
datafiles. I have been burned by it. It you loose your NFS mount even
for a short time your datafile can become corrupt and your instance
may even crash. I stopped using NFS mounted datafles for this rason.
Steve Received on Thu Jun 13 1996 - 00:00:00 CEST