Collect DG status
SQL> select dg.inst_id, dg.name dg_name, dg.state dg_state, dg.type,d.name, d.DISK_NUMBER dsk_no, d.MOUNT_STATUS, d.HEADER_STATUS, d.MODE_STATUS,
d.STATE, d. PATH, d.FAILGROUP FROM GV$ASM_DISK d, Gv$asm_diskgroup dg
where dg.inst_id=d.inst_id and dg.group_number(+)=d.group_number and dg.name=:dg_name order by inst_id, dsk_no;
INST_ID DG_NAME DG_STATE TYPE NAME DSK_NO MOUNT_S HEADER_STATU MODE_ST STATE PATH FAILGROUP
---------- ---------- ---------- --------------- ---------- ------- ------- ------------ ------- -------- ------------------------------ ---------------
1 TEST_NEW MOUNTED NORMAL TEST_0000 0 CACHED MEMBER ONLINE NORMAL /dev/asm_test_1G_disk1 TEST_0000
1 TEST_NEW MOUNTED NORMAL TEST_0001 1 CACHED MEMBER ONLINE NORMAL /dev/asm_test_1G_disk2 TEST_0001
2 TEST_NEW MOUNTED NORMAL TEST_0000 0 CACHED MEMBER ONLINE NORMAL /dev/asm_test_1G_disk1 TEST_0000
2 TEST_NEW MOUNTED NORMAL TEST_0001 1 CACHED MEMBER ONLINE NORMAL /dev/asm_test_1G_disk2 TEST_0001
3 TEST_NEW MOUNTED NORMAL TEST_0000 0 CACHED MEMBER ONLINE NORMAL /dev/asm_test_1G_disk1 TEST_0000
3 TEST_NEW MOUNTED NORMAL TEST_0001 1 CACHED MEMBER ONLINE NORMAL /dev/asm_test_1G_disk2 TEST_0001
SQL> select g.name disk_grp, o.group_number, operation , est_minutes from gv$asm_operation o, v$asm_diskgroup g
where g.group_number = o.group_number;
no rows selected
--> No outstanding Rebalance operations
SQL> select f.inst_id, f.group_number, file_number, compound_index, incarnation, f.block_size, bytes/1024/1024/1024 GB, f.type, striped,
creation_date, modification_date from gv$asm_file f , Gv$asm_diskgroup dg where f.group_number = dg.group_number and
dg.inst_id=f.inst_id and dg.name=:dg_name;
INST_ID GROUP_NUMBER FILE_NUMBER COMPOUND_INDEX INCARNATION BLOCK_SIZE GB TYPE STRIPE CREATION_ MODIFICAT
---------- ------------ ----------- -------------- ----------- ---------- ---------- --------------- ------ --------- ---------
1 6 256 100663552 852905863 8192 .004890442 DATAFILE COARSE 14-JUL-14 14-JUL-14
2 6 256 100663552 852905863 8192 .004890442 DATAFILE COARSE 14-JUL-14 14-JUL-14
3 6 256 100663552 852905863 8192 .004890442 DATAFILE COARSE 14-JUL-14 14-JUL-14
--> DG holds only a single Datafile
SQL> select c.INST_ID, dg.name DGName, c.GROUP_NUMBER, INSTANCE_NAME, DB_NAME, STATUS, SOFTWARE_VERSION ,COMPATIBLE_VERSION
from Gv$asm_client c , Gv$asm_diskgroup dg where dg.inst_id=c.inst_id and dg.group_number=c.group_number;
INST_ID DGNAME GROUP_NUMBER INSTANCE_N DB_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION
---------- ------------------------- ----- ------------ ---------- -------- ------------ -------------------- --------------------
1 DATA 1 +ASM1 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
1 DATA 1 grac41 grac4 CONNECTED 11.2.0.4.0 11.2.0.4.0
1 FRA2 2 grac41 grac4 CONNECTED 11.2.0.4.0 11.2.0.4.0
1 OCR 4 +ASM1 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
2 DATA 1 grac42 grac4 CONNECTED 11.2.0.4.0 11.2.0.4.0
2 DATA 1 +ASM2 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
2 FRA2 2 grac42 grac4 CONNECTED 11.2.0.4.0 11.2.0.4.0
2 OCR 4 +ASM2 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
3 DATA 1 grac43 grac4 CONNECTED 11.2.0.4.0 11.2.0.4.0
3 DATA 1 +ASM3 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
3 FRA2 2 grac43 grac4 CONNECTED 11.2.0.4.0 11.2.0.4.0
3 OCR 4 +ASM3 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
12 rows selected.
--> No client access this DG
Check cluster resources
# crsi
NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
..
ora.TEST_NEW.dg ONLINE ONLINE grac41
ora.TEST_NEW.dg ONLINE ONLINE grac42
ora.TEST_NEW.dg ONLINE ONLINE grac43
or
[oracle@grac41 ~]$ srvctl status diskgroup -g TEST_NEW
Disk Group TEST_NEW is running on grac42,grac43,grac41
Pages: Page 1, Page 2, Page 3, Page 4
Hi,
my question is 1 particular disk is lost,what will happens to that diskgroup? does diskgroup goes to mount state? how to replace the d particular disk?