Check the compatibility of ASM diskgroup in Oracle

Check the compatibility of ASM diskgroup in Oracle

Oracle 11g introduce the ASM Attributes which help in finding ASM and Database software version to access diskgroups.

Compatibile.ASM = Defines the minimum version of ASM software instance that can access disk group.
Compatibile.RDBMS = Defines the minimum COMPATIBLE parameter setting for database instance that can access diskgroup.

For example, if the Oracle ASM compatibility setting is 12.1, and RDBMS compatibility is set to 11.2, then the Oracle ASM software version must be at least 12.1, and the Oracle Database client software version must be at least 11.2.

1. Value of COMPATIBLE.ASM must always be greater than or equal to the value of COMPATIBLE.RDBMS.
2. Compatibility versions of a diskgroup only be increased,it’s not decreased. If you increased it and want to decrease it then you need to drop and create it again.

Check the compatibility of a ASM diskgroup

SELECT name AS diskgroup, substr(compatibility,1,12) AS asm_compat,
substr(database_compatibility,1,12) AS db_compat FROM V$ASM_DISKGROUP;

--------- ---------- ----------

Check the ASM attribute

column value for a20
column name for a20
SELECT group_number, name, value FROM v$asm_attribute ORDER BY group_number, name;

NUMBER       NAME                 VALUE
------------ -------------------- --------------------
           1 au_size              1048576
           1 compatible.asm
           1 compatible.rdbms     11.1
           1 disk_repair_time     3.6h

Create diskgroup defines tha attribute

CREATE DISKGROUP data01 DISK '/dev/raw/disk*'
ATTRIBUTE 'compatible.rdbms' = '11.1', 'compatible.asm' = '11.1';

Alter command only used to increased value

ALTER DISKGROUP data01 SET ATTRIBUTE 'compatible.asm' = '11.1';
ALTER DISKGROUP data01 SET ATTRIBUTE 'compatible.rdbms' = '11.1';

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.