I he ASM instance in your environment can support databases from version 10.2.0.4 through
11.2.0.1 You want to use all ASM functionality possible for each database, including OCR and
voting files In the ASM. What is the proper setting for the ASM diskgroup attribute on diskgroups
being used by all the instances?
A.
Set compatible.asm to 11.2 and compatible.rdbms to 10.2
B.
Set compatible.asm to 10.2 and compatible.rdbms to 10.2
C.
Set compatible.asm to 11.2 and compatible.rdbms to 11.2
D.
Set compatible.asm to 10.2 and compatible.rdbms to 11.2
Explanation:
Disk Group Compatibility Attributes
COMPATIBLE.ASM
The value for the disk group COMPATIBLE.ASM attribute determines the minimum software
version for an Oracle ASM instance that can use the disk group. This setting also affects the
format of the data structures for the Oracle ASM metadata on the disk. The format of other file
contents is determined by Oracle ASM Dynamic
Volume Manager (Oracle ADVM) and the database instance.
For Oracle ASM in Oracle Database 11g, 10.1 is the default setting for the COMPATIBLE.ASM
attribute when using the SQL CREATE DISKGROUP statement, the ASMCMD mkdg command,
and Oracle Enterprise Manager Create Disk Group page. When creating a disk group with
ASMCA, the default setting is 11.2.
COMPATIBLE.RDBMS
The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum
COMPATIBLE database initialization parameter setting for any database instance that is allowed
to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the
values for the COMPATIBLE initialization parameter for all of the databases that access the disk
group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1
or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
Oracle Automatic Storage Management Administrator’s Guide
11g Release 2 (11.2)
compatible.asm determines the min software version that can use the disk group
compatible.rdbms determines the min db version that can used the disk group
A is right.
B is wrong. no new features from asm 11.2. can be used
C is wrong. no 10.2 db can use the diskgroup
D is wrong.
So A is correct