Information to gather when diagnosing ASM space issues
(Doc ID 351117.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 22.214.171.124 [Release 10.1 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
ASM 10g and 11g
This is a guide to provide all the information needed to troubleshoot Automatic Storage Management (ASM) space issues, which include:
- ASM level errors
- RDBMS level errors when storage is on ASM
- Inconsistencies between what is perceived as the available space
- Inconsistencies between V$ASM_DISKGROUP and X$ views
The next section has a reference to the code of the scripts used to collect the information. Those scripts can be downloaded from the following links:
asmdebug.sql -- To be executed on the ASM instance
rdbmsdebug.sql -- To be executed on the RDBMS instance
The next section lists the information to gather. Be sure to gather the information from the correct instance. Also, keep in mind that if normal redundancy is used you need to multiply the file size as shown from the database times two, and for high redundancy times three.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document