Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)
Data Recovery Advisor can be used if a database is closed. This is because the tool is capable of being utilized even when the database is in the NOMOUNT state, effectively meaning it can operate when the database is closed. Additionally, Data Recovery Advisor can proactively check for failures, which helps in detecting and addressing issues before they cause significant operational problems.
I think CE
I think CE also.
CE is correct. C states 'database closed', which is the case when the instance is just 'no mounted'.
A is NOT correct - DB can be even NOT MOUNTED. B is NOT correct - you can close it whenever you want, eventually new check will find the failure again. C has to be CORRECT despite it is not fully clear, anyway Recovery Advisor can be used when database is even NOT mounted, hence it is CLOSED while instance is STARTED. D is NOT correct because of ONLY word. Change Failure can CLOSE or CHANGE PRIORITY. E is CORRECT - Data Recovery Advisor can potentially detect, analyze, and repair data failures BEFORE a database process discovers the corruption and signals an error. Early warnings help limit damage caused by corruption. The health assessment is known as a data integrity check and can be invoked reactively or PROACTIVELY.
in the real exam there is no answer like D. there is an answer like: Data Recovery Advisor can be used if a database is no-mount state.
Why is E true? I think it is False: "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. " (https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/diagnosing-repairing-failures-dra.html) ... And in this situation, the only valid answer is C, that's why ssseee's comment makes a lot of sense
Correct DE, C- Data Recovery Advisor can be used if a database is closed. Not correct, DB should be no mount.
D is wrong: CHANGE FAILURE (to change the status or priority of your failure)
D is incorrect as CHANE FAILURE command is used both for changing priorities and changing status of the failure. "only" word in the statement makes it false. C & E are definitely correct.
change failure can be used to close a failure, does it count as a priority cahnge? or option D can be discarted? option B i think is incorrect because you can close a failure even if you haven't solved it
CE For C - database is closed I take that means mount state
I'm sure of CE
CE read this: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/diagnosing-repairing-failures-dra.html#GUID-636EA9BE-2DFB-4FA0-959E-B1290C774ABD
D is incorrect due to only word: The CHANGE FAILURE command changes the failure priority or closes one or more failures. You can change a failure priority only for HIGH or LOW priorities. Open failures are closed implicitly when a failure is repaired. However, you can also explicitly close a failure.
I go with C - E
Definetly correct answers are: D, E (check it at https://docs.oracle.com/database/121/BRADV/rcmrepai.htm#BRADV89716)
D is wrong...quote from your link: You can use CHANGE FAILURE to change the status of an open failure to CLOSED if you have fixed it manually. However, it makes sense to use CHANGE FAILURE ... CLOSED only if for some reason the failure was not closed automatically. If a failure still exists when you use CHANGE to close it manually, then Data Recover Advisor re-creates it with a different failure ID when the appropriate data integrity check is executed.
DE is the correct answer