环境: 11.2.0.4 Rac双节点 ,准备在单节点下导入报错
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "GS"."JC_SALESMAN_DATA" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/home/oracle/dump/xxxx.dmp" for read
ORA-19505: failed to identify file "/home/oracle/dump/xxxx.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
正确导入语句:
impdp \'/ as sysdba\' schemas=gs directory=my_dump dumpfile=xxxx.dmp logfile=xxx.log parallel=2 TABLE_EXISTS_ACTION=replace CLUSTER=N
检查了一下文件权限和路径都是正确的
Mos参考文档:DataPump
Import With PARALLEL > 1 In RAC Environment Fails With Errors
ORA-29913 ORA-31640 ORA-19505 ORA-27037 (文档 ID 1173765.1)
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 > 1. The problem with this setup is that the PQ/PX slaves are
not constrained to the RAC instance from which the IMPDP operation has
been started, and when such a PQ/PX slave doesn't have access to the
dump file, the errors are raised.
参数CLUSTER : Default=Y 在本案中设置为N即可顺利导入
若有正在导入的impdp语句,需要先停掉
1: ps -ef |grep impdp 找到进程号先kill
2:查询job
select * from dba_datapump_jobs;
3: 登录进去impdp \'/ as sysdba\' attach= SYS_IMPORT_SCHEMA_01
kill_job停止响应job即可
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/61604/viewspace-2051305/,如需转载,请注明出处,否则将追究法律责任。