Moneycontrol Brokerage Recos

Thursday, September 8, 2016

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



I was trying to catalog COLD backup of source database stored on an NFS mount point to RMAN on AIX 7.2 platform which failed with below errors.

ORA-19625: error identifying file /orabackup/PROD/ORADB/users01.dbf
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options


From Alert Log:
--------------------

WARNING: NFS file system /orabackup mounted with incorrect options(bg,hard,intr,sec=sys,rw)
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
Errors in file /oracle/diag/rdbms/prod/trace/PROD_ora_28573960.trc:
ORA-19625: error identifying file /orabackup/PROD/ORADB/users01.dbf
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 5
Additional information: 2
WARNING: NFS file system /orabackup mounted with incorrect options(bg,hard,intr,sec=sys,rw)
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
Errors in file /oracle/diag/rdbms/prod/trace/PROD_ora_28573960.trc:
ORA-19625: error identifying file /orabackup/PROD/ORADB/users01.dbf.OLD
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 5
Additional information: 2


I checked the options used while mounting the mount point /orabackup


/orabackup:
        dev             = "/orabackup"
        vfs             = nfs
        nodename        = 192.168.90.11
        mount           = true
        type            = nfs
        options         = bg,hard,intr,sec=sys     --- not matching the expection thrown in error above
        account         = false



Above in the error message from alert log, Oracle RMAN expects NFS mount point options (rsize>=32768,wsize>=32768,hard) in order to proceed.





Workaround : I un-mounted the device and re-mounted that again with expected options as below.


$umount /orabackup

$mount -o rw,bg,hard,nointr,vers=3,timeo=300,rsize=32768,wsize=32768 92.168.90.11:/orabackup /orabackup


And again tried to catalog the COLD backup stored at that NFS mount point to RMAN.



RMAN> catalog start with '/orabackup/PROD/ORADB';

using target database control file instead of recovery catalog
searching for all files that match the pattern /orabackup/PROD/ORADB

List of Files Unknown to the Database
=====================================
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156187_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156188_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156189_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156190_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156191_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156192_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156193_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156194_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156195_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156196_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156197_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156198_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156199_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156200_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156201_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156202_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156203_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156204_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/old1_24972_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_1_921865254.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_2_921865254.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_3_921865254.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_4_921865254.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_5_921865254.dbf
.
.
.
.
.
.
.
File Name: /orabackup/PROD/ORADB/undotbs01.dbf
File Name: /orabackup/PROD/ORADB/users01.dbf
File Name: /orabackup/PROD/ORADB/users01.dbf.OLD

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156187_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156188_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156189_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156190_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156191_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156192_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156193_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156194_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156195_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156196_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156197_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156198_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156199_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156200_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156201_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156202_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156203_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_156204_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/old1_24972_674772839.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_1_921865254.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_2_921865254.dbf
File Name: /orabackup/PROD/ORADB/Archive_Logs/1_3_921865254.dbf
.
.
.
.
.


It worked fine.

2 comments: