From last two days, I have been getting “ORA-27054: NFS file system not mounted with correct options” error while running an RMAN backup to a Sun ZFS Storage Appliance.
This error have been observed particularly, while taking controlfile backups. RMAN datafile or archivelog backups without controlfile were running fine.
RMAN-08132: WARNING: cannot update recovery area reclaimable file list RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ch01 channel at 02/15/2016 16:02:44 ORA-01580: error creating control backup file /mnt/bkp1/TEST1/TEST1_CTRL_snapcf.ctl ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 3 Additional information: 1
After searching on MOS, I found following note, which explains different mount point options for configuring the NFS mounts.
Sun ZFS Storage Appliance: Oracle Database 11g R2 NFS Mount Point Recommendations (Doc ID 1567137.1)
After discussing the same with SOLARIS team, we found that backup mount point were mounted with all recommended parameters.
So tried to search more documents on MOS and found the one:
As per note “DNFS is strongly recommended when protecting an Exadata with the ZFS Storage Appliance. It is required to achieve the published backup and restore rates”.
You can confirm that DNFS is enabled by running following query on database:
select * from v$dnfs_servers;
In my case it was not enabled. DNFS to be enabled on a each database node with the following command:
$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk dnfs_on
dcli may be used to enable Oracle Direct NFS on all of the database nodes simultaneously:
$ dcli -l oracle -g /home/oracle/dbs_group make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk dnfs_on
The database instance should be restarted after enabling Oracle Direct NFS.
After enabling DNFS activity, my backup started running without any issues.
Done!!!!!!!!!!
Hope so u will find this post very useful 🙂
Cheers
Regards,
Adityanath
Categories: Administration, backup & recovery, ORA errors, RAC
Hi Adi. Nice post. Coincidental that I also have been facing the same error currently, although in my case it is not exadata or ZFS.. Will see what I get for my case. And by the way, great work from you to put up this entire blog and all the content in it.
Thanks for visiting and appreciate your feedback. 🙂
Everything is very open with a really clear explanation of the issues.
It was really informative. Your site is very useful. Thank you for sharing!
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
This site was… how do I say it? Relevant!! Finally I’ve found something that helped me.
Many thanks!
Hello my family member! I want to say that this article
is amazing, nice written and include approximately all vital infos.
I would like to see more posts like this .
I really like your blog.. very nice colors & theme. Did you create this website yourself or did you hire someone to do it for you?
Plz answer back as I’m looking to design my own blog and would like to
find out where u got this from. kudos
I needed to thank you for this very good read!! I certainly loved every bit of it.
I’ve got you book-marked to check out new stuff you post…
I don’t even understand how I ended up here, however I thought
this post was great. I don’t realize who
you are but certainly you’re going to a well-known blogger for those
who are not already. Cheers!
Thank you for writing this awesome article. I’m a long time reader but I’ve never been compelled to leave a comment.
I subscribed to your blog and shared this on my Twitter. Thanks again for a great
article!
Very nice article, totally what I was looking for.
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
Hello, of course this piece of writing is in fact nice and I have learned lot of things from it on the topic of
blogging. thanks.
It’s an amazing post in favor of all the web visitors; they will obtain advantage from it I am sure.
I all the time emailed this blog post page to all my contacts, as if like to read it then my links will too.
Excellent site you have got here.. It’s hard to find excellent writing like
yours these days. I truly appreciate people like you!
Take care!!
Great site. A lot of helpful information here. I am sending it to some buddies ans additionally sharing in delicious.
And certainly, thanks for your effort!
Thanks for sharing your info. I truly appreciate your
efforts and I am waiting for your next write ups thanks once again.
I do not even know the way I finished up here, but I thought this put up was once great.
I do not realize who you might be however certainly you’re going to a well-known blogger when you are
not already. Cheers!
Thanks for sharing your thoughts. Regards
Terrific article! That is the type of info that are supposed to be shared across the net.
Disgrace on the seek engines for now not positioning this submit higher!
Come on over and talk over with my web site . Thanks
=)
Very soon this website will be famous among all blog people,
due to it’s good articles or reviews
I like this post, enjoyed this one thanks for posting.
Keep on writing, great job!
Just wish to say your article is as surprising. The clearness in your put up
is just excellent and i could suppose you’re an expert in this subject.
Well with your permission allow me to clutch your feed to keep updated with impending post.
Thank you 1,000,000 and please carry on the rewarding work.
Excellent site. Plenty of helpful information here. I’m sending it to a few friends ans also sharing in delicious.
And obviously, thank you in your effort!
Like!! Really appreciate you sharing this blog post.Really thank you! Keep writing.
We absolutely love your blog and find many of your post’s to be just what I’m looking for. Would you offer guest writers to write content for you personally? I wouldn’t mind creating a post or elaborating on most of the subjects you write regarding here. Again, awesome site!
I am facing same issue, but this solution didnt work
SID SPID CLIENT_INFO
—– ———————— ——————————
EVENT SECONDS_IN_WAIT
—————————————————————- —————
P1 P2 P3
———- ———- ———-
1921 38885 rman channel=c1
SQL*Net break/reset to client 135
1650815232 0 0
2298 38890 rman channel=c2
SQL*Net break/reset to client 253
1650815232 0 0
SID SPID CLIENT_INFO
getting this
Hello Shiv,
Can you please provide more information like RMAN error, DB version & Exadata version?
Regards,
Adi
I got this website from my pal who told me about this website and at the moment this time I am browsing this web site and reading very informative articles at this place.