Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

Question

Options

• AThe database files are corrupted when the database is open
• BThe user has dropped an important table that needs to be recovered
• CThe archived redo log files are missing for which the backup is not available
• DThe database is not opening because the required database files are missing

• A
  78% (18)
• B
  13% (3)
• C
  9% (2)

Explanation

Oracle Data Recovery Advisor (DRA) is designed to automatically diagnose and repair physical database failures. It can be used in two modes: when the database is open (for accessible failures like block corruption) and when the database is mounted or unmounted (for failures preventing startup). Option A is valid because DRA can detect and repair data file corruption even while the database is open, using techniques like block media recovery. Option D is valid because DRA can diagnose missing datafiles that prevent the database from opening and recommend recovery steps using RMAN. Option B is incorrect because DRA handles physical failures only - a dropped table is a logical failure, which requires Flashback Table or other logical recovery methods, not DRA. Option C is incorrect because if archived redo logs are missing and no backup exists for them, DRA cannot provide a viable recovery path - recovery is simply not possible in that case without the logs.

No community discussion yet for this question.