FAILGROUP PATH OS_MB
------------------------------ ------------------------------ ----------
ORCL:D5GD1 5119
ORCL:D5GD4 5119
ORCL:D5GD2 5119
ORCL:D5GD3 5119
D2GD1 ORCL:D2GD1 2047
D2GD2 ORCL:D2GD2 2047
D2GD3 ORCL:D2GD3 2047
7 rows selected.
SQL> alter diskgroup data add failgroup fg1 disk 'ORCL:D5GD1';
alter diskgroup data add failgroup fg1 disk 'ORCL:D5GD1'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15410: Disks in disk group DATA do not have equal size.
SQL> alter diskgroup data add failgroup fg1 disk 'ORCL:D5GD1','ORCL:D5GD2' failgroup fg2 disk 'ORCL:D5GD3','ORCL:D5GD4'
2 drop disk 'D2GD1','D2GD2','D2GD3';
Diskgroup altered.
CAUSE
1) Starting on 12.1.0.2 ASM release, this ASM constraint/validation is available:
15410, 00000, "Disks in disk group %s do not have equal size."
// *Cause: The disks in the diskgroup were not of equal size.
// *Action: Ensure that all disks in the diskgroup are of equal size. If
// adding new disks to the diskgroup, their size must be equal to
// the size of the existing disks in the diskgroup. If resizing, all
// disks in the diskgroup must be resized to the same size.
// *Cause: The disks in the diskgroup were not of equal size.
// *Action: Ensure that all disks in the diskgroup are of equal size. If
// adding new disks to the diskgroup, their size must be equal to
// the size of the existing disks in the diskgroup. If resizing, all
// disks in the diskgroup must be resized to the same size.
2) Disks with uneven capacity can create allocation problems (e.g. "ORA-15041: diskgroup space exhausted") that prevent full use of all of the available storage in the failgroup /diskgroup.
3) This validation/constraint ensure that all disks in the same diskgroup have the same size, doing so provides more predictable overall performance and space utilization.
4) If the disks are the same size, then ASM spreads the files evenly across all of the disks in the diskgroup. This allocation pattern maintains every disk at the same capacity level and ensures that all of the disks in a diskgroup have the same I/O load. Because ASM load balances workload among all of the disks in a diskgroup, different ASM disks should not share the same physical drive.
3) This validation/constraint ensure that all disks in the same diskgroup have the same size, doing so provides more predictable overall performance and space utilization.
4) If the disks are the same size, then ASM spreads the files evenly across all of the disks in the diskgroup. This allocation pattern maintains every disk at the same capacity level and ensures that all of the disks in a diskgroup have the same I/O load. Because ASM load balances workload among all of the disks in a diskgroup, different ASM disks should not share the same physical drive.
5) This ASM new feature is enabled by default on '12.1.0.2' Grid Infrastructure/ASM release and onwards.
No comments:
Post a Comment