Hi,
we have an ASM diskgroup with SECTOR_SIZE=4096, and we have some new disks what does not support 4K. We would replace the old disks to the new disks within this diskgroup, but oracle 12.1 doc writes:
"The SECTOR_SIZE disk group attribute can be set only during disk group creation."
"Oracle ASM prevents disks of different sector sizes from being added to the same disk group"
Do you have any suggestion, what would be the easiest way for us?
Some details:
DB version: 12.1.0.2.0
OS version: el7uek.x86_64
fdisk for old disks: Sector size (logical/physical): 512 bytes / 4096 bytes
fdisk for new disks: Sector size (logical/physical): 512 bytes / 512 bytes
new disks: WD4002FYYZ
select sector_size from v$asm_diskgroup where ... : 4096
Some alternatives. But I would avoid additional config, if possible.
1. create new diskgroup + drop old
But there are DB_UNKNOWN dir, controlfile, spfile, pwdfile, change tracking file, datafiles ... on the DG, so additional config should be needed.
2. upgrade to 12.2 + alter sector_size
As I read, it is possible to change SECTOR_SIZE from 12.2. Has anybody any experience with it?
ALTER DISKGROUP DG_HDD_01 SET ATTRIBUTE 'compatible.asm' = '12.2';
ALTER DISKGROUP DG_HDD_01 SET ATTRIBUTE 'sector_size'='512', 'logical_sector_size'='512';
3. Buy other (4K) disks
Thanks: lados.