集群RAC数据泵导入的2个问题

集群环境，数据泵导入的2个问题

问题1：tnsnames中的连接串有负载均衡

Import: Release 11.2.0.4.0 - Production on Tue Sep 9 10:46:08 2014


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation


原因可能：
1.是directory创建有问题
2.directory权限问题
3.tnsnames有负载均衡，连接到了另1个实例，而另1个实例中没有创建相关目录。解决的方法是使用只能连接到当前实例的连接串。

问题2：并行未关闭集群特性

  
ORA-31693: Table data object "PERA"."ERM_FUNCPRIVILEGETPL" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/home/oracle/dump/ZSH161_20140905.DMP" for read
ORA-19505: failed to identify file "/home/oracle/dump/ZSH161_20140905.DMP"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


原因：


在impdp时指定了parallel，这时，数据泵会将一部任务交到另1个实例上去执行，而另1个实例如果没有创建目录，并存放文件的话，就会报上面的错。
解决的方法是加参数：cluster=N


修改后可以参考的导入写法：


impdp system/oracle@zsgl1 directory=DUMPDIR dumpfile=ZSH161_20140905.DMP logfile=impdp_pera_20140909.log  schemas=pera parallel=10 cluster=N