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]
No comments:
Post a Comment