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