[oracle@erpcrmtest expdp]$ impdp userid=\"/ as sysdba\" DIRECTORY=DATA_EXP parallel=8 DUMPFILE=TB201411.dmp logfile=impdp_TB201411.log
Import: Release 11.2.0.3.0 - Production on Tue Dec 16 09:12:40 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, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORA-39002: invalid operation ORA-31694: master table "SYS"."SYS_IMPORT_FULL_07" failed to load/unload ORA-31640: unable to open dump file "/orabak/expdp/TB201411.dmp" for read ORA-19505: failed to identify file "/orabak/expdp/TB201411.dmp" ORA-27046: file size is not a multiple of logical block size Additional information: 1
原因:读文件出错,需要重新ftp 总结: ora-19505都是因为文件出错,无法读取造成的,有因为二进制文件被编辑的,有文件ftp丢帧的问题,如上面的case。
ORA-19505: failed to identify file "/orabak/expdp/TB201411.dmp"
最新推荐文章于 2024-02-28 14:14:22 发布