Gather ASM Information

SPOOL ASM_FIRST<instance#>.HTML
SET MARKUP HTML ON
SET ECHO ON

SET PAGESIZE 200

SELECT * FROM V$ASM_DISKGROUP;

SELECT * FROM  V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER; 

SELECT * FROM V$ASM_OPERATION;


SELECT * FROM V$VERSION;

SHOW PARAMETER ASM
SHOW PARAMETER CLUSTER
SHOW PARAMETER INSTANCE_TYPE
SHOW PARAMETER INSTANCE_NAME
SHOW PARAMETER SPFILE

SPOOL OFF

EXIT

SPOOL ASM_SECOND<instance#>.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;

SPOOL OFF

EXIT

No comments:

Post a Comment