Minimum COMPATIBLE Attributes for ACFS Replication and Encryption

1Z0-078 By islever Editorial Last updated

ASM files, directories, aliases and templates

Short answer

D Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1 to enable ACFS features while maintaining 11g database compatibility.

Question

A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM. The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups. You must support these capabilities in all diskgroups: 1. ACFS Replication 2. ACFS Encryption To what minimum values must the compatible attributes be set?
  1. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.
  2. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
  3. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
  4. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1. Correct Answer
  5. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.

Key Takeaways

The exam tests your knowledge of feature-specific compatibility levels, specifically the trap that ACFS replication/encryption requires COMPATIBLE.ADVM >= 12.1 even if the database version is older.

To enable ACFS Replication and Encryption on Oracle RAC diskgroups, specific minimum values for COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM attributes must be configured. This question establishes that while ASM compatibility can remain at 11.2, the ADVM attribute requires a higher version to support these advanced features.

Common mistake: Many candidates incorrectly choose option B (setting all to 12.1) because they assume uniform upgrades are needed. However, setting COMPATIBLE.RDBMS to 12.1 prevents Oracle 11g databases from accessing the diskgroup, violating the requirement to support existing 11g RAC databases.

Expert Analysis

Why the Answer Is Correct

Option D is correct because it balances backward compatibility with new feature requirements. To use ACFS Replication and Encryption, the COMPATIBLE.ADVM attribute must be set to at least 12.1. The COMPATIBLE.ASM attribute can remain at 11.2 as long as the GI is 19c, but crucially, COMPATIBLE.RDBMS must stay at 11.2 to allow Oracle 11g databases to mount the diskgroups. Setting COMPATIBLE.ASM to 12.1 is optional but often done; however, the critical differentiator here is that COMPATIBLE.RDBMS cannot be raised to 12.1.

Why the Other Options Are Wrong

Option B sets COMPATIBLE.RDBMS to 12.1, which would prevent Oracle 11g databases from mounting the diskgroups, directly contradicting the scenario's requirement to support 11g RAC. Option A and C leave COMPATIBLE.ADVM at 11.2, which does not support ACFS Replication or Encryption. Option E leaves all at 11.2, failing to enable the required features. Option D is the only one that raises ADVM to 12.1 while keeping RDBMS at 11.2.

Community Comment Notes

The community consensus strongly supports Option D. As user krwi1 noted, setting COMPATIBLE.RDBMS to 12.1 will break 11.2 database access. Another commenter pointed out that while some features existed in earlier patches, the standard exam logic for 'Replication' and 'Encryption' generally points to the 12.1 threshold for ADVM compatibility in modern contexts, making the mixed attribute set in D the technically valid choice for this specific constraint set.

Exam Strategy

When asked about compatibility levels, always check if any legacy database versions need to access the storage. If an older RDBMS version (e.g., 11g) must connect, COMPATIBLE.RDBMS cannot exceed that version's major release number, regardless of other feature requirements.

Frequently Asked Questions

Why can't COMPATIBLE.RDBMS be set to 12.1?

Setting COMPATIBLE.RDBMS to 12.1 prevents Oracle 11g databases from mounting the diskgroup. Since the scenario requires supporting 11g RAC, this attribute must remain at 11.2.

Does COMPATIBLE.ASM need to be 12.1 for ACFS encryption?

Not strictly for the feature itself, but COMPATIBLE.ADVM must be 12.1. In Option D, ASM is raised to 12.1 likely for best practice or specific GI interactions, but the critical factor is ADVM >= 12.1 and RDBMS <= 11.2.

More 1Z0-078 FAQ →

Community Votes

D
100%

100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 3 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 3

  1. krwi1 👍 3 Answered D
    B - wrong - it will not allow the database 11.2 to run on the diskgroup with 12.1 compatible.rdbms.
  2. piontk 👍 2 Answered D
    Replication and Encryption are enable on 11.2.0.3 COMPATIBLE.ASM and COMPATIBLE.ADVM. Value 11.2 for those parameteres does not support those features.
  3. Tunglinfo9 👍 1 Answered D
    Replication status of a disk group requires the COMPATIBLE.ASM to be >=12.1 As a result, the COMPATIBLE.ADVM requires to be equal to COMPATIBLE.ASM.

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Which Three Resources Use Global Concurrency Control in 19c RAC?

S-grade

Which Task Must Precede OPatch Patching of Grid Infrastructure 19c?

S-grade

What Does opatch apply Do in a Four-Node RAC Cluster?

S-grade

ACFS Encryption True Statements

S-grade

← Back to 1Z0-078 Study Guide