{"id":312,"date":"2016-05-20T13:20:04","date_gmt":"2016-05-20T11:20:04","guid":{"rendered":"https:\/\/ilmarkerm.eu\/blog\/?p=312"},"modified":"2016-05-20T13:20:04","modified_gmt":"2016-05-20T11:20:04","slug":"rman-06172-when-restoring-a-controlfile-and-dnfs-is-not-turned-on","status":"publish","type":"post","link":"https:\/\/ilmarkerm.eu\/blog\/2016\/05\/rman-06172-when-restoring-a-controlfile-and-dnfs-is-not-turned-on\/","title":{"rendered":"RMAN-06172 when restoring a controlfile and dNFS is not turned on"},"content":{"rendered":"

Oracle EE 11.2.0.4 on Linux x86-64.<\/p>\n

I got a really surprising error message today when setting up a new data guard standby database.
\nI created a standby controlfile as usual and placed it on a common NFS share accessible also to the new data guard host:<\/p>\n

SQL> alter database create standby controlfile as '\/nfs\/install\/oemdb\/cf2.f';\n\nDatabase altered.\n<\/code><\/pre>\n
Now, on a new node I tried to restore that controlfile, but got a really surprising RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece<\/strong>. This shouldn’t happen, it is just stored on a common NFS share, file should not be damaged.<\/p>\n
RMAN> restore controlfile from '\/nfs\/install\/oemdb\/cf2.f';\n\nStarting restore at 20-MAY-16\nusing channel ORA_DISK_1\n\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of restore command at 05\/20\/2016 12:58:33\nRMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece\n<\/code><\/pre>\n
Although the error message does not say it, but I remembered that I had mounted the NFS using SOFT mount option and when trying to restore datafiles from soft mounted NFS shared you will usually get ORA-27054: NFS file system not mounted with correct options<\/strong>, unless you have turned on Direct-NFS on the database kernel. So I just wondered, maybe this is the real error message in this case also.
\nAfter turning on Direct NFS, restoring the control file worked as expected:<\/p>\n
[production|oracle@vdb0005.mlt.unibet.com oemdb]$ cd $ORACLE_HOME\/rdbms\/lib\n[production|oracle@vdb0005.mlt.unibet.com lib]$ make -f ins_rdbms.mk dnfs_on\nrm -f \/u01\/app\/oracle\/product\/11.2.0.4\/db\/lib\/libodm11.so; cp \/u01\/app\/oracle\/product\/11.2.0.4\/db\/lib\/libnfsodm11.so \/u01\/app\/oracle\/product\/11.2.0.4\/db\/lib\/libodm11.so\n[production|oracle@vdb0005.mlt.unibet.com lib]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Fri May 20 13:01:56 2016\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\nSQL> startup nomount\nORACLE instance started.\n\nTotal System Global Area 9620525056 bytes\nFixed Size                  2261368 bytes\nVariable Size            2449477256 bytes\nDatabase Buffers         7147094016 bytes\nRedo Buffers               21692416 bytes\nSQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\n[production|oracle@vdb0005.mlt.unibet.com lib]$ rman target \/\n\nRecovery Manager: Release 11.2.0.4.0 - Production on Fri May 20 13:02:14 2016\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: OEM (not mounted)\n\nRMAN> restore controlfile from '\/nfs\/install\/oemdb\/cf2.f';\n\nStarting restore at 20-MAY-16\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=474 device type=DISK\n\nchannel ORA_DISK_1: copied control file copy\noutput file name=+DATA\/oem\/controlfile\/current.257.912344539\nFinished restore at 20-MAY-16\n<\/code><\/pre>\n
The NFS share was mounted using options:
\ntype nfs (rw,bg,soft,rsize=32768,wsize=32768,tcp,nfsvers=3,timeo=600,addr=10.10.10.10)<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle EE 11.2.0.4 on Linux x86-64. I got a really surprising error message today when setting up a new data guard standby database. I created a standby controlfile as usual and placed it on a common NFS share accessible also to the new data guard host: SQL> alter database create standby controlfile as ‘\/nfs\/install\/oemdb\/cf2.f’; Database […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[4,44],"class_list":["post-312","post","type-post","status-publish","format-standard","hentry","category-blog-entry","tag-oracle","tag-rman"],"_links":{"self":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/comments?post=312"}],"version-history":[{"count":3,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":315,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/312\/revisions\/315"}],"wp:attachment":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/media?parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/categories?post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/tags?post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}