收集ASM的信息

当ASM出现故障时，需要收集的主要信息如下（来自于MOS，log SR时，通常让你提供alert，trace和这些信息），

SPOOL ASM_FIRST<instance#>.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 GROUP_NUMBER,DISK_NUMBER, NAME, TOTAL_MB, FREE_MB FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;

SELECT COUNT (PXN_KFFXP), DISK_KFFXP, GROUP_KFFXP FROM X$KFFXP GROUP BY DISK_KFFXP, GROUP_KFFXP ORDER BY GROUP_KFFXP,DISK_KFFXP;

SELECT * FROM V$ASM_CLIENT;

select * from V$ASM_ATTRIBUTE;

select * from v$asm_operation;
select * from gv$asm_operation
SELECT * FROM V$ASM_CLIENT;

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