Hi,
Show error ORA-31693 | ORA-29913 | ORA-31640 when impdp data using data pump ?
My source DB environment:
DB version: Oracle 11.2.0.4.0 Data Guard primary for Linux x64 Characterset: AMERICAN_AMERICA.AL32UTF8
and target DB environment:
DB version: Oracle 11.2.0.4.0 RAC for Linux x64 Characterset: AMERICAN_AMERICA.ZHS16GBK
Now,my operating process is as follows,
[oracle@orac1 ~]$ impdp system/oracle directory=impdp parallel=3 dumpfile=sd_res_id_case_20171110_%U.dmp logfile=impdp_sd_res_id_case_20171110.log remap_schema=szd_resource_v2:res remap_tablespace=szd_resource_v2:res,szd_resource_v3:res1,szd_resource_v2_temp:res_temp,szd_resource_v3_temp:res1_temp tables=szd_resource_v2.sd_res_id_case statistics=none indexes=y
Import: Release 11.2.0.4.0 - Production on Fri Nov 10 13:53:17 2017
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
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "indexes=TRUE" Location: Command Line, ignored.
Legacy Mode Parameter: "statistics=none" Location: Command Line, ignored.
Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/******** directory=impdp parallel=3 dumpfile=sd_res_id_case_20171110_%U.dmp logfile=impdp_sd_res_id_case_20171110.log remap_schema=szd_resource_v2:res remap_tablespace=szd_resource_v2:res,szd_resource_v3:res1,szd_resource_v2_temp:res_temp,szd_resource_v3_temp:res1_temp tables=szd_resource_v2.sd_res_id_case
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "RES"."SD_RES_ID_CASE" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-31640: unable to open dump file "/app/oracle/impdp/sd_res_id_case_20171110_02.dmp" for read
ORA-19505: failed to identify file "/app/oracle/impdp/sd_res_id_case_20171110_02.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at Fri Nov 10 13:54:17 2017 elapsed 0 00:00:55
Hence,i check ORA errors above,
[oracle@orac1 ~]$ oerr ora 31693
31693, 00000, "Table data object %s failed to load/unload and is being skipped due to error:\n%s"
// *Cause: Table failed to load or unload due to some error.
// *Action: Check load/unload error, correct problem and retry command.
[oracle@orac1 ~]$
[oracle@orac1 ~]$ oerr ora 29913
29913, 00000, "error in executing %s callout"
// *Cause: The execution of the specified callout caused an error.
// *Action: Examine the error messages take appropriate action.
[oracle@orac1 ~]$
[oracle@orac1 ~]$ oerr ora 31640
31640, 00000, "unable to open dump file \"%s\" for read"
// *Cause: Import was unable to open the export file for reading. This
// message is usually followed by device messages from the operating
// system.
// *Action: Take appropriate action to restore the device.
Please help me for solving this issue,thanks!
Best Regards,
Quanwen Zhao