适用范围

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]

问题概述

SQL> alter diskgroup OCR_VOT add disk '/dev/oracleasm/disks/ocr4',
'/dev/oracleasm/disks/ocr5',
'/dev/oracleasm/disks/ocr6';
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15410: Disks in disk group OCR_VOT do not have equal size.

问题原因

[grid@snyxdb ~]$ oerr ora 15410
15410, 00000, "Disks in disk group %s do not have equal size."
// *Cause: The disks in the disk group were not of equal size.
// *Action: Ensure that all disks in the disk group are of equal size. If
//          adding new disks to the disk group, their size must be equal to
//          the size of the existing disks in the disk group. If resizing, all
//          disks in the disk group must be resized to the same size.
//
[grid@snyxdb ~]$ 

解决方案

### Option #1: Add new disks to the associated diskgroup with the same size as the existing disk member disks:
SQL> alter diskgroup OCR_VOT add disk '/dev/oracleasm/disks/ocr4',
  2  '/dev/oracleasm/disks/ocr5',
  3  '/dev/oracleasm/disks/ocr6';

Diskgroup altered.

SQL>
### Option #2: Use the original bigger disks , but explicitly restrict/define the smaller/even required disk size at ASM level as follows:
SQL> alter diskgroup OCR_VOT add disk '/dev/oracleasm/disks/ocr4' size 10G,
  2  '/dev/oracleasm/disks/ocr5' size 10G,
  3  '/dev/oracleasm/disks/ocr6' size 10G;

Diskgroup altered.

SQL>

参考文档

12c ASM: Unable To Add New Disks With Dissimilar Size To 12.1.0.2 ASM Diskgroups (Normal or High Redundancy) Due To ORA-15410 (New 12c ASM Enhancement Validation/Constraint) (Doc ID 1938950.1)