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.
Correct Answer: ABD
(解析:该题目的意思是一台服务器上所有版本的所有数据库都用 ASM,那么这里面就要求按照GI,只要 ASM 实例能够兼容数据库软件,那么不同版本的数据库都可以使用该 ASM。
答案 AD:disk group compatible.asm 属性的值确定可以使用磁盘组的 Oracle ASM 实例的最低软件版本。此设置还影响磁盘上 Oracle ASM 元数据的数据结构格式。
支持Oracle数据库12c、Oracle数据库11g和Oracle数据库日志。所有版本的所有数据库使用自动存储管理(ASM)。
关于为磁盘组设置的ASM磁盘组兼容性属性,哪三个陈述是正确的?
A.ASM兼容性属性控制磁盘组元数据的格式。
B.RDBMS的兼容性和数据库版本一起决定了数据库实例是否可以挂载ASM磁盘组。
C. RDBMS兼容性设置只允许设置为与兼容性值相同版本的数据库挂载ASM磁盘组。
D.ASM兼容性属性决定了Oracle磁盘组可能使用的一些ASM特性。
E.ADVM compatibility属性决定了Oracle 10g数据库可能使用的ACFS特性。
正确答案:ABD
A, D: 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 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. Incorrect Answers:
E: /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. / 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 a volume in a disk group.