欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

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上创建相同的备份文件位置

 

相关标签: expdp