My Oracle Support Banner

ASMFD disks were expelled from diskgroup irrespective of disk_repair_time (Doc ID 2255076.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.0.1 version

DISK_REPAIR_TIME specified as 2400Hrs even though, after disconnecting SAN ASM offline the disk immediately as below

Two SAN arrays on different locations(A is for asm-bst*, B is for asm-ns*). Try to unplug the storage on location A.

[grid@bst-pddb01 soft]$ asmcmd afd_lsdsk
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
MGMT1 ENABLED /dev/asm-bstds8870a_250G_data1
MGMT2 ENABLED /dev/asm-nsds8870b_250G_data1

 When attempting to disconnect a storage of a failure group, ASM offline the disk immediately without waiting for disk_repair_time attribute

SQL> select GROUP_NUMBER,STATE,TOTAL_MB,FREE_MB,NAME,FAILGROUP,path,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS from v$asm_disk;

GROUP_NUMBER STATE TOTAL_MB FREE_MB NAME FAILGROUP PATH MOUNT_STATUS HEADER_STATUS MODE_STATUS
------------ ---------- ---------- ---------- --------------- -------------------- -------------------------------------------------- -------------- ------------------------ --------------
0 NORMAL 0 0 /dev/asm-bstds8870a_250G_data7 CLOSED UNKNOWN ONLINE
0 NORMAL 0 0 /dev/asm-bstds8870a_10G_data1 CLOSED UNKNOWN ONLINE
4 NORMAL 10240 10048 OCRDG_0003 FGBST2 MISSING UNKNOWN OFFLINE
4 NORMAL 10240 9988 OCRDG_0002 FGBST2 MISSING UNKNOWN OFFLINE
3 FORCING 256000 215284 _DROPPED_0000_M MGMT1 MISSING UNKNOWN OFFLINE<====

SQL> select * from v$asm_attribute where name like '%repair_time%';

NAME VALUE GROUP_NUMBER ATTRIBUTE_INDEX ATTRIBUTE_INCARNATION READ_ONLY SYSTEM_CREATED CON_ID
------------------------------ -------------------- ------------ --------------- --------------------- -------------- -------------- ----------
disk_repair_time 2400h 1 1 1 N Y 0
failgroup_repair_time 24.0h 1 3 1 N Y 0
disk_repair_time 2400h 2 1 1 N Y 0
failgroup_repair_time 24.0h 2 3 1 N Y 0
disk_repair_time 3.6h 3 1 1 N Y 0
failgroup_repair_time 24.0h 3 3 1 N Y 0
disk_repair_time 2400h 4 1 1 N Y 0
failgroup_repair_time 24.0h 4 3 1 N Y 0

8 rows selected.

 
Due to this issue, disk AFD:MGMT1 offlined unexpectedly.

Changes

 Unplug a storage connect of 1 failure group.

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.