The disk groups on the current ASM instance at version 11.2 were configured to support a version 10.2 database instance. The 10.2 instance has the COMPATIBLE parameter defined as 10.2.0. The…

Question

Options

• AChange the disk group attribute after the database instance COMPATIBLE parameter is
• BChange the disk group attribute after the database instance is started with the 11.2 software.
• CChange the disk group attribute after the database instance optimizer_features_enabled
• DChange each disk group after the 11.2 features are required for use on the disk group.
• ENever, upgrading the attribute is not reversible.

• A
  70% (31)
• B
  2% (1)
• C
  7% (3)
• D
  2% (1)
• E
  18% (8)

Explanation

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. Oracle® Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)

No community discussion yet for this question.