Enable new ASM features in Oracle Grid Infrastructure 11gR2

December 2, 2011 by 4 Comments 

Oracle GRID Infrastructure 11gR2 introduces many great ASM features. However most of them are disabled by default even if you run Oracle 11gR2 database on it. Below I share some clarify on how to enable new ASM 11g features for your 11g database.

In Oracle 11g, an ASM instance can support different RDBMS clients running at different compatibility settings. A database instance can use both Oracle database 10g and 11g disk groups. Furthermore Oracle introduced additional three kinds of compatibility attributes applicable to ASM disk groups. These attributes are called ASM compatibility, RDBMS compatibility, and ADVM compatibility, respectively. When creating or altering a disk group, you can specify the COMPATIBLE.ASM, COMPATIBLE.RDBMS and COMPATIBLE.ADVM disk group attributes.

All these compatibility settings depend to each other and in fact define the ASM functionality and enable new 11g ASM features.  Let’s review them all

ASM disk group compatibility attribute

It determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting affects the format of the data structures for the Oracle ASM metadata on the disk and also enables most of the 11g features. The ASM compatibility level of a disk group must be advanced before advancing other disk group compatibility attributes and its value must be greater than or equal to the value of other disk group compatibility attributes.

RDBMS disk group compatibility attribute

It refers to the minimum compatible version of the RDBMS instance that would allow the instance to mount the disk group. It also however enables new 11g ASM features for the corresponding disk group.

ADVM disk group compatibility attribute

It determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. By default, the value of the COMPATIBLE.ADVM attribute is empty until set.

COMPATIBLE parameter of RDBMS instance

It enables you to use a new release of Oracle Database, while at the same time guaranteeing backward compatibility with an earlier release. It must be greater than or equal to the RDBMS compatibility attribute of ASM disk groups it accesses.

COMPATIBLE parameter of ASM instance

It represents by the default the ASM / Grid Infrastructure binaries version

As summary, even if you COMPATIBILITY = 11.2.0.1 in both ASM and RDBMS instances, the new ASM 11g features are not enabled. The problem is that, if not explicitly specified, both the ASM and RDBMS compatibility disk group attributes default to 10.1. So to be able to use new ASM features, such as Fast Mirror Resync, Preferred read failure groups, variable size extents, etc., both the COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to a value of 11.1 or higher.

Note that after you advance these attributes, you cannot modify them back to a lower value.

See below the compatibility parameters dependancies

ASM 11gR2 compatibility

See the list of ASM features from the Oracle documentation:
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#CHDIBHBB

Enjoyed this article? Please share it with others using the social site of your choice:

Comments

4 Responses to “Enable new ASM features in Oracle Grid Infrastructure 11gR2”
  1. Altemir Poli says:

    Hi Mr. Kirill Loifman. How are you? My name is Poli, Altemir and I´m from Brazil. I’m starting my studies in tuning asm oracle 11gR2 and would appreciate some tips and guidelines. as I am not of the specific area of need of help oracle dba with experience. I can count on your guidance?
    Thank you very much!
    Best regards,
    Poli

  2. Kirill Loifman says:

    Hi Poli
    Not sure what are you looking for with “tuning asm oracle 11gR2”.
    Tuning Oracle ASM is not a common practice or best wording. I would call it tuning Oracle I/O probably.
    Anyway if you clarify a bit, I would try to lead you into the right direction.
    — Kirill

  3. Arpit Agarwal says:

    Hi kirill,
    I am Arpit started working as a DBA an year back could you please guide how should I start my career what should I do

  4. Kirill Loifman says:

    Oracle doc and play around!
    — Kirill

Add a Comment

We welcome thoughtful and constructive comments from readers.
If you want your own picture to show with your comment?
Go get a Globally Recognized Avatar!

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email