LATEST TOPICS

RMAN Backup fails with ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Issue Description:

RMAN backup failed with ORA-27054 errors while NFS filesystem was used for backup destination

RMAN> run
2> {
3> allocate channel c1 device type disk;
4> allocate channel c2 device type disk;
5> backup database format '/dbtemp/patch11_%d_%U';
6> release channel c2;
7> release channel c1;
8> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=139 devtype=DISK

allocated channel: c2
channel c2: sid=144 devtype=DISK

Starting backup at 02-AUG-13
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on c1 channel at 08/02/2013 01:57:43
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 02-AUG-13
channel c2: starting full datafile backupset
channel c2: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on c2 channel at 08/02/2013 01:57:44
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel c2: starting full datafile backupset
channel c2: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on c1 channel at 08/02/2013 01:57:44
ORA-19504: failed to create file "/dbtemp/patch11_PATCH11_02og8g4n_1_1"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 2
Additional information: 9
channel c1 disabled, job failed on it will be run on another channel
including current SPFILE in backupset
channel c2: starting piece 1 at 02-AUG-13
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c2 channel at 08/02/2013 01:57:46
ORA-19504: failed to create file "/dbtemp/patch11_PATCH11_04og8g4o_1_1"
-----
----- Errors related to NFS filesystem reported here
-----
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 2
Additional information: 9

 

Cause :

After browsing through Oracle Support, found the issue to be cause of the Bug:10281887

 

Solution:

Set the following event in the init.ora parameter file:

event=”10298 trace name context forever, level 32″ in the init.ora/spfile and restart the instance.

Setting this event would skip MOUNT POINT check.

If using spfile define the event from sqlplus

SQL> alter system set event='10298 trace name context forever, level 32' scope=spfile;

Or

Download One off patch Patch:10281887 if available for your platform

 

Reference:

MOS Note 1472448.1 :RMAN Backup Fails With RMAN-03009 ORA-19504 ORA-27054 NFS file system where the file is created or resides is not mounted with correct options

 

%d bloggers like this:
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed