A (not B): 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).

Not C: Data Recovery Advisor is not supported for pluggable databases (PDBs).

D: A failure is detected either automatically by the database or through a manual check such as the

VALIDATE command. You can use the LIST FAILURE command to view problem statements for failures

and the effect of these failures on database operations. Each failure is uniquely identified by a failure

number. In the same RMAN session, you can then use the ADVISE FAILURE command to view repair

options, which typically include both automated and manual options.

Explanation:

Reference:

Oracle Database Backup and Recovery User's Guide, 12c, Diagnosing and Repairing Failures with Data

Recovery Advisor