oracle@db01:/oraapp/oracle/backup>impdp \'/ as sysdba\' directory=DB_BACKUP dumpfile=newdb.20140918.dmp logfile=newdb_0919.log parallel=4 c>
Import: Release 11.2.0.3.0 - Production on Fri Sep 19 11:27:12 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Master table "SYS"."SYS_IMPORT_FULL_04" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_FULL_04": "/******** AS SYSDBA" directory=DB_BACKUP dumpfile=newdb.20140918.dmp logfile=newdb_0919.log parallel=4 content=all full=y Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "H1"."TRDX_FEE_TABLE" failed to load/unload and is being skipped due to error: ORA-31640: unable to open dump file "/oraapp/oracle/backup/newdb.20140918.dmp" for read ORA-19505: failed to identify file "/oraapp/oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3 ORA-31693: Table data object "H1"."TRDX_Q" failed to load/unload and is being skipped due to error: ORA-31640: unable to open dump file "/oraapp/oracle/backup/newdb.20140918.dmp" for read ORA-19505: failed to identify file "/oraapp/oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3 ORA-31693: Table data object "H1"."TRDX_OI" failed to load/unload and is being skipped due to error: ORA-31640: unable to open dump file "/oraapp/oracle/backup/newdb.20140918.dmp" for read ORA-19505: failed to identify file "/oraapp/oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3 ORA-31693: Table data object "H1"."TRDX_Q" failed to load/unload and is being skipped due to error: ORA-31640: unable to open dump file "/oraapp/oracle/backup/newdb.20140918.dmp" for read ORA-19505: failed to identify file "/oraapp/oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3
Import> exit
SQL> select * from v$version;
BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production
SQL>
使用expdp导入数据到Rac环境，parallel 并行为4，发现导入报以上错误，分析发现Rac环境使用并行导入时会尝同时写
数据库到两个节点，如果目录在本地磁盘， 则导入时候会报此错误。（导出时也存在此问题） 解决办法是在导出导入的时候加上cluster参数等于N进行单节点导入操作。 即：impdp \'/ as sysdba\' directory=db |