Oracle DBA Script - check ASM health
At Storage Cell, found some disks are dropped:
[root@xcel02 ~]# cellcli -e list griddisk attributes name,status,asmmodestatus,asmdeactivationoutcome |grep DROPPED
DATA_X_CD_01_xcel02 active DROPPED Yes
RECO_X_CD_01_xcel02 active DROPPED Yes
[root@xcel02 ~]#
Check ASM status
Using username "oracle".
oracle@xdb01's password:
Last login: from
[oracle@xdb01 ~]$ . oraenv
ORACLE_SID = [oracle] ? +ASM1
The Oracle base has been set to /u01/app/grid
[oracle@xdb01 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.2.0 Production on Wed May 15 09:48:47 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter limit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_power_limit integer 4
SQL> select group_number,name,state from v$asm_diskgroup;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 DATA_X MOUNTED
2 DBFS_DG MOUNTED
3 RECO_X MOUNTED
SQL> select * from v$asm_operation;
no rows selected
SQL> select * from gv$asm_operation where state='RUN';
no rows selected
SQL> select group_number,path,header_status,mount_status,mode_status,name from V$ASM_DISK where path like '%xcel%' order by path, group_number;
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.3/DATA_X_CD_00_xcel01
MEMBER CACHED ONLINE DATA_X_CD_00_XCEL01
1
o/192.168.10.3/DATA_X_CD_01_xcel01
MEMBER CACHED ONLINE DATA_X_CD_01_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.3/DATA_X_CD_02_xcel01
MEMBER CACHED ONLINE DATA_X_CD_02_XCEL01
1
o/192.168.10.3/DATA_X_CD_03_xcel01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DATA_X_CD_03_XCEL01
1
o/192.168.10.3/DATA_X_CD_04_xcel01
MEMBER CACHED ONLINE DATA_X_CD_04_XCEL01
1
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.3/DATA_X_CD_05_xcel01
MEMBER CACHED ONLINE DATA_X_CD_05_XCEL01
1
o/192.168.10.3/DATA_X_CD_06_xcel01
MEMBER CACHED ONLINE DATA_X_CD_06_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.3/DATA_X_CD_07_xcel01
MEMBER CACHED ONLINE DATA_X_CD_07_XCEL01
1
o/192.168.10.3/DATA_X_CD_08_xcel01
MEMBER CACHED ONLINE DATA_X_CD_08_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.3/DATA_X_CD_09_xcel01
MEMBER CACHED ONLINE DATA_X_CD_09_XCEL01
1
o/192.168.10.3/DATA_X_CD_10_xcel01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DATA_X_CD_10_XCEL01
1
o/192.168.10.3/DATA_X_CD_11_xcel01
MEMBER CACHED ONLINE DATA_X_CD_11_XCEL01
2
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.3/DBFS_DG_CD_02_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_02_XCEL01
2
o/192.168.10.3/DBFS_DG_CD_03_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_03_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
2
o/192.168.10.3/DBFS_DG_CD_04_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_04_XCEL01
2
o/192.168.10.3/DBFS_DG_CD_05_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_05_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
2
o/192.168.10.3/DBFS_DG_CD_06_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_06_XCEL01
2
o/192.168.10.3/DBFS_DG_CD_07_xcel01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DBFS_DG_CD_07_XCEL01
2
o/192.168.10.3/DBFS_DG_CD_08_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_08_XCEL01
2
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.3/DBFS_DG_CD_09_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_09_XCEL01
2
o/192.168.10.3/DBFS_DG_CD_10_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_10_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
2
o/192.168.10.3/DBFS_DG_CD_11_xcel01
MEMBER CACHED ONLINE DBFS_DG_CD_11_XCEL01
3
o/192.168.10.3/RECO_X_CD_00_xcel01
MEMBER CACHED ONLINE RECO_X_CD_00_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.3/RECO_X_CD_01_xcel01
MEMBER CACHED ONLINE RECO_X_CD_01_XCEL01
3
o/192.168.10.3/RECO_X_CD_02_xcel01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE RECO_X_CD_02_XCEL01
3
o/192.168.10.3/RECO_X_CD_03_xcel01
MEMBER CACHED ONLINE RECO_X_CD_03_XCEL01
3
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.3/RECO_X_CD_04_xcel01
MEMBER CACHED ONLINE RECO_X_CD_04_XCEL01
3
o/192.168.10.3/RECO_X_CD_05_xcel01
MEMBER CACHED ONLINE RECO_X_CD_05_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.3/RECO_X_CD_06_xcel01
MEMBER CACHED ONLINE RECO_X_CD_06_XCEL01
3
o/192.168.10.3/RECO_X_CD_07_xcel01
MEMBER CACHED ONLINE RECO_X_CD_07_XCEL01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.3/RECO_X_CD_08_xcel01
MEMBER CACHED ONLINE RECO_X_CD_08_XCEL01
3
o/192.168.10.3/RECO_X_CD_09_xcel01
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE RECO_X_CD_09_XCEL01
3
o/192.168.10.3/RECO_X_CD_10_xcel01
MEMBER CACHED ONLINE RECO_X_CD_10_XCEL01
3
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.3/RECO_X_CD_11_xcel01
MEMBER CACHED ONLINE RECO_X_CD_11_XCEL01
1
o/192.168.10.4/DATA_X_CD_00_xcel02
MEMBER CACHED ONLINE DATA_X_CD_00_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.4/DATA_X_CD_02_xcel02
MEMBER CACHED ONLINE DATA_X_CD_02_XCEL02
1
o/192.168.10.4/DATA_X_CD_03_xcel02
MEMBER CACHED ONLINE DATA_X_CD_03_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.4/DATA_X_CD_04_xcel02
MEMBER CACHED ONLINE DATA_X_CD_04_XCEL02
1
o/192.168.10.4/DATA_X_CD_05_xcel02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DATA_X_CD_05_XCEL02
1
o/192.168.10.4/DATA_X_CD_06_xcel02
MEMBER CACHED ONLINE DATA_X_CD_06_XCEL02
1
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.4/DATA_X_CD_07_xcel02
MEMBER CACHED ONLINE DATA_X_CD_07_XCEL02
1
o/192.168.10.4/DATA_X_CD_08_xcel02
MEMBER CACHED ONLINE DATA_X_CD_08_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.4/DATA_X_CD_09_xcel02
MEMBER CACHED ONLINE DATA_X_CD_09_XCEL02
1
o/192.168.10.4/DATA_X_CD_10_xcel02
MEMBER CACHED ONLINE DATA_X_CD_10_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.4/DATA_X_CD_11_xcel02
MEMBER CACHED ONLINE DATA_X_CD_11_XCEL02
2
o/192.168.10.4/DBFS_DG_CD_02_xcel02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DBFS_DG_CD_02_XCEL02
2
o/192.168.10.4/DBFS_DG_CD_03_xcel02
MEMBER CACHED ONLINE DBFS_DG_CD_03_XCEL02
2
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.4/DBFS_DG_CD_04_xcel02
MEMBER CACHED ONLINE DBFS_DG_CD_04_XCEL02
2
o/192.168.10.4/DBFS_DG_CD_05_xcel02
MEMBER CACHED ONLINE DBFS_DG_CD_05_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
2
o/192.168.10.4/DBFS_DG_CD_06_xcel02
MEMBER CACHED ONLINE DBFS_DG_CD_06_XCEL02
2
o/192.168.10.4/DBFS_DG_CD_07_xcel02
MEMBER CACHED ONLINE DBFS_DG_CD_07_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
2
o/192.168.10.4/DBFS_DG_CD_08_xcel02
MEMBER CACHED ONLINE DBFS_DG_CD_08_XCEL02
2
o/192.168.10.4/DBFS_DG_CD_09_xcel02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DBFS_DG_CD_09_XCEL02
2
o/192.168.10.4/DBFS_DG_CD_10_xcel02
MEMBER CACHED ONLINE DBFS_DG_CD_10_XCEL02
2
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.4/DBFS_DG_CD_11_xcel02
MEMBER CACHED ONLINE DBFS_DG_CD_11_XCEL02
3
o/192.168.10.4/RECO_X_CD_00_xcel02
MEMBER CACHED ONLINE RECO_X_CD_00_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.4/RECO_X_CD_02_xcel02
MEMBER CACHED ONLINE RECO_X_CD_02_XCEL02
3
o/192.168.10.4/RECO_X_CD_03_xcel02
MEMBER CACHED ONLINE RECO_X_CD_03_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.4/RECO_X_CD_04_xcel02
MEMBER CACHED ONLINE RECO_X_CD_04_XCEL02
3
o/192.168.10.4/RECO_X_CD_05_xcel02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE RECO_X_CD_05_XCEL02
3
o/192.168.10.4/RECO_X_CD_06_xcel02
MEMBER CACHED ONLINE RECO_X_CD_06_XCEL02
3
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.4/RECO_X_CD_07_xcel02
MEMBER CACHED ONLINE RECO_X_CD_07_XCEL02
3
o/192.168.10.4/RECO_X_CD_08_xcel02
MEMBER CACHED ONLINE RECO_X_CD_08_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.4/RECO_X_CD_09_xcel02
MEMBER CACHED ONLINE RECO_X_CD_09_XCEL02
3
o/192.168.10.4/RECO_X_CD_10_xcel02
MEMBER CACHED ONLINE RECO_X_CD_10_XCEL02
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.4/RECO_X_CD_11_xcel02
MEMBER CACHED ONLINE RECO_X_CD_11_XCEL02
1
o/192.168.10.5/DATA_X_CD_00_xcel03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DATA_X_CD_00_XCEL03
1
o/192.168.10.5/DATA_X_CD_01_xcel03
MEMBER CACHED ONLINE DATA_X_CD_01_XCEL03
1
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.5/DATA_X_CD_02_xcel03
MEMBER CACHED ONLINE DATA_X_CD_02_XCEL03
1
o/192.168.10.5/DATA_X_CD_03_xcel03
MEMBER CACHED ONLINE DATA_X_CD_03_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.5/DATA_X_CD_04_xcel03
MEMBER CACHED ONLINE DATA_X_CD_04_XCEL03
1
o/192.168.10.5/DATA_X_CD_05_xcel03
MEMBER CACHED ONLINE DATA_X_CD_05_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.5/DATA_X_CD_06_xcel03
MEMBER CACHED ONLINE DATA_X_CD_06_XCEL03
1
o/192.168.10.5/DATA_X_CD_07_xcel03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DATA_X_CD_07_XCEL03
1
o/192.168.10.5/DATA_X_CD_08_xcel03
MEMBER CACHED ONLINE DATA_X_CD_08_XCEL03
1
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.5/DATA_X_CD_09_xcel03
MEMBER CACHED ONLINE DATA_X_CD_09_XCEL03
1
o/192.168.10.5/DATA_X_CD_10_xcel03
MEMBER CACHED ONLINE DATA_X_CD_10_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
1
o/192.168.10.5/DATA_X_CD_11_xcel03
MEMBER CACHED ONLINE DATA_X_CD_11_XCEL03
2
o/192.168.10.5/DBFS_DG_CD_02_xcel03
MEMBER CACHED ONLINE DBFS_DG_CD_02_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
2
o/192.168.10.5/DBFS_DG_CD_03_xcel03
MEMBER CACHED ONLINE DBFS_DG_CD_03_XCEL03
2
o/192.168.10.5/DBFS_DG_CD_04_xcel03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DBFS_DG_CD_04_XCEL03
2
o/192.168.10.5/DBFS_DG_CD_05_xcel03
MEMBER CACHED ONLINE DBFS_DG_CD_05_XCEL03
2
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.5/DBFS_DG_CD_06_xcel03
MEMBER CACHED ONLINE DBFS_DG_CD_06_XCEL03
2
o/192.168.10.5/DBFS_DG_CD_07_xcel03
MEMBER CACHED ONLINE DBFS_DG_CD_07_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
2
o/192.168.10.5/DBFS_DG_CD_08_xcel03
MEMBER CACHED ONLINE DBFS_DG_CD_08_XCEL03
2
o/192.168.10.5/DBFS_DG_CD_09_xcel03
MEMBER CACHED ONLINE DBFS_DG_CD_09_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
2
o/192.168.10.5/DBFS_DG_CD_10_xcel03
MEMBER CACHED ONLINE DBFS_DG_CD_10_XCEL03
2
o/192.168.10.5/DBFS_DG_CD_11_xcel03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE DBFS_DG_CD_11_XCEL03
3
o/192.168.10.5/RECO_X_CD_00_xcel03
MEMBER CACHED ONLINE RECO_X_CD_00_XCEL03
3
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.5/RECO_X_CD_01_xcel03
MEMBER CACHED ONLINE RECO_X_CD_01_XCEL03
3
o/192.168.10.5/RECO_X_CD_02_xcel03
MEMBER CACHED ONLINE RECO_X_CD_02_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.5/RECO_X_CD_03_xcel03
MEMBER CACHED ONLINE RECO_X_CD_03_XCEL03
3
o/192.168.10.5/RECO_X_CD_04_xcel03
MEMBER CACHED ONLINE RECO_X_CD_04_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.5/RECO_X_CD_05_xcel03
MEMBER CACHED ONLINE RECO_X_CD_05_XCEL03
3
o/192.168.10.5/RECO_X_CD_06_xcel03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
MEMBER CACHED ONLINE RECO_X_CD_06_XCEL03
3
o/192.168.10.5/RECO_X_CD_07_xcel03
MEMBER CACHED ONLINE RECO_X_CD_07_XCEL03
3
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
o/192.168.10.5/RECO_X_CD_08_xcel03
MEMBER CACHED ONLINE RECO_X_CD_08_XCEL03
3
o/192.168.10.5/RECO_X_CD_09_xcel03
MEMBER CACHED ONLINE RECO_X_CD_09_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
3
o/192.168.10.5/RECO_X_CD_10_xcel03
MEMBER CACHED ONLINE RECO_X_CD_10_XCEL03
3
o/192.168.10.5/RECO_X_CD_11_xcel03
MEMBER CACHED ONLINE RECO_X_CD_11_XCEL03
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
HEADER_STATU MOUNT_S MODE_ST NAME
------------ ------- ------- ------------------------------
100 rows selected.
SQL>
no rows selected
SQL> select group_number,failgroup,mode_status,count(*) from v$asm_disk group by group_number,failgroup,mode_status;
GROUP_NUMBER FAILGROUP MODE_ST COUNT(*)
------------ ------------------------------ ------- ----------
1 XCEL01 ONLINE 12
1 XCEL02 ONLINE 11
1 XCEL03 ONLINE 12
2 XCEL01 ONLINE 10
2 XCEL02 ONLINE 10
2 XCEL03 ONLINE 10
3 XCEL01 ONLINE 12
3 XCEL02 ONLINE 11
3 XCEL03 ONLINE 12
9 rows selected.
SQL>
[root@xcel02 etc]# cellcli -e list physicaldisk | more
20:0 XXXXXX normal
20:1 XXXXXX normal
20:2 XXXXXX normal
20:3 XXXXXX normal
20:4 XXXXXX normal
20:5 XXXXXX normal
20:6 XXXXXX normal
20:7 XXXXXX normal
20:8 XXXXXX normal
20:9 XXXXXX normal
20:10 XXXXXX normal
20:11 XXXXXX normal
Comments