这种错误怎么解决?

yangliu3000 2003-09-15 08:42:37
1 我往一个表中插入某一条记录时,出现如下错误,怎么解决?
oracle data block corrupted (file#4,block#38459)
data file 4:'d:\mcqt\data\indx1mcqt.odb)
preceding 2 lines from mcqt_db
2 我查询一表中某条记录时,出错,其它记录不出错。
ora-01115: io error reading block from file 4(block # 18225)
ora-01110: data file 4:'d:\mcht\data\indx1mcht.odb'
ora-09206:sfrfb:error reading from file
osd-04006: readfile() failure,unable to read from file
o/s-error:(os 203)操作系统找不到已输入的环境选项。
怎么解决才能插入记录和查询记录呀?

...全文
119 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
smilingday 2003-09-15
  • 打赏
  • 举报
回复
可能是数据库文件出了问题,可以用oracle 的recovery修复一下
ColinGan 2003-09-15
  • 打赏
  • 举报
回复
可能原因:数据库文件损坏或磁盘阵列部分损坏

相关错误码及处理方法如下:
ORA-01111 name for data file string is unknown - rename to correct file
Cause: The datafile was missing from a CREATE CONTROLFILE command or BACKUP CONTROLFILE RECOVERY was done with a control file that was saved before the file was created.
Action: Rename the MISSING file to the name of the real file.

ORA-01115 IO error reading block from file string (block # string)
Cause: The device on which the file resides is probably off line.
Action: Restore access to the device, then retry the operation.

ORA-09206 sfrfb: error reading from file
Cause: File may have been truncated or corrupted.
Action: See OSD error accompanying this message.

17,082

社区成员

发帖
与我相关
我的任务
社区描述
Oracle开发相关技术讨论
社区管理员
  • 开发
  • Lucifer三思而后行
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧