Sunday, March 30, 2014

Checking properties of ASM Diskgroups


SET LINESIZE 150
COL PATH FOR A30
COL NAME FOR A20
COL HEADER_STATUS FOR A20
COL FAILGROUP FOR A20
COL FAILGROUP_TYPE FOR A20
COL VOTING_FILE FOR A20
SELECT NAME,PATH,HEADER_STATUS,FAILGROUP, FAILGROUP_TYPE, VOTING_FILE
FROM V$ASM_DISK;


NAME                 PATH                           HEADER_STATUS        FAILGROUP            FAILGROUP_TYPE       VOTING_FILE
-------------------- ------------------------------ -------------------- -------------------- -------------------- --------------------
                     \\.\ORCLDISKDATANEWSAN1        PROVISIONED                               REGULAR          N
DBDATA_0000          \\.\ORCLDISKDBDATA0            MEMBER               DBDATA_0000          REGULAR              N
DGDUP_0000           \\.\ORCLDISKDATANEWSAN0        MEMBER               DGDUP_0000           REGULAR              Y
DBFLASH_0000         \\.\ORCLDISKDBFLASH0           MEMBER               DBFLASH_0000         REGULAR              N

No comments:

Post a Comment