"."" failed to load/unload and is being skipped due to error:ORA-31617: unable to open dump file "

第46期 DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-31617 ORA-19505

来源:这里教程网 时间:2026-03-03 22:34:35 作者:

在RAC环境上使用expdp进行逻辑备份时,报如下错误。 ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME>" failed to load/unload and is being skipped due to error: ORA-31617: unable to open dump file "<dumpfile name and path>" for write ORA-19505: failed to identify file "<dumpfile name and path>" ORA-27037: unable to obtain file status Solaris-AMD64 Error: 2: No such file or directory Additional information: 3 使用的备份脚本是:expdp  '"/ as sysdba"'  directory=DATA_PUMP_DIR  dumpfile=$FILENAME"1".dump,$FILENAME"2".dump,$FILENAME"3".dump logfile=$FILENAME.log  schemas=test,test2,test3   parallel=3 COMPRESSION=all 解决的方式: 1. Share/mount the dumpfile destination with all RAC nodes performing the expdp - OR - 2. Use CLUSTER=N during Datapump so it will only run on the node which has the mount point and permissions to write to it. 我的方法是修改了expdp脚本,加如了  CLUSTER=N 参数。 expdp  '"/ as sysdba"'  directory=DATA_PUMP_DIR  dumpfile=$FILENAME"1".dump,$FILENAME"2".dump,$FILENAME"3".dump logfile=$FILENAME.log  schemas=test,test2,test3    CLUSTER=N  parallel=3 COMPRESSION=all 最后,备份成功。不在报错了。

相关推荐