1Z0-052 · Question #176
Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
The correct answer is A. Recover from failures in the RAC environment. D. Diagnose and repair failures on a standby database. The Data Recovery Advisor does not support Oracle RAC environments or standby databases, restricting its use to single-instance primary database configurations.
Question
Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
Options
- ARecover from failures in the RAC environment.
- BDiagnose and repair a data file corruption online.
- CDiagnose and repair a data file corruption offline.
- DDiagnose and repair failures on a standby database.
How the community answered
(45 responses)- A82% (37)
- B11% (5)
- C7% (3)
Why each option
The Data Recovery Advisor does not support Oracle RAC environments or standby databases, restricting its use to single-instance primary database configurations.
DRA is not supported in Oracle RAC environments because it cannot coordinate failure diagnosis and repair across multiple database instances sharing the same database files.
Diagnosing and repairing data file corruption while the database is online is a supported DRA capability, making this an activity DRA can perform.
Diagnosing and repairing data file corruption in an offline context is also a supported DRA use case, so this does not represent a limitation.
DRA does not support standby databases - it is designed exclusively for primary, single-instance Oracle databases and cannot diagnose or repair failures on a Data Guard standby.
Concept tested: Data Recovery Advisor supported configurations and limitations
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-data-recovery-advisor.html
Topics
Community Discussion
No community discussion yet for this question.