expdp ora-31640 ora-19505

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_backup dumpfile=newdb.dmp logfile=newdb.log  parallel=4 content=all full=y cluster=n

. . imported "H1"."TRDX_OC"     5.950 MB   60692 rows

. . imported "H1"."TRDX_Q"         4.643 MB   15728 rows

ORA-31693: Table data object "H1"."TRDX_P" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-12081: update operation not allowed on table "H1"."TRDX_P"

. . imported "H1"."TRDX_QU"         5.687 MB   18639 rows

ORA-31693: Table data object "H1"."TRDX_HL" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-12081: update operation not allowed on table "H1"."TRDX_HLD"

. . imported "H1"."TRDX_API_TX"           5.079 MB   48360 rows

. . imported "H1"."TRDX_DE"     4.361 MB   91505 rows

ORA-31693: Table data object "H1"."TRDX_ASSE" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-12081: update operation not allowed on table "H1"."TRDX_ASSET"

导入的同时出现以上错误，根据Mos [Doc 1270847.1]描述是由于这些表上存在物化视图，建议使用TABLE_EXISTS_ACTION=APPEND参数导入数据；

此参数默认是SKIP。