Bug of Prod of Oracle
上一篇 /
下一篇 2006-03-09 00:00:00
/ 个人分类：Oracle管理文章
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: skgfdisp：I/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
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
