Monday, April 9, 2012
ASM ORA-15032: not all alterations performed, ORA-15283
SQL> alter diskgroup data_test offline disk disk4;
alter diskgroup data_test offline disk disk4
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
SQL> alter diskgroup data_test set attribute 'compatible.asm'='11.2';
Diskgroup altered.
SQL> select * from v$asm_disk where name='DATA_TEST';
no rows selected
SQL> select * from v$asm_diskgroup where name='DATA_TEST';
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB HOT_USED_MB
-------------------- ----------- ------ ---------- ---------- -----------
COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------ ----------------------- -------------- -------------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY V
------------------------------------------------------------ -
3 DATA_TEST 512 4096
1048576 MOUNTED NORMAL 1800 1694 0
106 0 847 0
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB HOT_USED_MB
-------------------- ----------- ------ ---------- ---------- -----------
COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------ ----------------------- -------------- -------------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY V
------------------------------------------------------------ -
11.2.0.0.0
10.1.0.0.0 N
SQL> alter diskgroup data_test offline disk disk4;
alter diskgroup data_test offline disk disk4
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
SQL> alter diskgroup data_test set attribute 'compatible.rdbms'='11.2';
Diskgroup altered.
SQL> select * from v$asm_diskgroup where name='DATA_TEST';
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB HOT_USED_MB
-------------------- ----------- ------ ---------- ---------- -----------
COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------ ----------------------- -------------- -------------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY V
------------------------------------------------------------ -
3 DATA_TEST 512 4096
1048576 MOUNTED NORMAL 1800 1694 0
106 0 847 0
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB HOT_USED_MB
-------------------- ----------- ------ ---------- ---------- -----------
COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------ ----------------------- -------------- -------------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY V
------------------------------------------------------------ -
11.2.0.0.0
11.2.0.0.0 N
SQL> alter diskgroup data_test offline disk disk4;
Diskgroup altered.
SQL> select * from v$asm_operation;
no rows selected
SQL> alter diskgroup data_test online all;
Diskgroup altered.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
3 ONLIN RUN 1 0 0 0 0
0
Labels:
Oracle
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment