Script to Check ASM Diskgroup Compatibility

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
COMPATIBLE.ASM (v$asm_diskgroup. COMPATIBILITY) – The minimum version of the ASM software that can access the disk group. In 11g, the default setting is 10.1. COMPATIBLE.RDBMS(v$asm_diskgroup. 

DATABASE_COMPATIBILITY) – The minimum COMPATIBLE database initialization parameter setting for any database instance that uses the disk group. In 11g, the default setting is 10.1. 

SQL Query

 
Set pages 1000 lines 120 
Col DATABASE_COMPATIBILITY for a30
Col COMPATIBILITY for a30
select GROUP_NUMBER,NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;


Sample Output

 
SQL> Set pages 1000 lines 120
Col DATABASE_COMPATIBILITY for a30
Col COMPATIBILITY for a30
select GROUP_NUMBER,NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;

GROUP_NUMBER NAME            COMPATIBILITY                  DATABASE_COMPATIBILITY
------------ --------------- ------------------------------ ------------------------------
           1 DATA            12.1.0.2.0                     12.1.0.2.0
           2 INDEX           12.1.0.2.0                     12.1.0.2.0
           3 RECO            12.1.0.2.0                     12.1.0.2.0

_____________________________________________________________________________________________________________________

0 comments:

Post a comment

 

acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer