在使用IMPDP导入数据时遇到了ORA-31693、ORA-31640、ORA-19505和ORA-27037错误，原因是RAC实例没有物理访问转储文件。官方文档指出问题存在于并行度大于1的设置中，因为PQ/PX从属进程可能无法访问dump文件。解决方案包括在11.2.0.2补丁集中修复问题，或者通过设置CLUSTER=N、限制并行度、使用本地文件系统或集群文件系统等方法工作。
impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037
在impdp时遇到报错：
Additional information: 3
. . 导入了 "HQ_X1"."T_XX130901":"SP15" 13.99 KB 0 行
. . 导入了 "HQ_X1"."T_XX130901":"SP2" 13.99 KB 0 行
ORA-31693: 表数据对象 "HQ_X1"."TEMP_YEAR_MONTH" 无法加载/卸载并且被跳过, 错误如下:
ORA-31640: 无法打开要读取的转储文件 "/HQ_X22.DMP"
ORA-19505: 无法识别文件"/HQ_X22.DMP"
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
我的impdp命令：
nohup impdp HQ_X1/HQ_X1 DUMPFILE=HQ_X1%u.DMP transform=oid:n DIRECTORY=dir1 parallel=8&
看了下官方文档的说法：
The cause of this problem has been identified in unpublished bug 9378256. It is caused by a RAC instance not having physical access to the dump file (as indicated by the DIRECTORY parameter) and using a parallel degree
在impdp时遇到报错：
Additional information: 3
. . 导入了 "HQ_X1"."T_XX130901":"SP15" 13.99 KB 0 行
. . 导入了 "HQ_X1"."T_XX130901":"SP2" 13.99 KB 0 行
ORA-31693: 表数据对象 "HQ_X1"."TEMP_YEAR_MONTH" 无法加载/卸载并且被跳过, 错误如下:
ORA-31640: 无法打开要读取的转储文件 "/HQ_X22.DMP"
ORA-19505: 无法识别文件"/HQ_X22.DMP"
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
我的impdp命令：
nohup impdp HQ_X1/HQ_X1 DUMPFILE=HQ_X1%u.DMP transform=oid:n DIRECTORY=dir1 parallel=8&
看了下官方文档的说法：
The cause of this problem has been identified in unpublished bug 9378256. It is caused by a RAC instance not having physical access to the dump file (as indicated by the DIRECTORY parameter) and using a parallel degree
最低0.47元/天 解锁文章
扫一扫
824
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
