Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A.
The database files are corrupted when the database is open
B.
The user has dropped an important table that needs to be recovered
C.
The archived redo log files are missing for which the backup is not available
D.
The database is not opening because the required database files are missing
The Data Recovery Advisor automatically diagnoses corruption or loss of data on disk, determines the appropriate repair options, and executes repairs at the user’s request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).
Data Recovery Advisor can handle the following two situations:
one is due to the necessary database files are missing, inconsistent or damaged and can not start the database,
and the other is found at runtime file is corrupted.
Data Recovery Advisor is an Oracle Database tool that automatically diagnoses data failures, determines and presents appropriate repair options, and executes repairs at the user’s request. In this context, a data failure is a corruption or loss of persistent data on disk.
Data Recovery Advisor – ONLY DATABASE LEVEL