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.
thanks! worked perfectly!!
ReplyDeleteGlad to know it helped, thanks for your comment.
Delete