解決oracle rman報ORA-27054 NFS file system where the file is created or resides is not mounted with cor

cnhtm發表於2010-04-21
原文網址 : http://blog.itpub.net/22049049/viewspace-1033045/
OracleNFSIDE

Linux環境下，用oracle的rman透過nfs複製資料的時候報告 ORA-27054: NFS file system where the file is created or resides is not mounted with correct options 錯誤，詳細錯誤資訊如下：

[oracle@rac1 admin]$ rman target sys/oracle@prim auxiliary /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 20 23:21:51 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: DGTEST (DBID=3673368407)
connected to auxiliary database: DGTEST (not mounted)

RMAN> duplicate target database for standby dorecover;

Starting Duplicate Db at 20-APR-10
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=148 instance=dgtest1 devtype=DISK

contents of Memory Script:
{
set until scn 586703;
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 20-APR-10
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/rman/07lbkkh4_1_1
ORA-19870: error reading backup piece /u01/rman/07lbkkh4_1_1
ORA-19505: failed to identify file "/u01/rman/07lbkkh4_1_1"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/20/2010 23:22:16
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

RMAN> exit

Recovery Manager complete.

這個問題是由於mount nfs的時候沒有使用正確的引數，解決方法就是用如下方式mount nfs檔案系統。過程如下：

[root@rac1 ~]# umount /u01/rman
[root@rac1 ~]# mount -t nfs 192.168.19.219:/u01/rman -o hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3 /u01/rman

--end--

[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22049049/viewspace-1033045/，如需轉載，請註明出處，否則將追究法律責任。

相關文章