The disk group name can be obtained from the
view V$ASM_DISKGROUP:
SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------ ---------- ----------
1 DATA NORMAL 24568 20798
2 RECOV NORMAL 24568 24090
SQL>
Note that if you had a number of ASM disks and disk groups, you could have joined the two
views on the GROUP_NUMBER column and filtered the query result by GROUP_NUMBER. Also,
you see from V$ASM_DISKGROUP that both of the disk groups are NORMAL REDUNDANCY
groups consisting of two disks each.
Your first step is to create the disk group:
SQL> create diskgroup data2 high redundancy
2 failgroup fg1 disk '/dev/raw/raw5' name d2a
3 failgroup fg2 disk '/dev/raw/raw6' name d2b
4 failgroup fg3 disk '/dev/raw/raw7' name d2c
5 failgroup fg4 disk '/dev/raw/raw8' name d2d;
Diskgroup created.
SQL>
110 Oracle Database 11g DBA Handbook
Looking at the dynamic performance views, you see the new disk group available in V$ASM_
DISKGROUP and the failure groups in V$ASM_DISK:
SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------ ---------- ----------
1 DATA NORMAL 24568 20798
2 RECOV NORMAL 24568 24090
3 DATA2 HIGH 16376 16221
SQL> select group_number, disk_number, name,
2 failgroup, create_date, path from v$asm_disk;
GROUP_NUMBER DISK_NUMBER NAME FAILGROUP CREATE_DA PATH
------------ ----------- ---------- ---------- --------- ---------------
3 3 D2D FG4 13-JUL-07 /dev/raw/raw8
3 2 D2C FG3 13-JUL-07 /dev/raw/raw7
3 1 D2B FG2 13-JUL-07 /dev/raw/raw6
3 0 D2A FG1 13-JUL-07 /dev/raw/raw5
2 1 RECOV_0001 RECOV_0001 08-JUL-07 /dev/raw/raw4
2 0 RECOV_0000 RECOV_0000 08-JUL-07 /dev/raw/raw3
1 1 DATA_0001 DATA_0001 08-JUL-07 /dev/raw/raw2
1 0 DATA_0000 DATA_0000 08-JUL-07 /dev/raw/raw1
8 rows selected.
Pages:
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214