- 最后登录
- 2016-11-18
- 在线时间
- 33 小时
- 威望
- 16
- 金钱
- 316
- 注册时间
- 2011-10-12
- 阅读权限
- 10
- 帖子
- 39
- 精华
- 0
- 积分
- 16
- UID
- 5
|
1#
发表于 2011-12-22 16:19:43
|
查看: 8236 |
回复: 4
环境:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/ora10g
System name: Linux
Node name: hxzqcx
Release: 2.6.9-78.0.0.0.1.ELlargesmp
Version: #1 SMP Fri Jul 25 16:15:22 EDT 2008
Machine: x86_64
在数据库里面发现如下错误信息:
Tue Dec 20 14:58:57 2011
Read from controlfile member '/oradata/hxlscx/control02.ctl' has found a corrupted block (blk# 3, seq# 0)
Hex dump of (file 0, block 3) in trace file /oracle/admin/hxlscx/udump/hxlscx_ora_28551.trc
Corrupt block relative dba: 0x00000003 (file 0, block 3)
Bad check value found during control file block read
Data in bad block:
type: 21 format: 2 rdba: 0x00000003
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00001501
check value in block header: 0x139b
computed block checksum: 0x1
Re-read from controlfile member '/oradata/hxlscx/control02.ctl' returned valid block 3
Tue Dec 20 19:02:33 2011
Thread 1 advanced to log sequence 2337 (LGWR switch)
Current log# 3 seq# 2337 mem# 0: /oradata/hxlscx/redo03.log
Tue Dec 20 19:03:08 2011
Thread 1 advanced to log sequence 2338 (LGWR switch)
Current log# 4 seq# 2338 mem# 0: /oradata/hxlscx/redo04.log
Tue Dec 20 19:04:29 2011
Thread 1 advanced to log sequence 2339 (LGWR switch)
Current log# 5 seq# 2339 mem# 0: /oradata/hxlscx/redo05.log
Tue Dec 20 19:07:08 2011
Thread 1 advanced to log sequence 2340 (LGWR switch)
Current log# 1 seq# 2340 mem# 0: /oradata/hxlscx/redo01.log
trace 文件:
/oracle/admin/hxlscx/udump/hxlscx_ora_28551.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/ora10g
System name: Linux
Node name: hxzqcx
Release: 2.6.9-78.0.0.0.1.ELlargesmp
Version: #1 SMP Fri Jul 25 16:15:22 EDT 2008
Machine: x86_64
Instance name: hxlscx
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 28551, image: [email=oracle@hxzqcx]oracle@hxzqcx[/email] (TNS V1-V3)
*** 2011-12-20 14:58:57.340
*** ACTION NAME:() 2011-12-20 14:58:57.275
*** MODULE NAME:([email=vagentd@hxzqcx]vagentd@hxzqcx[/email] (TNS V1-V3)) 2011-12-20 14:58:57.275
*** SERVICE NAME:(SYS$USERS) 2011-12-20 14:58:57.275
*** SESSION ID:(1636.93) 2011-12-20 14:58:57.275
*** 2011-12-20 14:58:57.340
Read from controlfile member '/oradata/hxlscx/control02.ctl' has found a corrupted block (blk# 3, seq# 0)
Hex dump of (file 0, block 3)
Dump of memory from 0x0000002A9737BE00 to 0x0000002A9737FE00
2A9737BE00 0000C215 00000003 00000000 04010000 [................]
2A9737BE10 0000139B 00000002 00000000 00000079 [............y...]
2A9737BE20 00000920 00153E81 00000000 00000920 [ ....>...... ...]
2A9737BE30 00153FB6 00000000 EB5715FB 0000000E [.?........W.....]
2A9737BE40 2DEB50B0 28D777F6 060F63DC 00000000 [.P.-.w.(.c......]
2A9737BE50 2DD51468 628423F2 00000000 00000000 [h..-.#.b........]
2A9737BE60 00000000 00000000 00000000 00000000 [................]
Repeat 1016 times
2A9737FDF0 00000000 00000000 00000000 00001501 [................]
Corrupt block relative dba: 0x00000003 (file 0, block 3)
Bad check value found during control file block read
Data in bad block:
type: 21 format: 2 rdba: 0x00000003
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00001501
check value in block header: 0x139b
computed block checksum: 0x1
Re-read from controlfile member '/oradata/hxlscx/control02.ctl' returned valid block 3
这种情况是不是磁盘有坏块? |
|