Tuesday, April 12, 2016
QUERYING PATH OF GRID DISKS
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
order by 2,1;
NAME PATH STATE TYPE FAILGROUP
------------------------------ -------------------------------------------------- -------- ------ ------------------------------
DATA o/192.168.26.20/datagd_CD_disk01_cell1 NORMAL EXTERN DATAGD_CD_DISK01_CELL1
DATA o/192.168.26.20/datagd_CD_disk02_cell1 NORMAL EXTERN DATAGD_CD_DISK02_CELL1
DATA o/192.168.26.20/datagd_CD_disk03_cell1 NORMAL EXTERN DATAGD_CD_DISK03_CELL1
DATA o/192.168.26.20/datagd_CD_disk04_cell1 NORMAL EXTERN DATAGD_CD_DISK04_CELL1
DATA o/192.168.26.20/datagd_CD_disk05_cell1 NORMAL EXTERN DATAGD_CD_DISK05_CELL1
DATA o/192.168.26.20/datagd_CD_disk06_cell1 NORMAL EXTERN DATAGD_CD_DISK06_CELL1
DG1 o/192.168.26.20/datagd_CD_disk07_cell1 NORMAL DATAGD_CD_DISK07_CELL1
DG1 o/192.168.26.20/datagd_CD_disk08_cell1 NORMAL CELL1
DG1 o/192.168.26.20/datagd_CD_disk09_cell1 NORMAL CELL1
DG1 o/192.168.26.20/datagd_CD_disk10_cell1 NORMAL CELL1
DG1 o/192.168.26.20/datagd_CD_disk11_cell1 NORMAL CELL1
DG1 o/192.168.26.20/datagd_CD_disk12_cell1 NORMAL CELL1
No comments:
Post a Comment