ORA-31617 unable to open dump file for write
Question: I am getting the ORA-31693 error during a data pump export in RAC:
ORA-31693: Table data object "xxx" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u01/expdp/dump_test.dmp" for write
ORA-19505: failed to identify file "/u01/expdp/dump_test.dmp"
ORA-27037: unable to obtain file status
What is the cause of the ORA-31693 error?
Answer: You can use the oerr utility to look-up the ORA-31693 error:
ORA-31617: unable to open dump file "xxx" for write
Cause: Export was unable to open the export file for writing. This message is usually followed by device messages from the operating system.
Action: Take appropriate action to restore the device.
The root cause of the ORA-31617 is likely in RAC is that this error occurs when parallel parameter is specified in using expdp in RAC databases and same physical directories does not exists in all nodes.
This is a bug in 11g and it is fixed in 11by setting the "cluster" parameter cluster=N :
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26838672/viewspace-2055100/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-31640: unable to open dump file 問題解決
- 【伺服器】關於錯誤:Smarty:unable to write file伺服器
- write&read&open
- db file parallel writeParallel
- Oracle db file parallel write 和 log file parallel write 等待事件 說明OracleParallel事件
- log file sync 和 log file parallel writeParallel
- unable to get file lock, will retry ...
- open physical standby 為read write
- Oracle Dump Redo Log FileOracle
- nodejs read/write fileNodeJS
- control file parallel writeParallel
- ORA-27041: unable to open file--恢復被rm意外刪除資料檔案
- ORA-7445(ACCESS_VIOLATION)(unable_to_trans_pc)(UNABLE_TO_WRITE)錯誤
- linux解決xhost: unable to open displayLinux
- linux解決xhost unable to open display‘’Linux
- Linux錯誤:xhost unable to open displayLinux
- 解決問題:OSError: Unable to open file (truncated file: eof = 22118400, sblock->base_addr = 0, stored_eofErrorBloC
- data file int write和db file sequential read個人想法
- audit_file_dest, background_dump_dest, core_dump_dest, user_dump_dest
- control file parallel write等待事件Parallel事件
- 完美解決xhost +報錯: unable to open display
- 轉貼:xhost unable to open display解決方法
- ftp_rawlist: Unable to create temporary file.FTP
- SQL*Loader-500: Unable to open file (v1x-access_log_20120916.dat)SQL
- Oracle - ORA-09817: Write to audit file failedOracleAI
- control file parallel write事件小記Parallel事件
- [轉載]Oracle等待事件Data file init writeOracle事件
- Warning: unable to open an initial console.
- open_basedir() restrictijon in effect. FIle()REST
- ftp 報錯 550 Failed to open fileFTPAI
- Oracle之 等待事件log file sync + log file parallel write (awr優化)Oracle事件Parallel優化
- Unable to create index.lock File exists錯誤Index
- 高手sos!!! Unable to load document from file...
- 建立asm磁碟 報錯 oracleasm-write-label: Unable to clear deviceASMOracledev
- log file sync(日誌檔案同步) 與 Log file parallel write 等待事件Parallel事件
- zt_Oracle Dump Redo Log File 說明Oracle
- Linux open file與 fs-maxLinux
- apr_file_open函式用法心得函式