admin管理员组

文章数量:1654021

[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。

 

本文标签： identifyfilefailedORAdmp

版权声明：本文标题：ORA-19505: failed to identify file "orabakexpdpTB201411.dmp" 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://www.elefans.com/dianzi/1729650433a1208973.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。