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

9-9. Rebuilding Grid Disks
Problem
You wish to rebuild Exadata grid disks on your Exadata Storage Servers.

Solution
In this recipe, you will learn how to rebuild Exadata grid disks, and we will discuss considerations that must be
accounted for in doing so. Specifically, we will demonstrate the following:

• How to capture your ASM disk group to Exadata grid disk mappings

• How to drop your grid disks and ASM disk groups

• How to build new Exadata grid disks

• How to recreate your ASM disk groups

First, log in to a compute node as the Oracle Grid Infrastructure owner and follow these steps:

1. Run the script in Listing 9-16 SQL*Plus while connected as SYSASM :

Listing 9-16. lst09-16-asm-disks.sql

SQL> select a.name,b.path,b.state,a.type,b.failgroup
from v$asm_diskgroup a, v$asm_disk b
where a.group_number=b.group_number
and (a.name='&&diskgroup_name' or '&&diskgroup_name' is null)
order by 2,1
/
Enter value for diskgroup_name: SRECO_CM01
old 4: and (a.name='&&diskgroup_name' or '&&diskgroup_name' is null)
new 4: and (a.name='SRECO_CM01' or 'SRECO_CM01' is null)

Disk Group Disk State Type Failgroup
---------- ------------------------------------- --------- ------- ----------
-------
SRECO_CM01 o/192.168.10.3/SRECO_CD_00_cm01cel01 NORMAL NORMAL CM01CEL01
SRECO_CM01 o/192.168.10.3/SRECO_CD_01_cm01cel01 NORMAL NORMAL CM01CEL01
SRECO_CM01 o/192.168.10.3/SRECO_CD_02_cm01cel01 NORMAL NORMAL CM01CEL01
... output omitted
36 rows selected.

SQL>

The output in Listing 9-16 shows 36 grid disks for an ASM disk group named SRECO_CM01 .
Next, query your grid disks using cellcli :

2.

[oracle@cm01dbm01 ~]$ dcli -g ./cell_group cellcli -e list griddisk where \
> asmDiskGroupName=SRECO_CM01 attributes name,celldisk,size,asmDiskName
cm01cel01: SRECO_CD_00_cm01cel01 CD_00_cm01cel01 36.6875G SRECO_CD_00_CM01CEL01
cm01cel01: SRECO_CD_01_cm01cel01 CD_01_cm01cel01 36.6875G SRECO_CD_01_CM01CEL01
cm01cel01: SRECO_CD_02_cm01cel01 CD_02_cm01cel01 36.6875G SRECO_CD_02_CM01CEL01
[oracle@cm01dbm01 ~]$