oracle之 資料泵dump檔案存放nfs報ORA-27054
問題描述:源端 10.2.0.4 目標端:11.2.0.4 在目標端劃分1T儲存與源端做一個NFS
錯誤:指定dump匯出為本地檔案系統,正常。 指定dump匯出為nfs檔案系統,報錯。
報錯資訊如下:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/devotd_dpump/expdp_metadata_vspp_sun.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
CAUSE
The NFS mount options seem to be incorrect. No specific setting was found to address this. The below options were tried but the same error was still encountered:
- Mount options as per Note 781349.1 - ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
- Backup using RMAN into this problematic mount point was successful
- Traditional export using exp to this problematic mount point was successful
- Creation of a new datafile to this mount point was successful
- Creation of a file from OS side to this problematic mount point was successful
- Reboot of the NFS mount point made no difference
SOLUTION
The only solution which worked in this case was to set the below event which disables the mount point parameter checking:
alter system set events '10298 trace name context forever, level 32';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31383567/viewspace-2146697/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 修改Oracle資料檔名及資料檔案存放路徑Oracle
- 資料泵檔案
- oracle之資料泵Oracle
- EXPDP備份到NFS檔案系統 ORA-27054NFS
- oracle資料塊dump檔案中ITL詳解Oracle
- 檔案共享之nfsNFS
- 通過oracle event來dump資料檔案頭資訊Oracle
- Oracle資料庫event事件與dump檔案介紹Oracle資料庫事件
- 資料泵引數檔案用於執行資料泵命令
- 【LOB】使用資料泵時 LOB 欄位存放位置
- RMAN備份資料到NFS提示ORA-27054NFS
- oracle 10g資料泵之impdp-同時匯入多個檔案Oracle 10g
- Oracle:dump轉儲檔案Oracle
- 更改MySQL資料檔案存放目錄位置MySql
- ORACLE 資料泵Oracle
- oracle資料泵Oracle
- oracle邏輯備份之--資料泵Oracle
- 解決oracle rman報ORA-27054 NFS file system where the file is created or resides is not mounted with corOracleNFSIDE
- 10g 資料泵(Data Dump) -- EXPDP & IMPDP [zt]
- ORA-27054: NFS 問題處理NFS
- oracle 資料泵解析Oracle
- ORACLE 資料泵之NETWORK_LINKOracle
- Oracle 跟蹤檔案和檔案轉儲(dump)Oracle
- expdp出dmp檔案到NFS NAS報錯ora-39001 ora-39000 ora-31641 ora-27054NFS
- linux:ora-27054:nfs file system errorLinuxNFSError
- Oracle 資料泵的使用Oracle
- oracle 資料泵引數Oracle
- PostgreSQL資料檔案災難恢復-解析與資料dumpSQL
- 檔案存放問題
- oracle 11g latch之v$latch和systemstate dump檔案之系列四Oracle
- SQL Server 中資料庫檔案的存放方式,檔案和檔案組SQLServer資料庫
- ORACLE資料檔案儲存之我見Oracle
- Oracle RAC NFS掛載檔案系統OracleNFS
- 資料庫升級之-資料泵資料庫
- ORACLE 資料泵impdp匯入報錯之ORA-31693 ORA-04098Oracle
- oracle之 RAC本地資料檔案遷移至ASMOracleASM
- Oracle使用dump匯入資料Oracle
- Oracle在NFS檔案系統上建庫OracleNFS