![]() ![]() RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or pieceĪlthough 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, unless you have turned on Direct-NFS on the database kernel. RMAN-03002: failure of restore command at 12:58:33 RMAN-00569: = ERROR MESSAGE STACK FOLLOWS = RMAN> restore controlfile from '/nfs/install/oemdb/cf2.f' This shouldn’t happen, it is just stored on a common NFS share, file should not be damaged. 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. 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' I got a really surprising error message today when setting up a new data guard standby database. ![]() RMAN-06172 when restoring a controlfile and dNFS is not turned on Written by: ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |