Solved

Should I use automount nfs filesystems for Oracle datafiles?

Posted on 2011-09-07
10
878 Views
Last Modified: 2012-05-12
I'm running some Oracle v11g databases on Solaris 10, and all of our datafiles are on nfs attached storage.  I would like to know:

Q: Should I use permanently mounted filesystems in /etc/vfstab, or automount filesystems in /etc/auto_direct

Both can be given the same parameters for hard mounting, transfer size, etc. but Oracle don't say one way or the other what is best.  Can anyone provide a white paper that gives some solid advice that's backed up with a rationale as opposed to simply a preference?
0
Comment
Question by:Sophia Paterakis
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 100 total points
ID: 36498789
I would go with permanently mounted.  I don't have a paper that will say this but I would want to ensure they are mounted independently of access.
0
 
LVL 2

Expert Comment

by:achellstrom
ID: 36499514
If I had my choice I would not nfs mount file systems, however it does make for an easy way to add storage to a system.  You will see about 20% high CPU rates than a standard UFS file system, but the throughput is relatively close to what you could expect from standard spinning disks.  Of course there is direct attached SSD that standard UFS or NFS couldn't come close on. SSD would be my preferred database storage. However, if you are looking to save money and have CPU to spare then NFS is viable.  Here is a link to a white paper on the subject: http://www.cptech.com/stuff/contentmgr/files/0/f5e142f537d0b7b873e782e1d9603521/download/database_performance_with_nas_optimizing_oracle_on_nfs.pdf
0
 
LVL 1

Author Comment

by:Sophia Paterakis
ID: 36499735
@slightvw

Yes, that's what I consider best-practice also... but my sysadmin and I have a difference of opinion, so I'd like something to help argue my case.


@achellstrom

Thanks for the advice, but we're locked into NFS at the moment.  We'll probably get SSD for the Redo logs during next years budget, but for now we're NFS only.

As for the PDF, under the section "NFS MOUNT OPTIONS", it says things such as:


The recommended mount options for Oracle9i RAC on Solaris are:  

rw,bg,vers=3,proto=tcp,hard,intr,rsize=32768,wsize=32768,forcedirectio,noac

... but nothing I can find mentions either setting them up in vfstab (permanently), or auto_direct (automount/dismount) <sigh>
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36499890
Ah, debates.  Honestly anything we could likely provide would be from a Google search.

I suggest opening an SR with Oracle Support of contacting your Oracle Sales team for supporting evidence.


Who knows, it might not matter.
0
 
LVL 1

Author Comment

by:Sophia Paterakis
ID: 36499942
Thanks slightvw.  I actually raised an SR before I posted here, but I figured they would never deliver... just call me a cynic.

If they do pull a rabbit out of the hat, then I'll let you know... but I'd still like to hear from anyone else if you have the smallest sliver of backing documentation.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36499972
lol..  I feel your pain from the Support point of view.


Maybe I am just lucky but my sales team is fairly responsive to general questions.

Did you try them?
0
 
LVL 21

Expert Comment

by:robocat
ID: 36501563

Never ever use automounting for Oracle database files.

Automounter is intended for filesystems that don't need to be mounted permanently, such as home directories, saving the trouble of manually mounting and saving server/client resources.

Oracle database filesystems always need to be mounted as the database is always online, so it makes no sense to automount these filesystems.

Using the automounter could potentially result in reliability issues that are difficult to trace back to the automounter.

Keep It Simple (KISS): something that isn't used can not cause problems.

0
 
LVL 1

Author Comment

by:Sophia Paterakis
ID: 36503848
Thanks robocat, and I agree that it's best practice not to use automount, and KISS as you mentioned.  What would really seal the deal for me is a document from Oracle, Sun, NetApp, or anyone of authority that confirms our collective opinion.
0
 
LVL 21

Accepted Solution

by:
robocat earned 400 total points
ID: 36504564

http://communities.netapp.com/servlet/JiveServlet/previewBody/1394-102-1-1536/tr-3369.pdf

Automount is not explicitly mentioned, but it does say to either mount the file systems manually or using /etc/vfstab

0
 
LVL 1

Author Closing Comment

by:Sophia Paterakis
ID: 36505720
Thanks everyone.  I leveraged the document that @robocat gave, to find this PDF:

NetApp Best Practice Guidelines for Oracle Database 11g
Oracle Alliance Engineering Team, NetApp
August 2011 | TR-3633

http://media.netapp.com/documents/tr-3633.pdf

It specifically relates to v11g, and was released only a few weeks ago so it's fresh advice.  Unfortunately the section on vfstab is copy/pasted directly from the previous document and makes no mention of automount:


Solaris NFS Protocol: Mount Options

For the latest NFS mount options and related information, see
http://kb.netapp.com/support/index?page=content&id=3010189.

Mount options are specified in /etc/vfstab for Oracle mounts that occur automatically at boot time. To specify mount options:

1. Edit the /etc/vfstab.
2. For each NFS mount participating in a high-spee

Oracle's advice on the subject was "Go and ask NetApp". :-)
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question