<<Back to Oracle ASM Main Page
SQL> CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'AFD:TEST06'
FAILGROUP FG2 DISK
'AFD:TEST07'
ATTRIBUTE 'compatible.asm' = '12.2', 'compatible.rdbms' = '12.2',
'sector_size'='4096', 'logical_sector_size'='4096';
CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15038: disk 'AFD:TEST07' mismatch on 'Physical Sector Size' with target disk group [512] [4096]
ORA-15038: disk 'AFD:TEST06' mismatch on 'Physical Sector Size' with targetdisk group [512] [4096]
Let us check the Physical sector size of the disk
$ asmcmd afd_lsdsk
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
TEST06 ENABLED /dev/xvdj6
TEST07 ENABLED /dev/xvdj7
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
TEST06 ENABLED /dev/xvdj6
TEST07 ENABLED /dev/xvdj7
# fdisk -l /dev/xvdj
Disk /dev/xvdj: 32.2 GB, 32212254720 bytes, 62914560 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
Disk label type: dos
Disk identifier: 0xb87bb4b2
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0xb87bb4b2
Device Boot Start End Blocks Id System
/dev/xvdj1 2048 62914559 31456256 5 Extended
/dev/xvdj5 4096 10489855 5242880 83 Linux
/dev/xvdj6 10491904 20977663 5242880 83 Linux
/dev/xvdj7 20979712 31465471 5242880 83 Linux
/dev/xvdj8 31467520 41953279 5242880 83 Linux
/dev/xvdj9 41955328 52441087 5242880 83 Linux
/dev/xvdj1 2048 62914559 31456256 5 Extended
/dev/xvdj5 4096 10489855 5242880 83 Linux
/dev/xvdj6 10491904 20977663 5242880 83 Linux
/dev/xvdj7 20979712 31465471 5242880 83 Linux
/dev/xvdj8 31467520 41953279 5242880 83 Linux
/dev/xvdj9 41955328 52441087 5242880 83 Linux
Solution: You can not create a diskgroup with Sector Size 4096 or 4K if the disk do not support the sector size and therefore specify the Sector Size 521 ( or that is supported by your system)
SQL> CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'AFD:TEST06'
FAILGROUP FG2 DISK
'AFD:TEST07'
ATTRIBUTE 'compatible.asm' = '12.2', 'compatible.rdbms' = '12.2',
'sector_size'='512', 'logical_sector_size'='4096';
CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15238: 521 is not a valid value for attribute sector_size
Solution: The specified value for sector size is invalid accepted values are 512 , 4096 or 4kSQL>CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'AFD:TEST06'
FAILGROUP FG2 DISK
'AFD:TEST07'
ATTRIBUTE 'compatible.asm' = '12.2', 'compatible.rdbms' = '12.2',
'sector_size'='512', 'logical_sector_size'='4096';
CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15375: Physical sector size (512) cannot be smaller than the logical sector size (4096).
Solution: The physical sector size (SECTOR_SIZE) cannot be smaller than the logical sectorsize (LOGICAL_SECTOR_SIZE) in an Oracle ASM disk group.
SQL>CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'AFD:TEST06'
FAILGROUP FG2 DISK
'AFD:TEST07'
ATTRIBUTE 'compatible.asm' = '12.2', 'compatible.rdbms' = '12.2',
'sector_size'='512', 'logical_sector_size'='512';
Diskgroup created.
Comments
Post a Comment