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