Saturday, April 7, 2012

Raise ASM diskgroup compatibility using SQL

SQL> create diskgroup FRA external redundancy disk '/dev/sdc1';

Diskgroup created.

SQL> desc v$asm_diskgroup
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
NAME VARCHAR2(30)
SECTOR_SIZE NUMBER
BLOCK_SIZE NUMBER
ALLOCATION_UNIT_SIZE NUMBER
STATE VARCHAR2(11)
TYPE VARCHAR2(6)
TOTAL_MB NUMBER
FREE_MB NUMBER
HOT_USED_MB NUMBER
COLD_USED_MB NUMBER
REQUIRED_MIRROR_FREE_MB NUMBER
USABLE_FILE_MB NUMBER
OFFLINE_DISKS NUMBER
COMPATIBILITY VARCHAR2(60)
DATABASE_COMPATIBILITY VARCHAR2(60)
VOTING_FILES VARCHAR2(1)

SQL> select * from v$asm_diskgroup;

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
------------------------------------------------------------ -
1 DATA 512 4096
1048576 MOUNTED EXTERN 20473 20414 0
59 0 20414 0
11.2.0.0.0
10.1.0.0.0 N

2 FRA 512 4096
1048576 MOUNTED EXTERN 10236 10186 0
50 0 10186 0
10.1.0.0.0
10.1.0.0.0 N

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

Diskgroup altered.


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

Diskgroup altered.

SQL> select * from v$asm_diskgroup;

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
------------------------------------------------------------ -
1 DATA 512 4096
1048576 MOUNTED EXTERN 20473 20414 0
59 0 20414 0
11.2.0.0.0
11.2.0.0.0 N

2 FRA 512 4096
1048576 MOUNTED EXTERN 10236 10186 0
50 0 10186 0
10.1.0.0.0
10.1.0.0.0 N


SQL> alter diskgroup fra set attribute 'compatible.asm'='11.2';

Diskgroup altered.

SQL> alter diskgroup fra set attribute 'compatible.rdbms'='11.2';

Diskgroup altered.

SQL> select * from v$asm_diskgroup;

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
------------------------------------------------------------ -
1 DATA 512 4096
1048576 MOUNTED EXTERN 20473 20414 0
59 0 20414 0
11.2.0.0.0
11.2.0.0.0 N

2 FRA 512 4096
1048576 MOUNTED EXTERN 10236 10184 0
52 0 10184 0
11.2.0.0.0
11.2.0.0.0 N