ASM Administration

ASM Administration

select path, disk_number, mount_status, header_status, mode_status, state, name,label from v$asm_disk

Select mount_status, header_status, mode_status, state, total_mb, free_mb, name, path, create_date from v$asm_disk

set wrap off
set lines 120
set pages 999
col “Group Name”   form a25
col “Disk Name”    form a30
col “State”  form a15
col “Type”   form a7
col “Free GB”   form 9,999

 select group_number  "Group",  name "Group Name",state  "State" ,type  "Type",total_mb/1024 "Total GB" , free_mb/1024  "Free GB" from   v$asm_diskgroup
 /

col “Instance” form a8
 select c.group_number  "Group"
 ,      g.name          "Group Name"
 ,      c.instance_name "Instance"
 from   v$asm_client c
 ,      v$asm_diskgroup g
 where  g.group_number=c.group_number

/


select *
from   v$asm_operation
/
select header_status , mode_status, path from V$asm_disk where header_status in ('FORMER','CANDIDATE');

/

ol “Instance” form a8
 select c.group_number  "Group"
 ,      g.name          "Group Name"
 ,      c.instance_name "Instance"
 from   v$asm_client c
 ,      v$asm_diskgroup g
 where  g.group_number=c.group_number

/


select *
from   v$asm_operation
/
select header_status , mode_status, path from V$asm_disk where header_status in ('FORMER','CANDIDATE');

/

col "Group"          form 999
 col "Disk"           form 999
 col "Header"         form a9
 col "Mode"           form a8
 col "Redundancy"     form a10
 col "Failure Group"  form a10
 col "Path"           form a19
 
select group_number  "Group"
 ,      disk_number   "Disk"
 ,      header_status "Header"
 ,      mode_status   "Mode"
 ,      state         "State"
 ,      redundancy    "Redundancy"
 ,      total_mb      "Total MB"
 ,      free_mb       "Free MB"
 ,      name          "Disk Name"
 ,      failgroup     "Failure Group"
 ,      path          "Path"
 from   v$asm_disk  order by group_number,disk_number

spool asm1.html 
SET MARKUP HTML ON 
set echo on 
set pagesize 200 
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS'; 
select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual; 
select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%'; 
select * from v$asm_diskgroup; 
SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER; 
SELECT * FROM V$ASM_CLIENT; 
select * from V$ASM_ATTRIBUTE; 
select * from v$asm_operation; 
select * from gv$asm_operation; 
select * from v$version; 
show parameter asm 
show parameter cluster 
show parameter instance_type 
show parameter instance_name 
show parameter spfile 
show sga 
spool off 
exit 


sqlplus "/ as sysasm" 

spool /tmp/asm.out 
set pages 1000 
set linesize 160 
col path format a45 
col name format a35 
select group_number,disk_number,name,path,state,header_status,mode_status,mount_status from v$asm_disk order by 1,2,3; 
select failgroup,header_status,count(*) from v$asm_disk group by failgroup,header_status order by 1,2; 
spool off