- 最后登录
- 2012-12-7
- 在线时间
- 10 小时
- 威望
- 61
- 金钱
- 334
- 注册时间
- 2012-3-21
- 阅读权限
- 50
- 帖子
- 16
- 精华
- 0
- 积分
- 61
- UID
- 314
|
1#
发表于 2012-12-4 23:15:50
|
查看: 4503 |
回复: 2
本帖最后由 Metadata 于 2012-12-5 09:24 编辑
11g 11.2.0.3 RAC
磁盘组
PATH STATE NAME
-------------------- -------- ------------------------------
ORCL:DATA_VOL1 NORMAL DATA_VOL1
ORCL:DATA_VOL2 NORMAL DATA_VOL2
ORCL:DATA_VOL3 NORMAL DATA_VOL3
ORCL:DATA_VOL4 NORMAL DATA_VOL4
ORCL:DATA_VOL5 NORMAL DATA_VOL5
ORCL:DATA_VOL6 NORMAL DATA_VOL6
ORCL:DATA_VOL7 NORMAL DATA_VOL7
ORCL:DATA_VOL8 NORMAL DATA_VOL8
ORCL:DATA_VOL9 NORMAL DATA_VOL9
ORCL:OCR_VOL1 NORMAL OCR_VOL1
ORCL:OCR_VOL2 NORMAL OCR_VOL2
ORCL:OCR_VOL3 NORMAL OCR_VOL3
其中 ORCL:DATA_VOL8 ORCL:DATA_VOL9 是新加的,加完后 执行SQL一直报IO错误
insert /*+parallel(t_yskm_skzhid,4)*/ into t_yskm_skzhid nologging
*
ERROR at line 1:
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 13: '+DATA01/tips/datafile/cq_zgxt_002.dbf'
ORA-15055: unable to connect to ASM instance
查询v$asm_disk时 均有读错误
SQL> select name,READ_ERRS,STATE,WRITE_ERRS from v$asm_disk;
NAME READ_ERRS STATE WRITE_ERRS
------------------------------ ---------- -------- ----------
DATA_VOL1 0 NORMAL 0
DATA_VOL2 0 NORMAL 0
DATA_VOL3 0 NORMAL 0
DATA_VOL4 0 NORMAL 0
DATA_VOL5 0 NORMAL 0
DATA_VOL6 0 NORMAL 0
DATA_VOL7 0 NORMAL 0
DATA_VOL8 10 NORMAL 0
DATA_VOL9 5 NORMAL 0
OCR_VOL1 0 NORMAL 0
OCR_VOL2 0 NORMAL 0
OCR_VOL3 0 NORMAL 0
以前 DATA_VOL6 DATA_VOL7 也是几个月前添加的,目前都没问题,就是添加DATA_VOL8时候有问题,后来尝试添加 DATA_VOL9 后就问题不断,现在节点2一直几分钟就重启一次,导致节点一也跟着重启
目前找不到是啥原因,没有头绪 如果MC有时间烦请帮忙指点下 谢过了
日志在附件里
|
|