douzhi19802003

暂无签名

  • 博客访问: 40139
  • 博文数量: 15
  • 用 户 组: 普通用户
  • 注册时间: 1970-01-01 08:00
个人简介

鏆傛棤浠嬬粛

文章分类
文章存档

2006年(5)

2005年(8)

2000年(2)

我的朋友

分类: Oracle

2006-07-18 12:14:51

早上一来就发现DB停了,查看alert.log日志中有这样的描述:

Mon Jul 17 20:32:21 2006

Errors in file

/home/oracle/admin/scbladb2/bdump/db2_lgwr_6061.trc:

ORA-00340: IO error processing online log 3 of thread 1

ORA-00345: redo log write error block 107568 count 2

ORA-00312: online log 3 thread 1:

'/home/oracle/oradata/db2/redo03.log'

ORA-27072: skgfdisp: I/O error

Linux Error: 5: Input/output error

Additional information: 107567

Mon Jul 17 20:32:21 2006

解释:

ORA-00340 IO error processing online log string of thread string

Cause: An I/O error occurred on the named online log.

Action: Restore accessibility to the file or restore the file from backup.

ORA-00345 redo log write error block string count string

Cause: An I/O error occurred while writing the log.

Action: Correct the cause of the error, and then restart the system. If the log is lost, apply media/incomplete recovery

ORA-00312 online log string thread string: 'string'

Cause: This message reports the file name for details of another message.

Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.

通过系统提示错误,说明os级的io出了问题,导致写入信息到redo03出现问题。数据库是9204,os是red hat。

试着startup数据库,可以启动成功。后来新创建了一个日志组4,删除了日志组3。等过几个小时再看看,db有什么问题没有。

这里有个类似问题的帖子,虽然具体情况不一样:http://www.itpub.net/showthread.php?s=&threadid=578305&perpage=10&pagenumber=1

其中有一段话:

quote:

This is a reasonably well known problem on NT. Generally the error is seen when a routine NT file system backup takes a byte-range lock on one of the Oracle datafiles in that file system in order to back it up. There are many solutions, such as configuring the backup software to skip open files, or at least not to lock them; or you can use ocopy to copy the datafiles and back those up instead; or you can shutdown the instance; and so on.

[@more@]
阅读(44383) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册