You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS
compatibility of all ASM disk groups used by that database instances.
B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk
group.
C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the
disk.
D. ASM compatibility controls which features for the ASM will be enabled.
Answer: ABD
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 ASMCMDmkdg
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.
For Oracle ASM in Oracle Database 11g, 10.1
is the default setting for the COMPATIBLE
.RDBMS
attribute when using the SQL CREATE
DISKGROUP
statement, the ASMCMDmkdg
command, ASMCA Create Disk Group page, and Oracle Enterprise Manager Create Disk Group page.
COMPATIBLE.ADVM
The value for the disk group COMPATIBLE.ADVM
attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2
or higher. Before setting this attribute, the COMPATIBLE.ASM
value must be 11.2
or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.
By default, the value of the COMPATIBLE.ADVM
attribute is empty until set.
http://blog.csdn.net/rlhua/article/details/12972983
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG02700