Information to gather when diagnosing ASM space issues
(Doc ID 351117.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 220.127.116.11 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 30-Apr-2010***
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