NFS mounting Oracle datafiles
2007-12-24 22:16:00
I am currently looking into the possibility of purchasing a V880 server with
6 internal disks. The reasons for this are that one of my companies
applications runs Oracle and has a new requirement to store up to 120Gb of
extra data. The current servers being used are DG/UX attached to a Clariion
array. (EEK!)
However, rather than simply attach a second array, I am toying with the idea
of buying the V880 and NFS mounting Oracle database files from the V880 onto
the DG/UX server.
According to Oracle, this is NOT a good idea. Oracle, and I quote say:
"It's important that the information get properly written to the redo logs,
and
NFS mounting those files increases the chances that they might be corrupted.
The protocol used to transfer data under NFS (UDP or User Datagram Protocol)
is not very reliable, and it doesn't keep track of states. Hence, there are
increased risks of writing bad data into your archive logs, which makes them
unusable for recovery.
Oracle datafiles should not be NFS mounted for the same reasons - reads and
writes to such files could be corrupted, and hence data would not be
accurately reported or recorded. "
I however, have been running a system in development doing exactly this for
18 months and have had no problems with NFS.
So, my questions are these:
1) Has anyone any experience good/bad with NFS and Oracle?
2) In Solaris 8, logging can be enabled on UFS filesystems. Can this be
enabled with NFS filesystems?
3) If the NFS filesystems are on Disksuite controlled devices, will SDS
(soon to be SVM) logging keep track of changes?
I will summarise any responses! Thanks in advance!
Callum A. Hughes
Unix Systems Engineer
t: 01249 - 665 -396
e: callum.hughes at sis.securicor.co.uk
**********************************************************************
The information contained in this e-mail message is intended
only for the individuals named above. If you are not the
intended recipient, you should be aware that any
dissemination, distribution, forwarding or other duplication
of this communication is strictly prohibited. The views
expressed in this e-mail are those of the individual author
and not necessarily those of
Securicor Information Systems Limited.
Prior to taking any action based upon this e-mail message
you should seek appropriate confirmation of its authenticity.
If you have received this e-mail in error, please immediately
notify the sender by using the e-mail reply facility.
**********************************************************************
_____________________________________________________________________
This message has been checked for all known viruses on behalf of Securicor Information Systems by the MessageLabs. For further information visit http://www.messagelabs.com or Email: mailsweeper.info at sis.securicor.co.uk
Comments
Got something to say?
You must be logged in to post a comment.
