« ACOUG 11月活动召集 - RAC与Latch竞争 | Blog首页 | Oracle数据库恢复:归档日志损坏案例一则 »
attempt to access beyond end of device很危险
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2010/11/attempt_to_access_beyond_device.html
最近帮助客户处理了一次数据库异常,异常导致数据库崩溃,以ORA-00600 4193/4194错误无法启动,系统表空间数据文件出现坏块。链接:https://www.eygle.com/archives/2010/11/attempt_to_access_beyond_device.html
检查操作系统日志时,发现有如下提示信息:
Nov 13 15:04:49 ERPDB2 kernel: attempt to access beyond end of device
Nov 13 15:04:49 ERPDB2 kernel: sdg1: rw=0, want=6762857232, limit=80003040
Nov 13 15:04:49 ERPDB2 kernel: attempt to access beyond end of device
Nov 13 15:04:49 ERPDB2 kernel: sdg1: rw=0, want=1393660168, limit=80003040
Nov 13 15:04:49 ERPDB2 kernel: attempt to access beyond end of device
Nov 13 15:04:49 ERPDB2 kernel: sdg1: rw=0, want=4322953480, limit=80003040
Nov 13 15:04:49 ERPDB2 kernel: attempt to access beyond end of device
Nov 13 15:04:49 ERPDB2 kernel: sdg1: rw=0, want=13036106512, limit=80003040
Nov 13 15:04:49 ERPDB2 kernel: attempt to access beyond end of device
Nov 13 15:04:49 ERPDB2 kernel: sdg1: rw=0, want=13609009592, limit=80003040
Nov 13 15:04:49 ERPDB2 kernel: attempt to access beyond end of device
Nov 13 15:04:49 ERPDB2 kernel: sdg1: rw=0, want=4346982664, limit=80003040
Nov 13 15:04:49 ERPDB2 kernel: attempt to access beyond end of device
Nov 13 15:04:49 ERPDB2 kernel: sdg1: rw=0, want=13707094408, limit=80003040
关于attempt to access beyond end of device的错误,以前也曾经遇到过一次,请参考案例:圣诞超级复杂困难之Oracle数据库大恢复
这类提示的具体原因我不是很清楚,估计是在读写文件时出现地址越界,导致数据库故障。
系统是Linux环境,Release: 2.6.9-34.ELhugemem,最后通过备份帮助用户恢复了数据。
历史上的今天...
>> 2017-11-15文章:
>> 2012-11-15文章:
>> 2011-11-15文章:
>> 2009-11-15文章:
>> 2008-11-15文章:
>> 2006-11-15文章:
>> 2005-11-15文章:
>> 2004-11-15文章:
By eygle on 2010-11-15 15:01 | Comments (0) | Case | 2659 |