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…

Question

Options

• ASet compatible.asm to 11.2 and compatible.rdbms to 10.2
• BSet compatible.asm to 10.2 and compatible.rdbms to 10.2
• CSet compatible.asm to 11.2 and compatible.rdbms to 11.2
• DSet compatible.asm to 10.2 and compatible.rdbms to 11.2

• A
  76% (34)
• B
  13% (6)
• C
  7% (3)
• D
  4% (2)

Explanation

Disk Group Compatibility Attributes 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)

No community discussion yet for this question.