OracleRAC & ASM
ASM disks and their status
Every disk ASM can see, including CANDIDATE disks not yet in a group. Check MODE and STATE after storage maintenance.
Not yet verified. How scripts are tested
1CLEAR COLUMNS2SET LINESIZE 180 PAGESIZE 200 TRIMOUT ON TAB OFF3COLUMN diskgroup HEADING "DISK GROUP" FORMAT A124COLUMN disk FORMAT A205COLUMN path FORMAT A406COLUMN mount_status HEADING "MOUNT" FORMAT A87COLUMN header_status HEADING "HEADER" FORMAT A128COLUMN mode_status HEADING "MODE" FORMAT A89COLUMN state FORMAT A810COLUMN total_gb HEADING "TOTAL GB" FORMAT 99,99011COLUMN free_gb HEADING "FREE GB" FORMAT 99,99012 13SELECT g.name AS diskgroup, d.name AS disk, d.path,14 d.mount_status, d.header_status, d.mode_status, d.state,15 ROUND(d.total_mb / 1024) AS total_gb,16 ROUND(d.free_mb / 1024) AS free_gb17FROM v$asm_disk d18LEFT JOIN v$asm_diskgroup g ON g.group_number = d.group_number19ORDER BY g.name, d.name;Save it as ora-asm-disks.sql and run it with SQL> @ora-asm-disks.
More Oracle scripts: RAC & ASM
- Stop, start and check a RAC database (srvctl)Clusterware commands to stop the database, start it read-only, check its status, and start a single instance in MOUNT mode. Run one line at a time;…
- ASM disk group spaceSize, free and usable space per disk group. Usable GB already accounts for mirroring, so it's the number to alert on. Works from the ASM or database…
- ASM rebalance progressRebalance operations in flight with power level and estimated minutes left. No rows means nothing is rebalancing.
- Sessions per instance and serviceHow connections are spread across RAC nodes and services. A lopsided spread usually means a service isn't running where you think it is.
- Global cache (interconnect) waits by instanceCluster-class waits per instance since startup. High average times on gc cr or gc current events point at the interconnect or at hot blocks shared…
- Cluster status commands (srvctl and crsctl)The Clusterware commands for checking a RAC database, its services and every cluster resource.