expdp在RAC多线程导出时报错ORA-31617
程序员文章站
2024-03-13 20:07:27
...
环境是11.2.0.4 RAC,
expdp system/******** directory=expdpbak full=y dumpfile=orcl_20191107_%U.expdp logfile=orcl_20191107.log exclude=STATISTICS compression=all parallel=4
报错提示
ORA-31693: Table data object "LMES"."xxxxxxxxx" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/xxxxx/xxxxx/xxxxx/orcl/orcl_20191107_03.expdp" for write
ORA-19505: failed to identify file "/xxxxx/xxxxx/xxxxx/orcl/orcl_20191107_03.expdp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
原因:忘记加上CLUSTER=NO参数,2节点没有在相同位置挂载磁盘,导致节点2的实例尝试在节点2上寻找该位置,提示失败。
解决方案:
1、CLUSTER=NO参数,指定expdp只从一个实例导出,
2、或者在节点2上创建相同的备份文件位置
上一篇: 使用0级备份和1级备份做完全恢复