1Z0-052 · Question #31
View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure, you executed the following command as the first…
The correct answer is D. The command produces an error because the ADVISE FAILURE command was not executed before. In Oracle RMAN's Data Recovery Advisor workflow, REPAIR FAILURE must be preceded by ADVISE FAILURE in the same session. Skipping ADVISE FAILURE causes RMAN to raise an error rather than silently proceeding.
Question
View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:
RMAN> REPAIR FAILURE; Which statement describes the consequence of this command?
Exhibit
Options
- AThe command performs the recovery and closes the failure
- BThe command only displays the advice and the RMAN script required for recovery
- CThe command executes the RMAN script to repair the failure and remove the entry from the Automatic
- DThe command produces an error because the ADVISE FAILURE command was not executed before
How the community answered
(36 responses)- A3% (1)
- B8% (3)
- C17% (6)
- D72% (26)
Why each option
In Oracle RMAN's Data Recovery Advisor workflow, REPAIR FAILURE must be preceded by ADVISE FAILURE in the same session. Skipping ADVISE FAILURE causes RMAN to raise an error rather than silently proceeding.
REPAIR FAILURE cannot silently perform recovery without a prior ADVISE FAILURE in the session; it does not bypass the required workflow step.
Displaying advice and the suggested RMAN script is the role of ADVISE FAILURE, not REPAIR FAILURE; REPAIR FAILURE is meant to execute, not display.
REPAIR FAILURE does execute the RMAN script and remove the failure entry when used correctly, but only after ADVISE FAILURE has been run first in the same session - which was not done here.
Oracle RMAN enforces a mandatory sequence for the Data Recovery Advisor: LIST FAILURE, then ADVISE FAILURE, then REPAIR FAILURE. The ADVISE FAILURE step generates the internal repair script and marks the session as advised; without it, RMAN has no validated repair plan to execute and will return an error requiring ADVISE FAILURE to be run first.
Concept tested: RMAN Data Recovery Advisor REPAIR FAILURE workflow order
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/repairing-unrecoverable-blocks.html#GUID-F7D4B737-E73E-4DDC-81CC-BE0EEC8B0B07
Topics
Community Discussion
No community discussion yet for this question.