Oracle Database 11g: Administration I — Question 20

Which two are true about the Data Recovery Advisor? (Choose two.)

Answer options

• A. It can be used when a database IS MOUNTED
• B. It can be used when a database IS OPEN
• C. It can be used only with databases that are running in ARCHIVELOG mode
• D. It can repair only databases for which RMAN backups exist
• E. It can be used to take RMAN backups
• F. It can be used to validate RMAN backups

Correct answer: D, F

Explanation

The correct answers are D and F. Option D is correct because the Data Recovery Advisor requires existing RMAN backups to perform repairs. Option F is also correct as it allows for the validation of RMAN backups, ensuring their integrity. The other options are incorrect as they either misstate the operational conditions of the Data Recovery Advisor or its capabilities.