作者公众号,欢迎一起交流。
问题描述:
在一次使用数据泵导入工具IMPDP将Oracle 12C 单机环境的数据库迁移至Oracle 12C RAC环境时,出现了如下“ORA-31640: unable to open dump file”错误,具体操作如下:
[oracle@prodrac12cdb01 ~]$impdp fordba/[email protected]:1521/ncpdb directory=ORACLEBACKUPDIR dumpfile=ncwholedb_%U.dmp logfile=ncwholedb.log schemas=SYNUSER,OPERQRY,FINCOSO,ZTREAD,LOGAN65 parallel=8
.............................中间过程省略.............................
ORA-31640: unable to open dump file "/u01/app/oracle/pdump/ncwholedb_01.dmp" for read
ORA-19505: failed to identify file "/u01/app/oracle/pdump/ncwholedb_01.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
问题分析:
1、查看ORA-31640错误
[oracl