Cannot resize ASM Disk using ASM Filter Driver(AFD) online
(Doc ID 2099164.1)
Last updated on SEPTEMBER 10, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
User is using AFD. After resizing LUN, ASM Filter Driver don't see extended size (visible in operating system).
After ASM instance restart, there is no change in size of diskgroup. (in v$asm_disk old value for os_mb). Restarting of HAS services was done (csrtctl stop has/crsctl start has), this did not solve the problem. User was able to resize ASM only after host restart.
[783602.921799] sd 1:0:2:0: [sdc] 37748736 512-byte logical blocks: (19.3 GB/18.0 GiB)
[783602.921922] sdc: detected capacity change from 16106127360 to 19327352832 <<<<<<<<<<<<<<<<<<
[783605.115904] blk_update_request: I/O error, dev fd0, sector 0
[root@oralab123 oracleafd!admin]# fdisk -l /dev/sdc
Disk /dev/sdc: 19.3 GB, 19327352832 bytes, 37748736 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
v$asm_disk -> OS_MB also reflects the old size only:
SQL> alter diskgroup FRA resize disk ASM_FRA;
Diskgroup altered.
SQL> select disk_number, state, os_mb, total_mb, free_mb, name from v$asm_disk;
DISK_NUMBER STATE OS_MB TOTAL_MB FREE_MB NAME
----------- -------- ---------- ---------- ----------------------------------------
0 NORMAL 15360 15360 13508 ASM_FRA <<<<<<<<<<
0 NORMAL 15360 15360 10352 ASM_RACZT
[asm@oralab123 ~]$ asmcmd
ASMCMD> lsdsk
Path
AFD:ASM_FRA
AFD:ASM_RACZT
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 15360 10352 0 10352 0 N ASMDG_RACZT/
MOUNTED EXTERN N 512 4096 1048576 15360 13509 0 13509 0 N FRA/ <<<<<<<<<<<<<
ASMCMD> afd_lsdsk
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
ASM_FRA ENABLED /dev/sdc
ASM_RACZT ENABLED /dev/sdd
ASMCMD> afd_scan
ASMCMD> exit
SQL> alter diskgroup FRA resize disk ASM_FRA 18g;
It gives following errors:
ORA-15032: not all alterations performed
ORA-15057: specified size of 18432 MB is larger than actual size of 15360 MB
KFED don't see correct size:
kfed_output.txt
===============
kfdhdb.secsize: 512 ; 0x0b8: 0x0200
kfdhdb.blksize: 4096 ; 0x0ba: 0x1000
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize: 15360 ; 0x0c4: 0x00003c00 <<<<<<
Kfod did not detected the change:
Output from kfod disks=all:
--------------------------------------------------------------------------------
Disk Size Path User Group
================================================================================
1: 512 Mb /dev/sda root disk
2: 511 Mb /dev/sda1 root disk
3: 153600 Mb /dev/sdb root disk
4: 18432 Mb /dev/sdc root disk
5: 15360 Mb /dev/sdd root disk
6: 15360 Mb AFD:ASM_FRA <<<<<<<<
7: 15360 Mb AFD:ASM_RACZT
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM /oracle/app/asm/product/12.1.0.2/grid
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 |
| Cause |
| Solution |
| References |