免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3714 | 回复: 4
打印 上一主题 下一主题

RAC无法找到已建立的asm磁盘卷 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2008-12-15 13:20 |只看该作者 |倒序浏览
RAC安装过程中,在linux1上建立4个磁盘卷,在linux1、linux2上都能看到这四个磁盘卷:
# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4

安装完成后,数据库正常运行。
运行一段时间后,在linux2上无法连接实例ORCL2,查看日志:/u01/app/oracle/admin/orcl/bdump/alert_orcl2.log
发现:
Mon Dec 15 06:16:23 2008
GES: Potential blocker (pid=22435) on resource TX-0x40003-0x20535;
enqueue info in file /u01/app/oracle/admin/orcl/udump/orcl1_ora_22433.trc and DIAG trace file
Mon Dec 15 06:17:48 2008
Reread from mirror side 'VOL3' returns corrupted data
Reread from mirror side 'VOL1' returns corrupted data
WARNING: requested mirror side 2 of virtual extent 4 offset 49152 is not allocated; I/O request failed
Read from controlfile member '+ORCL_DATA1/orcl/controlfile/current.256.659809709' has found a fractured block (blk# 35, seq# 0)
Hex dump of (file 0, block 35) in trace file /u01/app/oracle/admin/orcl/bdump/orcl1_lmon_8622.trc
Corrupt block relative dba: 0x00000023 (file 0, block 35)
Bad header found during control file block read
Data in bad block:
type: 0 format: 2 rdba: 0x08652686
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000001
check value in block header: 0x89e3
computed block checksum: 0x0
Mon Dec 15 06:17:48 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_lmon_8622.trc:
ORA-00202: control file: '+ORCL_DATA1/orcl/controlfile/current.256.659809709'
ORA-15205: requested mirror side unavailable
Mon Dec 15 06:17:48 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_lmon_8622.trc:
ORA-00227: corrupt block detected in control file: (block 35, # blocks 1)
ORA-00202: control file: '+ORCL_DATA1/orcl/controlfile/current.256.659809709'
ORA-15205: requested mirror side unavailable
LMON: terminating instance due to error 227
Mon Dec 15 06:17:48 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_lms3_8638.trc:
ORA-00227: corrupt block detected in control file: (block , # blocks )
Mon Dec 15 06:17:48 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_lms0_8626.trc:
ORA-00227: corrupt block detected in control file: (block , # blocks )
Mon Dec 15 06:17:48 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_lms2_8634.trc:
ORA-00227: corrupt block detected in control file: (block , # blocks )
Mon Dec 15 06:17:48 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_lms1_8630.trc:
ORA-00227: corrupt block detected in control file: (block , # blocks )
Mon Dec 15 06:17:48 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_pmon_8616.trc:
ORA-00227: corrupt block detected in control file: (block , # blocks )
Mon Dec 15 06:17:48 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_lmd0_8624.trc:
ORA-00227: corrupt block detected in control file: (block , # blocks )
Mon Dec 15 06:17:49 2008
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_diag_8618.trc:
ORA-00600: internal error code, arguments: [kjzcreaprqhq1], [], [], [], [], [], [], []
Instance terminated by LMON, pid = 8622

再在Linux2上执行:
# /etc/init.d/oracleasm listdisks
VOL2
VOL4

该怎么解决这种问题?? 由于本人账号是刚申请没有积分 麻烦大家帮帮忙 谢谢

论坛徽章:
0
2 [报告]
发表于 2008-12-15 16:38 |只看该作者
ORA-00600: internal error code, arguments: [kjzcreaprqhq1], [], [], [], [], [], [], []
Instance terminated by LMON, pid = 8622

你中奖了,呵呵。
上metalink查一下吧。

你创建数据库的时候选择的冗余是哪个选项?

论坛徽章:
0
3 [报告]
发表于 2008-12-15 17:37 |只看该作者
我觉得主要原因是无法找到磁盘卷,由此引发其他错误。。。

论坛徽章:
0
4 [报告]
发表于 2008-12-15 17:59 |只看该作者
什么版本?

论坛徽章:
0
5 [报告]
发表于 2008-12-16 09:58 |只看该作者
Release 10.2.0.1.0
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP