V$ASM_ATTRIBUTE and COMPATIBLE attributes

If the diskgroup attribute COMPATIBLE.ASM is set to 11.1 or higher, you can see all attributes by querying v$ASM_ATTRIBUTE and v$ASM_DISKGROUP.  Also you can run lsattr via ASMCMD to some the same information for the diskgroup like below..

+ASM3 - oracle: asmcmd lsattr -lm -G OV

Group_Name  Name                     Value       RO  Sys 
OV          access_control.enabled   FALSE       N   Y   
OV          access_control.umask     066         N   Y   
OV          au_size                  1048576     Y   Y   
OV          cell.smart_scan_capable  FALSE       N   N   
OV          compatible.asm           11.2.0.0.0  N   Y   
OV          compatible.rdbms         10.1.0.0.0  N   Y   
OV          disk_repair_time         3.6h        N   Y   
OV          sector_size              512         Y   Y 


Compatibility Attributes:  COMPATIBLE.RDBMS must be less than or equal to COMPATIBLE.ASM.  To revert to previous value, you must create a new diskgroup with the old campatiblity attributes and then restore the database files that were on the diskgroup.  If setting COMPATIBLE.RDBMS and COMPATIBLE.ASM to the same value like 10.1, it will allow the greatest flexibility regarding the ASM and databas software versions that can be use a diskgroup.  However, ihis setting limits access to the 11g ASM features like fast mirror resync, allocation unit, preferrred read failure groups, etc..

No comments:

Post a Comment