Re: Is nfs reliable?
Date: Fri, 3 Jun 2016 12:37:08 -0400
Message-ID: <20160603123708.4bec2048_at_jeremy-nb.localdomain>
On Fri, 3 Jun 2016 08:02:29 -0700 Michael Cunningham wrote:
> Sherrie, can I ask a question for my own curiosity?
>
> Do you have ORACLE_HOME mounted on a storage device? Is it mounted
> using nfs? I know of a few Oracle DBA's doing this and it has worked
> well for them. They like the ease of upgrades and just switching
> homes.
On Fri, 3 Jun 2016 15:34:04 +0000 Robert Freeman wrote:
> We Run our RAC databases using NFS as the shared media for datafiles.
> We have yet to have a failure because of NFS. We don’t use shared
> software directories however, just local directories. My personal
> preference is for local software.
I would second Robert's statement here. I have managed environments with shared homes on shared storage. The db binaries didn't cause too much trouble and I've heavily used the "switching-home" upgrade method with both local and shared homes. It is slick. However oracle *does* have a lot of log files scattered around - and I do think it's pretty critical to get log files on a device that's least likely to fail. That means local disk. Not even a single-server dedicated mountpoint backed by shared storage. I had issues at one time with shared storage and all log files were on local mountpoints backed by the problematic SAN itself... so logs didn't get written. Shortly after that we moved everything to local storage.
Of course, you've now got a more complicated space management picture with putting multiple GB of software on each db servers' local disk in the data center. Moving the diagnostics destination to local storage will catch the most important log files for database homes. I would strongly recommend to avoid putting grid infrastructure software on any mountpoint that's backed by a NAS or SAN... a number of important log files are hard coded to the GI home and it sucks to troubleshoot when you have no logs.
Just a few thoughts on that topic based on my experiences... not specific to NFS but applicable to any network storage :)
-J
-- http://about.me/jeremy_schneider -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 03 2016 - 18:37:08 CEST