DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, October 25, 2015

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece from nfs mount point



RMAN> restore controlfile from '/mount/nfs/mydb/20141213/control_132343_gdfgvdf.bak';

Starting restore at 20.12.2014 07:28
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=235 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/20/2014 06:28:43
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


Check the alert log :

Alert log content:
==============

Sat Dec 20 07:28:43 2014
WARNING:NFS mount of file /mount/nfs/mydb/20141213/control_132343_gdfgvdf.bak on filesystem /mount/nfs/mydb/20141213/control_132343_gdfgvdf.bak done with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
WARNING:NFS mount of file /mount/nfs/mydb/20141213/control_132343_gdfgvdf.bak on filesystem /mount/nfs/mydb/20141213/control_132343_gdfgvdf.bak done with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,

Solution:

Here are the mount options that need to be used for NFS volumes on Linux are:
rsize=32k, wsize=32k, hard, actimeo=0

Along with the error there are warning messages printed in the alert log with the mount options to be used.Sometimes you may need to do the following to allow datapump to work with NFS mounted files:

Set the event in the init.ora, to disable the mount point parameter checking:

event="10298 trace name context forever, level 32" 

         
Note that the event 10298 skips all mount checks.  Setting this event has to be done with care. Verify settings with your System Administrator to ensure no datafiles are corrupted



No comments: