SELECT
  D.GROUP_NUMBER
 ,D.HEADER_STATUS ST_HEADER
 ,( SELECT G.NAME FROM V$ASM_DISKGROUP G WHERE G.GROUP_NUMBER = D.GROUP_NUMBER ) GROUP_NAME
 ,D.DISK_NUMBER
 ,D.NAME DISK_NAME
 ,D.PATH
 ,D.FAILGROUP
 ,D.MODE_STATUS ST_MODE
 ,D.FAILGROUP_TYPE
 ,RPAD(CASE WHEN D.VOTING_FILE = 'Y' THEN 'YES' ELSE 'no' END,6, ' ' ) VOTING
FROM V$ASM_DISK D
WHERE D.GROUP_NUMBER = 2
ORDER BY GROUP_NUMBER, DISK_NUMBER
/


===============> DG_GRID (this configuration does not work during the test scenario)

G# ST_HEADER GROUP_NAME  D# DISK_NAME    PATH                           FGROUP  ST_MODE FAILGRO VOTING 
-- --------- ----------- -- ------------ ------------------------------ ------- ------- ------- ------ 
 2 MEMBER    DG_GRID      0 DG_GRID_A01  ORCL:DG_GRID_A01               SITE1   ONLINE  REGULAR YES    
 2 MEMBER    DG_GRID      1 DG_GRID_A02  ORCL:DG_GRID_A02               SITE1   ONLINE  REGULAR no     
 2 MEMBER    DG_GRID      2 DG_GRID_B01  ORCL:DG_GRID_B01               SITE2   ONLINE  REGULAR YES    
 2 MEMBER    DG_GRID      3 DG_GRID_B02  ORCL:DG_GRID_B02               SITE2   ONLINE  REGULAR no     
 2 MEMBER    DG_GRID      4 DG_GRID_C01  /prg/voting/vote_file          SITE3   ONLINE  QUORUM  YES    
 
 
===============> DG_GRID (this the final configuration)
 
 G# ST_HEADER GROUP_NAME  D# DISK_NAME    PATH                           FGROUP ST_MODE FAILGRO VOTING 
-- --------- ----------- -- ------------ ------------------------------ ------- ------- ------- ------ 
 2 MEMBER    DG_GRID      0 DG_GRID_A01  ORCL:DG_GRID_A01               SITE1   ONLINE  REGULAR YES    
 2 MEMBER    DG_GRID      2 DG_GRID_B01  ORCL:DG_GRID_B01               SITE2   ONLINE  REGULAR YES    
 2 MEMBER    DG_GRID      4 DG_GRID_C01  /prg/voting/vote_file          SITE3   ONLINE  QUORUM  YES

hostgator