Storage Administration - Oracle Exadata Recipes: A Problem-Solution Approach - page 236

Disk Total MB Free MB Total MB Free MB # Cell
Group (Raw) (Raw) Redundancy (Usable) (Usable) Disks
---------- ---------- ---------- ------------- ----------- --------- --------
DBFS_DG 894720 892264 NORMAL 447360 446132 30
SRECO_CM01 1352448 957128 NORMAL 676224 478564 36
RECO_CM01 2469888 2423820 NORMAL 1234944 1211910 36
SDATA_CM01 5197824 1371036 NORMAL 2598912 685518 36
DATA_CM01 10469376 2794528 NORMAL 5234688 1397264 36
SQL>
This query shows that the SRECO_CM01 , RECO_CM01 , SDATA_CM01 , and DATA_CM01 are each using 36 grid disks with 12
physical disks per storage cell. This, in combination with our cellcli lists previously, confirms that our existing ASM
disk groups already consume all of the available grid disks. To confirm, you can query the individual disk paths for one
or more of your ASM disk groups. In Listing 9-2, the grid disks that make up the DATA_CM01 disk group are listed.
Listing 9-2. lst09-02-asm-disks.sql
SQL> select a.name,b.path
from v$asm_diskgroup a, v$asm_disk b
where a.group_number=b.group_number
and a.name='DATA_CM01'
order by 2,1
/
Disk Group Disk
---------- ---------------------------------------------
DATA_CM01 o/192.168.10.3/DATA_CD_00_cm01cel01
DATA_CM01 o/192.168.10.3/DATA_CD_01_cm01cel01
... lines omitted for brevity
DATA_CM01 o/192.168.10.5/DATA_CD_10_cm01cel03
DATA_CM01 o/192.168.10.5/DATA_CD_11_cm01cel03
... lines omitted for brevity
36 rows selected.
SQL>
Another way to validate this grid disk to ASM disk group mapping is to query the asmDiskGroupName and
asmDiskName attributes of the griddisk object in cellcli . Following is an abbreviated output:
[root@cm01cel01 ~]# cellcli -e list griddisk attributes name,asmDiskGroupName,asmDiskname
DATA_CD_00_cm01cel01 DATA_CM01 DATA_CD_00_CM01CEL01
DATA_CD_01_cm01cel01 DATA_CM01 DATA_CD_01_CM01CEL01
DATA_CD_02_cm01cel01 DATA_CM01 DATA_CD_02_CM01CEL01
DATA_CD_03_cm01cel01 DATA_CM01 DATA_CD_03_CM01CEL01
DATA_CD_04_cm01cel01 DATA_CM01 DATA_CD_04_CM01CEL01
DATA_CD_05_cm01cel01 DATA_CM01 DATA_CD_05_CM01CEL01
DATA_CD_06_cm01cel01 DATA_CM01 DATA_CD_06_CM01CEL01
DATA_CD_07_cm01cel01 DATA_CM01 DATA_CD_07_CM01CEL01
DATA_CD_08_cm01cel01 DATA_CM01 DATA_CD_08_CM01CEL01
DATA_CD_09_cm01cel01 DATA_CM01 DATA_CD_09_CM01CEL01
DATA_CD_10_cm01cel01 DATA_CM01 DATA_CD_10_CM01CEL01
DATA_CD_11_cm01cel01 DATA_CM01 DATA_CD_11_CM01CEL01