Monday, June 30, 2014

Set ASM Disk_Repair_time for ASM Diskgroup in Oracle 11.2

SQL> col name for a20
SQL> col compatibility for a15
SQL> col database_compatibility for a25
SQL> select name, compatibility, database_compatibility from v$asm_diskgroup;

NAME                           COMPATIBILITY   DATABASE_COMPATIBILITY
------------------------------ --------------- -------------------------
DATA                           11.2.0.0.0      10.1.0.0.0

SQL> select name,value from v$asm_attribute where group_number=1 and name not like 'template%';

NAME                                               VALUE
-------------------------------------------------- --------------------
disk_repair_time                                   3.6h
au_size                                            1048576
sector_size                                        512
compatible.asm                                     11.2.0.0.0
compatible.rdbms                                   10.1.0.0.0
compatible.advm                                    11.2.0.0.0
cell.smart_scan_capable                            FALSE
access_control.enabled                             FALSE
access_control.umask                               066

9 rows selected.

SQL>  alter diskgroup data set attribute 'disk_repair_time' = '10h';
alter diskgroup data set attribute 'disk_repair_time' = '10h'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute disk_repair_time
ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher

SQL> alter diskgroup data set attribute 'compatible.rdbms' = '11.2.0.0.0';

Diskgroup altered.

SQL> select name, compatibility, database_compatibility from v$asm_diskgroup;

NAME                 COMPATIBILITY   DATABASE_COMPATIBILITY
-------------------- --------------- -------------------------
DATA                 11.2.0.0.0      11.2.0.0.0

SQL> select name,value from v$asm_attribute where group_number=1 and name not like 'template%';

NAME                                               VALUE
-------------------------------------------------- --------------------
disk_repair_time                                   10h
au_size                                            1048576
sector_size                                        512
compatible.asm                                     11.2.0.0.0
compatible.rdbms                                   11.2.0.0.0
compatible.advm                                    11.2.0.0.0
cell.smart_scan_capable                            FALSE
access_control.enabled                             FALSE
access_control.umask                               066

9 rows selected.

Fallback is not possible:

SQL>  alter diskgroup data set attribute 'compatible.rdbms' = '10.1.0.0.0';
alter diskgroup data set attribute 'compatible.rdbms' = '10.1.0.0.0'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.rdbms
ORA-15244: new compatibility setting less than current [11.2.0.0.0]