RAC挂载共享磁盘组

1.查看共享磁盘组状态

节点1：状态正常

SQL> SELECT INSTANCE_NAME FROM V$INSTANCE;

INSTANCE_NAME

----------------

coredb1

SQL> SELECT T.GROUP_NUMBER, T.NAME, T.TOTAL_MB, T.STATE FROM V$ASM_DISKGROUP T;

GROUP_NUMBER NAME                             TOTAL_MB STATE

------------ ------------------------------ ---------- -----------

           1 DATA                                10240 CONNECTED

           2 FLASH                               10240 MOUNTED

节点2：状态不正常

SQL> SELECT INSTANCE_NAME FROM V$INSTANCE;

INSTANCE_NAME

----------------

coredb2

SQL> SELECT T.GROUP_NUMBER, T.NAME, T.TOTAL_MB, T.STATE FROM V$ASM_DISKGROUP T;

GROUP_NUMBER NAME                             TOTAL_MB STATE

------------ ------------------------------ ---------- -----------

           1 DATA                                10240 CONNECTED

           0 FLASH                                   0  DISMOUNTED

2.解决磁盘处于DISMOUNTED状态问题

在当前节点执行

[root@coredb2 ~]# su - grid

[grid@coredb2 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 31 07:08:55 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysasm

Connected.

SQL> SELECT T.GROUP_NUMBER, T.NAME, T.TOTAL_MB, T.STATE FROM V$ASM_DISKGROUP T;

GROUP_NUMBER NAME                             TOTAL_MB STATE

------------ ------------------------------ ---------- -----------

           1 DATA                                10240 MOUNTED

           0 FLASH                                   0 DISMOUNTED

SQL> ALTER DISKGROUP FLASH MOUNT;

Diskgroup altered.

SQL> SELECT T.GROUP_NUMBER, T.NAME, T.TOTAL_MB, T.STATE FROM V$ASM_DISKGROUP T;

GROUP_NUMBER NAME                             TOTAL_MB STATE

------------ ------------------------------ ---------- -----------

           1 DATA                                10240 MOUNTED

           2 FLASH                               10240 MOUNTED