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
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…