Expdp ora-31640, ora-19505

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,201 1, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing optionsMaster table "SYS ". "SYS_IMPORT_FULL_04" successfully loaded/unloadedStarting "SYS ". "SYS_IMPORT_FULL_04 ": "/******** as sysdba" directory = DB_BACKUP dumpfile = mongologfile = newdb_0919.log parallel = 4 content = all full = y Processing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT /jsonobject type partition/jsonobject type SCHEMA_EXPORT/jsonobject type partition/PRE_SCHEMA/jsonobject type SCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessing object type partition/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/TABLE_DATAORA-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 readORA-19505: failed to identify file "/oraapp/oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file statusIBM aix risc System/6000 Error: 2: No such file or directoryAdditional information: 3ora-000093: 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 readORA-19505: failed to identify file "/oraapp/oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file statusIBM aix risc System/6000 Error: 2: No such file or directoryAdditional information: 3ora-000093: 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 readORA-19505: failed to identify file "/oraapp/oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file statusIBM aix risc System/6000 Error: 2: No such file or directoryAdditional information: 3ora-000093: 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 readORA-19505: failed to identify file "/oraapp/oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file statusIBM aix risc System/6000 Error: 2: No such file or directoryAdditional information: 3
Import> exit

SQL> select * from v $ version;
BANNER implements Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-ProductionCORE 11.2.0.3.0 ProductionTNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0-ProductionNLSRTL Version 11.2.0.3.0-Production
SQL>
When using expdp to import data to the Rac environment, parallel performs this operation 4. The preceding error is reported during the import. The analysis shows that when using parallel import in the Rac environment, the database is written to both nodes at the same time, if the directory is on a local disk, this error is reported during import. (This problem also exists during export) the solution is to add the cluster parameter N when exporting and importing a single node. That is: 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 rowsORA-31693: Table data object "H1 ". "TRDX_P" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing dataORA-12081: update operation not allowed on table "H1 ". "TRDX_P ".. imported "H1 ". "TRDX_QU" 5.687 MB 18639 rowsORA-31693: Table data object "H1 ". "TRDX_HL" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing dataORA-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 rowsORA-31693: Table data object "H1 ". "TRDX_ASSE" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing dataORA-12081: update operation not allowed on table "H1 ". "TRDX_ASSET"

The preceding error occurs during import. According to the description of Mos [Doc 1270847.1], the materialized views exist in these tables. We recommend that you use the TABLE_EXISTS_ACTION = APPEND parameter to import data. The default value of this parameter is SKIP.

Oracle impdp Problems

Have you created the recoverpath directory in the database?
SQL> Create Or Replace Directory 'recoverpath' as '/data/recover ';
SQL> Grant read, write on Directory 'recoverpath' to user;