Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)
Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)
The ADR (Automatic Diagnostic Repository) command-line utility (ADRCI) can package incident information to send to Oracle Support, making it a useful tool in diagnosing database failure situations. The ADR maintains a separate home directory for each instance of each Oracle product that is installed and uses it, allowing for organized and isolated incident data management. The Data Recovery Advisor leverages the ADR to generate repair advice and repair failures after they have been detected and recorded in the ADR.
A, B, F
ABF are correct. Easier to say why the others are incorrect. C - Flashback is a logical tool. It cannot repair a physical error. D - incorrect. RMAN cannot always repair corrupt blocks, for example - a DB in noarchivelog mode.... E - ADR is an offline, file based, utility. It does not exist within the DB itself.
ABF https://docs.oracle.com/en/database/oracle/oracle-database/18/sutil/oracle-adr-command-interpreter-adrci.html#GUID-DC5744C7-FAC0-436B-99D5-DBD45B66930B https://docs.oracle.com/database/121/ADMQS/GUID-4678D9C4-7949-4050-A6DF-F52F79CEDC9F.htm#ADMQS100
ABF, AB: https://oracle-base.com/articles/11g/automatic-diagnostics-repository-11gr1 F: Failures are normally detected reactively. A database operation involving corrupted data results in an error, which automatically invokes a data integrity check that searches the database for failures related to the error. If failures are diagnosed, then they are recorded in the Automatic Diagnostic Repository (ADR), which is a directory structure stored outside of the database. You can use Data Recovery Advisor to generate repair advice and repair failures only after failures have been detected by the database and stored in ADR. C- incorrect only logical D- incorrect sometimes dont have enought backups to repair E Incorrect - only file repository.
ABF I'm sure
ABF See xRodge
A + B + F
ABF correct