ORA-19505: failed to identify file ＂/oradata1/dump/CASCTRL07

ora-19505都是因为文件出错，无法读取造成的，有因为二进制文件被编辑的，如spfile损坏；有文件ftp丢帧的问题，如上面的case；

expdp 出错
 
$ impdp system/manager directory=dmp content=metadata_only dumpfile=casctrl01.dmp, casctrl02.dmp, casctrl03.dmp, casctrl04.dmp, casctrl05.dmp, casctrl06.dmp, casctrl07.dmp, casctrl08.dmp full=y logfile=metadata_only_20130627.log job_name=my_job02  parallel=8
 

Import: Release 10.2.0.5.0 - 64bit Production on Thursday, 27 June, 2013 11:16:32
 
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
 With the Partitioning, OLAP, Data Mining and Real Application Testing options
 ORA-39002: invalid operation
 ORA-31694: master table "SYSTEM"."MY_JOB02" failed to load/unload
 ORA-31640: unable to open dump file "/oradata1/dump/CASCTRL07.DMP" for read
 ORA-19505: failed to identify file "/oradata1/dump/CASCTRL07.DMP"
 ORA-27046: file size is not a multiple of logical block size
 Additional information: 1
 Additional information: 1514345468
 Additional information: 4096
 
原因： 文件出错，重新ftp一次就可以了。
 
总结： ora-19505都是因为文件出错，无法读取造成的，有因为二进制文件被编辑的，如spfile损坏；有文件ftp丢帧的问题，如上面的case；

秘塔写作猫

秘塔写作猫是一个集AI写作、校对、润色、配图等为一体的创作平台

127

查看详情