Hi,
I have executed following query on daily basis to check space on ASM and it works fine. Today from last 2 hours it give me status that space on ASM is full. Database version is 10.2.0.4, ASM version is 11.2.0 and OS is AIX 6.1
sqlplus "/as sysasm"
set linesize 145
SET PAGESIZE 9999
SET VERIFY off
COLUMN disk_group_name FORMAT a20 HEAD 'DiskGroup Name'
COLUMN disk_file_path FORMAT a17 HEAD 'Path'
COLUMN disk_file_name FORMAT a20 HEAD 'File Name'
COLUMN disk_file_fail_group FORMAT a20 HEAD 'Fail Group'
COLUMN total_mb FORMAT 999,999,999 HEAD 'File Size MB'
COLUMN used_mb FORMAT 999,999,999 HEAD 'Used Size MB'
COLUMN pct_used FORMAT 999.99 HEAD '% Used'
break on report on total_mb
compute sum label "" of total_mb used_mb on disk_group_name
compute sum label "Grand Total: " of total_mb used_mb on report
SELECT
**NVL(a.name, '\[CANDIDATE\]') disk\_group\_name**
, b.path disk_file_path
, b.name disk_file_name
, b.failgroup disk_file_fail_group
, b.total_mb total_mb
, (b.total_mb - b.free_mb) used_mb
, ROUND((1- (b.free_mb / b.total_mb))*100, 2) pct_used
FROM
**v$asm\_diskgroup a RIGHT OUTER JOIN v$asm\_disk b USING (group\_number)**
--where a.name='ORADATA'
ORDER BY
**a.name;**
This query shows me result that ASM space is full.
While when I execute below query, it shows me that still 1309 GB is free on "ORADATA". There is no error in alert log file and DB is running fine.
