Data Recovery Advisor and Oracle Real Application Clusters

In the current release, Data Recovery Advisor only supports single-instance databases. Oracle Real Application Clusters (Oracle RAC) databases are not supported.

Data Recovery Advisor and Oracle Data Guard

In a Data Guard environment, Data Recovery Advisor cannot do the following:
■Use files transferred from a physical standby database to repair failures on a primary database
■Diagnose and repair failures on a standby database
However, if the primary database is unavailable, then Data Recovery Advisor may recommend a failover to a standby database. After the failover you can repair the old primary database. If you are using Enterprise Manager Cloud Control in a Data Guard configuration, then you can initiate a failover through the Data Recovery Advisor recommendations page.

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).

Data Recovery Advisor Commands

RMAN>
LIST FAILURE;
LIST FAILURE 101 DETAIL;
LIST FAILURE LOW;
LIST FAILURE CLOSED;
LIST FAILURE EXCLUDE FAILURE 234234;
VALIDATE DATABASE;
VALIDATE CHECK LOGICAL SKIP INACCESSIBLE DATABASE;
ADVISE FAILURE;
ADVISE FAILURE LOW etc;
ADVISE FAILURE 101;
REPAIR FAILURE PREVIEW;
REPAIR FAILURE;
CHANGE FAILURE 101 PRIORITY LOW;
CHANGE FAILURE CLOSED;