We have a created a NFS mountpoint using Isilon storage which is shared in HP-UX and Linux Cluster servers. Creating file is working fine and also datapump also works good.
But when we try to store oracle database file (Datafiles) we are receiving the error.
##########################
## Error
##########################
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
### Full Error
channel ORA_DISK_4: starting datafile copy
input datafile file number=00008 name=/ofa/u001/SIDNAME/oradata/datafiles1/SIDNAME_tbs_ts1_01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_4 channel at 08/16/2016 23:46:02
ORA-19504: failed to create file "/nfs_mount_name/SIDNAME/bkp/tbs_TS1_8.tf"ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Additional information: 12
##########################
# Error Occurred
##########################
Error occured while performing prepare phase using XTTS method in 11.2.0.4.0 version
##########################
## Command Executed
##########################
$ORACLE_HOME/perl/bin/perl xttdriver.pl -p
**************************************** Step By Step Analysis ******************************************************
#########################################
# 1) Check the file system mount Options
#########################################
cat "/etc/fstab"| grep -i mig
# cat "/etc/fstab"| grep -i mig
#----Oracle Migration-----
NASHOST:/ifs/nfspace /nfs_mount_name nfs defaults 0 0
#
=====================================================================================================================
#########################################
# 2) Reason for Failure
#########################################
The file system is mounted with the default options which will work for a normal file system usage. But to store oracle database datafiles, we need to add specific mount options.
=====================================================================================================================
##########################
## Solution
##########################
Update /etc/fstab with the below options for HP-UX servers.
rw,bg,vers=3,proto=tcp,noac,forcedirectio,hard,nointr,timeo=600,rsize=32768,wsize=32768
# cat "/etc/fstab"| grep -i mig
#----Oracle Migration-----
#NASHOST:/ifs/nfspace /nfs_mount_name nfs defaults 0 0
NASHOST:/ifs/nfspace /nfs_mount_name nfs rw,bg,vers=3,proto=tcp,noac,forcedirectio,hard,nointr,timeo=600,rsize=32768,wsize=32768 0 0#
=====================================================================================================================
Unmount and Remount the File system. After the Prepare script worked good.
=====================================================================================================================
# umount /nfs_mount_name
# mount /nfs_mount_name
# bdf /nfs_mount_name
Filesystem kbytes used avail %used Mounted on
NASHOST:/ifs/nfspace
5368709120 2783611400 2585097720 52% /nfs_mount_name
#
$ pwd
/nfs_mount_name/SIDNAME/bkp
$ ls -ltr
total 352044008
-rw-r----- 1 oracle dba 10485768192 Aug 17 11:21 tbs_TS1_23.tf
-rw-r----- 1 oracle dba 31457288192 Aug 17 11:37 tbs_TS1_9.tf
$
=====================================================================================================================
Comments Are Always welcome
=====================================================================================================================
No comments:
Post a Comment