首页 > 解决方案 > 使用 impdp 命令导入 oracle 数据库更新时出错

问题描述

通过 impdp 命令导入 oracle 数据库更新时,我遇到了一个奇怪的错误(ORA-31693、ORA-31645、ORA-19501、ORA-27070、OSD-04016)。

以下是错误日志,请帮助我解决此错误

    ;;; 
Import: Release 12.2.0.1.0 - Production on Fri Nov 2 10:56:03 2018

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

. . imported "ACSELE_BRHN"."COBERTURAS"                  12.51 GB 11916056 rows
ORA-31693: Table data object "ACSELE_BRHN"."THIRDPARTYMOVEMENTRISKUNIT" failed to load/unload and is being skipped due to error:
ORA-31645: unable to read from dump file "D:\app\OracleHomeUser1\admin\orcl\dpdump\/739D4E707E75409582A9155D63EFDF44\Backup05-10-2018-Pre_ProdWi.dmp"
ORA-19501: read error on file "D:\app\OracleHomeUser1\admin\orcl\dpdump\/739D4E707E75409582A9155D63EFDF44\Backup05-10-2018-Pre_ProdWi.dmp", block number 4720640 (block size=4096)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
. . imported "ACSELE_BRHN"."STPO_POLICYASLPHYSICAL"      1.548 GB  811657 rows
. . imported "ACSELE_BRHN"."OASALDOSDEUDORES"            1.131 GB 6014979 rows
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-31643: unable to close dump file "D:\app\OracleHomeUser1\admin\orcl\dpdump\/739D4E707E75409582A9155D63EFDF44\Backup05-10-2018-Pre_ProdWi.dmp"
ORA-06512: at "SYS.KUPW$WORKER", line 2380
ORA-19501: read error on file "D:\app\OracleHomeUser1\admin\orcl\dpdump\/739D4E707E75409582A9155D63EFDF44\Backup05-10-2018-Pre_ProdWi.dmp", block number 5879680 (block size=4096)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
ORA-19501: read error on file "D:\app\OracleHomeUser1\admin\orcl\dpdump\/739D4E707E75409582A9155D63EFDF44\Backup05-10-2018-Pre_ProdWi.dmp", block number 5879872 (block size=4096)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
ORA-06512: at "SYS.KUPD$DATA_INT", line 1386
ORA-06512: at line 2
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-31643: unable to close dump file "D:\app\OracleHomeUser1\admin\orcl\dpdump\/739D4E707E75409582A9155D63EFDF44\Backup05-10-2018-Pre_ProdWi.dmp"
ORA-06512: at "SYS.KUPW$WORKER", line 2380

ORA-19501: read error on file "D:\app\OracleHomeUser1\admin\orcl\dpdump\/739D4E707E75409582A9155D63EFDF44\Backup05-10-2018-Pre_ProdWi.dmp", block number 5880000 (block size=4096)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
ORA-19501: read error on file "D:\app\OracleHomeUser1\admin\orcl\dpdump\/739D4E707E75409582A9155D63EFDF44\Backup05-10-2018-Pre_ProdWi.dmp", block number 5879872 (block size=4096)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
ORA-06512: at "SYS.KUPD$DATA_INT", line 1386

Job "SYSTEM"."SYS_IMPORT_SCHEMA_04" stopped due to fatal error at Fri Nov 2 11:32:02 2018 elapsed 0 00:35:47

标签: oracleoracle11gimpdp

解决方案


推荐阅读