1Z0-052 · Question #13
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
The correct answer is B. Failure because a data file is renamed accidentally D. Failure due to loss of connectivity-for example, an unplugged disk cable. The Data Recovery Advisor generates a manual checklist for failures it cannot automatically diagnose or repair, such as logical misconfigurations or physical hardware problems requiring human intervention.
Question
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
Options
- AFailure when no standby database is configured
- BFailure because a data file is renamed accidentally
- CFailure that requires no archive logs to be applied for recovery
- DFailure due to loss of connectivity-for example, an unplugged disk cable
How the community answered
(42 responses)- A7% (3)
- B76% (32)
- C17% (7)
Why each option
The Data Recovery Advisor generates a manual checklist for failures it cannot automatically diagnose or repair, such as logical misconfigurations or physical hardware problems requiring human intervention.
The absence of a standby database does not by itself cause DRA to generate a manual checklist; DRA can still diagnose and repair many local failures using RMAN without a standby.
A renamed data file is a logical failure where Oracle sees the file as missing but cannot determine its new location, so DRA cannot produce an automated RMAN repair script and instead generates a manual checklist for the DBA to resolve.
Failures requiring no archive log application are simpler recovery scenarios that DRA can typically handle automatically with RMAN, so they do not trigger a manual checklist.
A lost cable or connectivity failure is a physical hardware issue entirely outside Oracle's control - DRA cannot fix hardware problems programmatically and therefore generates a manual checklist requiring a human to restore the physical connection.
Concept tested: Data Recovery Advisor manual checklist trigger conditions
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/diagnosing-and-repairing-failures-with-data-recovery-advisor.html
Topics
Community Discussion
No community discussion yet for this question.