You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same
server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for
a disk group?
A.
The ASM compatibility attribute controls the format of the disk group metadata.
B.
RDBMS compatibility together with the database version determines whether a database
Instance can mount the ASM disk group.
C.
The RDBMS compatibility setting allows only databases set to the same version as the
compatibility value, to mount the ASM disk group.
D.
The ASM compatibility attribute determines some of the ASM features that may be used by the
Oracle disk group.
E.
The ADVM compatibility attribute determines the ACFS features that may be used by the
Oracle 10 g database.
Explanation:
AD: 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.
B: The value for the disk group COMPATIBLE.RDBMS attribute determines the minimumCOMPATIBLE database initialization parameter setting for any database instance that is allowedto
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.
Not E:
/The value for the disk groupCOMPATIBLE.ADVMattribute determines whether the disk group can
contain Oracle ASM volumes. The value must be set to11.2or higher. Before setting this attribute,
theCOMPATIBLE.ASMvalue must be11.2or higher. Also, the Oracle ADVM volume drivers must
be loaded in the supported environment.
/ You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk
group. The volume device associated with the dynamic volume can then be used to host an
Oracle ACFS file system.
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2
or higher for the disk group.
Note:
* The disk group attributes that determine compatibility are COMPATIBLE.ASM,
COMPATIBLE.RDBMS. and COMPATIBLE.ADVM. The COMPATIBLE.ASM and
COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software
version numbers that a system can use for Oracle ASM and the database instance types
respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS
compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the
Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute
determines whether the Oracle ASM Dynamic Volume Manager feature can create an volume in a
disk group.
ABD
ABD is correct,
Reference: https://docs.oracle.com/database/121/OSTMG/asmdiskgrps008.htm#OSTMG10045
ABD
What are compatibility attributes are useful for? They are very handy for upgrades and migrations when ASM diskgroups need to be available for ASM instances and database instances of different versions. Depending on the migration path, you might need to be able to access some diskgroups from different versions of ASM and different database instances. It might also be useful for transportable tablespaces between 10g and 11g databases.
The disk group compatibility attributes specify the disk group compatibility settings for Oracle ASM and database instances.
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.
Therefore, A is correct.
The disk group compatibility settings determine whether your environment can use the latest Oracle ASM features. Hence, D is correct.
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
Hence B is correct.
So the answer is: A, B, D
ABD