Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-15038: disk 'ORCL:DISK1' mismatch on 'Physical Sector Size' with target disk group [4096] [512]

Tiny_May 11 2023

Dears,

I have 2 nodes 12c cluster running on Oracle Linux 7.8, they are use ASM as data store, where there's 2 Disk groups (DATA and FRA) and they was working fine for years.

The second node can access and mount the disk groups without problems:

SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;

CACHED	MEMBER	ONLINE	NORMAL	1048572	894420	FRA_0000	/dev/oracleasm/disks/DISK2	DISK2
CACHED	MEMBER	ONLINE	NORMAL	1048576	298304	DATA_0000	/dev/oracleasm/disks/DISK1	DISK1

Where the first one fails to start the disk group and gave me:

ORA-15038: disk 'ORCL:DISK1' mismatch on 'Physical Sector Size' with target disk group [4096] [512]

fdisk -l shows disks correctly on both nodes, also oracleasm listdisks !

# fdisk -l /dev/sdb

Disk /dev/sdb: 2395.0 GB, 2394997915648 bytes, 4677730304 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 1048576 bytes
Disk label type: dos
Disk identifier: 0x3a9e4612

Device Boot Start End Blocks Id System
/dev/sdb1 2048 2147485695 1073741824 83 Linux
/dev/sdb2 2147485696 4294967294 1073740799+ 83 Linux
# oracleasm listdisks
DISK1
DISK2
# oracleasm querydisk DISK1
Disk "DISK1" is a valid ASM disk

The strange is on error message it says “target disk group [4096] [512]” ie. 4096 Logical sector size and 512 physical sector size, Is the correct ?

On my database the sectors size are as follow:

SELECT *FROM V$ASM_DISKGROUP;

1	DATA	512	512	4096	4194304	CONNECTED	EXTERN
2	FRA	512	512	4096	4194304	CONNECTED	EXTERN

Where should I start my search and do you have any ideas regarding this issue ?

Thanks and best regards

This post has been answered by Tiny_ on May 14 2023
Jump to Answer

Comments

Post Details

Added on May 11 2023
2 comments
1,048 views