How to collect ASM metadata

Oracle support often ask for ASM metadata for issues .Here is How to collect ASM metadata

SPOOL ASM_FIRST.HTML
SET MARKUP HTML ON
set echo onset 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

SPOOL ASM_SECOND.HTML
SET MARKUP HTML ON
SET ECHO ON

SET PAGESIZE 200

SELECT * FROM  V$ASM_CLIENT;
SELECT * FROM  V$ASM_DISK_STAT ORDER BY GROUP_NUMBER,DISK_NUMBER;
SELECT * FROM  V$ASM_DISKGROUP_STAT ORDER BY GROUP_NUMBER;
SELECT * FROM  V$ASM_FILE ORDER BY GROUP_NUMBER,FILE_NUMBER;
SELECT * FROM  V$ASM_ALIAS ORDER BY GROUP_NUMBER,FILE_NUMBER;
SELECT * FROM  V$ASM_TEMPLATE ORDER BY GROUP_NUMBER,ENTRY_NUMBER;

select * from v$version;

show parameter asm
show parameter cluster
show parameter instance_type
show parameter instance_name
show parameter spfile

SPOOL OFF