You executed the following commands in an RMAN session for your database instance that has
failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the
execution of the last LIST FAILURE command. Which statement is true for the above ADVISE
FAILURE command in this scenario?
A.
It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B.
It ignores new failures and considers the failures listed in the last LIST FAILURE command
only.
C.
It produces advice only for new failures and the failures listed in the last LIST FAILURE
command are ignored.
D.
It produces an error with recommendation to run the LIST FAILURE command before the
ADVISE FAILURE command.
A is not correct
B is correct answer b\c please read and share your idea…
http://my.safaribooksonline.com/book/databases/oracle/9780071591027/17-performing-database-recovery/625
oracle note
Note: If a new failure has been recorded in the diagnostic repository since the last LIST FAILURE command in the current RMAN session, then RMAN issues a warning before advising on CRITICAL and HIGH failures
see http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta003.htm#RCMRF166
In this situation you get
“WARNING: new failures were found since last LIST FAILURE command”
“Use the ADVISE FAILURE command to display repair options for the specified failures. This command prints a summary of the failures identified by the Data Recovery Advisor and implicitly closes all open failures that are already fixed.
The recommended workflow is to run the following commands in an RMAN session: LIST FAILURE to display failures, ADVISE FAILURE to display repair options, and REPAIR FAILURE to fix the failures.
ADVISE FAILURE – Displays information for all CRITICAL and HIGH priority failures recorded in the automatic diagnostic repository.
You can only use ADVISE FAILURE with no options when a LIST FAILURE command was previously executed in the current session.
Note: If a new failure has been recorded in the diagnostic repository since the last LIST FAILURE command in the current RMAN session, then RMAN issues a warning before advising on CRITICAL and HIGH failures.”
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta003.htm
Correct
A is correct
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta003.htm#RCMRF89988
ADVISE FAILURE Displays information for all CRITICAL and HIGH priority failures recorded in the automatic diagnostic repository.
You can only use ADVISE FAILURE with no options when a LIST FAILURE command was previously executed in the current session.
Note: If a new failure has been recorded in the diagnostic repository since the last LISTFAILURE command in the current RMAN session, then RMAN issues a warning before advising on CRITICAL and HIGH failures.