Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

Question

Options

• AIt is used to change failure priority only for HIGH or LOW priorities.
• BIt is used to execute the advised repair script.
• CIt is used to change failure priority only for the CRITICAL priority.
• DIt is used to explicitly close the open failures.
• EIt is used to inform the database about the repair after the repair script executes.

• A
  71% (29)
• B
  17% (7)
• C
  7% (3)
• E
  5% (2)

Explanation

CHANGE FAILURE in RMAN (Oracle's Data Recovery Advisor) serves two distinct purposes: adjusting failure priorities and closing failures - making A and D correct.

Why A is correct: CHANGE FAILURE lets you reprioritize failures, but only between HIGH and LOW. CRITICAL failures are locked at that priority by the system and cannot be manually downgraded, making option C wrong by definition.

Why D is correct: CHANGE FAILURE ... CLOSED explicitly marks open failures as closed, which is useful when you've resolved an issue manually outside of RMAN and need to tell the advisor the failure no longer exists.

Why the distractors fail:

• B is wrong - executing the advised repair script is the job of REPAIR FAILURE, not CHANGE FAILURE.
• C is wrong - CRITICAL priority is read-only; you cannot change it.
• E is wrong - after REPAIR FAILURE runs successfully, RMAN automatically closes the failure; no separate "inform" step is needed. Manual repairs use CHANGE FAILURE CLOSED (which is D, not a separate concept).

Memory tip: Think of CHANGE FAILURE as doing exactly two things spelled with C: Change priority (only HIGH/LOW, never CRITICAL) and Close failures. Everything else - repairing and auto-closing - belongs to REPAIR FAILURE.

No community discussion yet for this question.