Which two statements about Data Recovery Advisor are true?

Question

Options

• AData Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.
• BData Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a
• CData Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.
• DYou can use the ADVISE FAILURE command to display repair options after running LIST FAILURE

• A
  78% (28)
• B
  14% (5)
• C
  8% (3)

Explanation

https://docs.oracle.com/database/121/BRADV/rcmrepai.htm#BRADV89725 Data Recovery Advisor and CDBs In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multitenant container database (CDB). Data Recovery Advisor is not supported for pluggable databases (PDBs). Basic Steps of Diagnosing and Repairing Failures The Data Recovery Advisor workflow begins when you either suspect or discover a failure. You can discover failures in many ways, including error messages, alerts, trace files, and failed data integrity checks. As explained in "Data Integrity Checks", the database can automatically diagnose failures when errors occur. To respond to failures, start an RMAN session and perform all of the following steps in the same session and in the order they are listed: 1.List failures by running the LIST FAILURE command. This task is explained in "Listing Failures". 2.If you suspect that failures exist that have not been automatically diagnosed by the database, then run VALIDATE DATABASE to check for corrupt blocks and missing files. If VALIDATE detects a problem, then RMAN triggers execution of a failure assessment. If a failure is detected, then RMAN logs it into the Automated Diagnostic Repository, where is can be accessed by Data Recovery Advisor. This task is explained in "Checking for Block Corruptions by Validating the Database". 3.Determine repair options by running the ADVISE FAILURE command. This task is explained in "Determining Repair Options". 4.Choose a repair option. You can repair the failures manually or run the REPAIR FAILURE command to fix them automatically. This task is explained in "Repairing Failures". 5.Return to the first step to confirm that all failures were repaired or determine which failures Performing the steps for diagnosing and repairing failures in an order that is different from the one listed in this section may result in errors. If appropriate, you can use CHANGE FAILURE command at any time in the Data Recovery Advisor workflow to change the priority of a failure from LOW to HIGH or HIGH to LOW, or close a failure that has been fixed manually. This task is explained in "Changing Failure Status and

No community discussion yet for this question.