Which two statements about Data Recovery Advisor are true?

Which two statements about Data Recovery Advisor are true?

Which two statements about Data Recovery Advisor are true?

A.
Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.

B.
Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a
CDB.

C.
Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.

D.
You can use the ADVISE FAILURE command to display repair options after running LIST
FAILURE in an RMAN session.

Explanation:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta003.htm

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

reed

reed

A,D only:

“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).”
https://docs.oracle.com/database/121/BRADV/rcmrepai.htm#BRADV89725

Reply

db

db

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

Reply

Wellington Marinho

Wellington Marinho

Answer: A,D
Explanation: 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.
Reference: Oracle Database Backup and Recovery User’s Guide, 12c, Diagnosing and Repairing
Failures with Data Recovery Advisor

Reply