How to identify a failed disk?
An ASM disk failure as noted below is transparent to end users and one can be caught unaware if one is not proactive in database monitoring. The DBA can write a program that constantly checks the database alert logfile or a SQL script that checks for any read/write errors.
If either of the below queries return rows, then it is confirmed there are one or more ASM disks that have failed.
select path,name,mount_status,header_status
from v$asm_disk
where WRITE_ERRS > 0
select path,name,mount_status,header_status
from v$asm_disk
where READ_ERRS > 0;
But despite the read/write errors, the header_status column value may still be shown as "MEMBER".
If either of the below queries return rows, then it is confirmed there are one or more ASM disks that have failed.
select path,name,mount_status,header_status
from v$asm_disk
where WRITE_ERRS > 0
select path,name,mount_status,header_status
from v$asm_disk
where READ_ERRS > 0;
But despite the read/write errors, the header_status column value may still be shown as "MEMBER".
Comments
Post a Comment