You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true?
A.
Corrupted blocks, if any, are repaired.
B.
Checks are performed for physical corruptions.
C.
Checks are performed for logical corruptions.
D.
Checks are performed to confirm whether all database files exist in correct locations
E.
Backup sets containing both data files and archive logs are created.
Explanation:
B (not C): You can validate that all database files and archived redo logs can be backed up by running a
command as follows:
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
This form of the command would check for physical corruption. To check for logical corruption, RMAN>
BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
D: You can use the VALIDATE keyword of the BACKUP command to do the following:
Check datafiles for physical and logical corruption
Confirm that all database files exist and are in the correct locations.
Note:
You can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the
correct locations (D), and have no physical or logical corruptions that would prevent RMAN from creating
backups of them. When performing a BACKUP…VALIDATE, RMAN reads the files to be backed up in their
entirety, as it would during a real backup. It does not, however, actually produce any backup sets or image
copies (Not A, not E).
Question is invalid. Correct answers could be B, C and D.
https://docs.oracle.com/database/121/BRADV/rcmvalid.htm#BRADV89562
You can use the BACKUP VALIDATE command to do the following:
– Check data files for PHYSICAL and LOGICAL block corruption
– Confirm that all database files exist and are in the correct locations
It is equivalent to RMAN validate database backup which checks the database for intrablock corruptions (which could be physical or logical
https://docs.oracle.com/database/121/BRADV/rcmvalid.htm#BRADV89563
Oracle Database supports different techniques for detecting, repairing, and monitoring block corruption. The technique depends on whether the corruption is interblock corruption or intrablock corruption. In intrablock corruption, the corruption occurs within the block itself. This corruption can be either physical or logical. In an interblock corruption, the corruption occurs between blocks and can only be logical.
All database utilities detect intrablock corruption, including RMAN (for example, the BACKUP command) and the DBVERIFY utility. If a database process can encounter the ORA-1578 error, then it can detect the corruption and monitor it.
Only DBVERIFY and the ANALYZE statement detect interblock corruption.
The question and answer are correct. You must use CHECK LOGICAL…