ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Bug of Prod of Oracle

Bug of Prod of Oracle

原创 Linux操作系统 作者:yanggq 时间:2019-07-22 20:30:02 0 删除 编辑
A bug of Oracle 8.0.5.2

When I query GL_JE_LINES, it prompt like following:

20:42:55 ORA-01115: 从文件8读取块时出现 IO 错误(块#1048578

20:42:55 ORA-01110: 数据文件8'/u02/appldata/PROD/find01.dbf'

20:42:55 ORA-27072: skgfdispI/O 错误

20:42:55 SVR4 Error: 25: Inappropriate ioctl for device

20:42:55 Additional information: 1048546

20:42:55 ORA-02063: 紧接着5 lines(源于PROD.WORLD.APPS

Database in archive log mode, Oracle 8.0.5.2.1, Solaris 5.6

Maybe there are some corruption of Datafile, Then I do following:

Alter database datafile '/u02/appldata/PROD/find01.dbf' offline;

Recover datafile '/u02/appldata/PROD/find01.dbf';

Alter database datafile '/u02/appldata/PROD/find01.dbf' online;

But it still prompt the same error , then I checked in metalink found that it is a bug 774252 of Oracle.

Contact with Oracle Support, got a patch for the bug fix

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26706/viewspace-64588/,如需转载,请注明出处,否则将追究法律责任。

上一篇: DBA三准则
请登录后发表评论 登录
全部评论

注册时间:2002-10-29

  • 博文量
    78
  • 访问量
    50507