Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 添加ASM磁盘组后，执行SQL时后台报错，rac 重启 ...

61 积分	0 好友	1 主题

发消息

[Exadata硬件] 添加ASM磁盘组后，执行SQL时后台报错，rac 重启

1^#

发表于 2012-12-4 23:15:50 | 查看: 4431| 回复: 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有时间烦请帮忙指点下谢过了

日志在附件里