My Oracle Support Banner

ASM Extended Diskgroup Shows 0 for USABLE_FILE_MB and REQUIRED_MIRROR_FREE_MB (Doc ID 2495673.1)

Last updated on FEBRUARY 03, 2020

Applies to:

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

Goal

ASM Extended diskgroup shows 0 for USABLE_FILE_MB and REQUIRED_MIRROR_FREE_MB

asmcmd lsdg command and v$asm_diskgroup shows the same.

select NAME,TYPE,FREE_MB,USABLE_FILE_MB,REQUIRED_MIRROR_FREE_MB from v$asm_diskgroup

NAME TYPE FREE_MB USABLE_FILE_MB REQUIRED_MIRROR_FREE_MB

------------------------------ ------------------ ---------- -------------- -----------------------

DATA NORMAL 1953096 771764 409568

FRA NORMAL 2847176 1218804 409568

OCR EXTEND 192996 0 0

 

$asmcmd lsdg

State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED NORMAL N 512 512 4096 4194304 3276544 1953096 409568 771764 0 N DATA/

MOUNTED NORMAL N 512 512 4096 4194304 2866976 2847176 409568 1218804 0 N FRA/

MOUNTED EXTEND N 512 512 4096 4194304 307488 192996 0 0 0 Y OCR/


As per MOS note 1551288.1 space requirements for disk failure or cell failure scenarios

-------------------------------------------------------------------------------------------------------------------------------------------------

|DATA |NORMAL | 2| 16| 204,784| 3,276,544| 1,323,448| 1,953,096| 491,482| 730,807| 40.4%|PASS|

|OCR |EXTEND | 6| 6| 51,184| 307,488| 114,492| 192,996| 27,674| 41,331| 37.2%|PASS|

---------------------------------------------------------------------------------------------------------------------------------------------

 

Solution

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
Goal
Solution


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