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.

Note:
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;

DISKGROUP ASM_COMPAT DB_COMPAT
--------- ---------- ----------
DATA      18.0.0.0.0 18.0.0.0.0
DATA1     18.0.0.0.0 18.0.0.0.0

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       11.1.0.0.0
           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:

WordPress.com Logo

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

Google photo

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

Twitter picture

You are commenting using your Twitter 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.