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:
* For example, you can validate that all database files and archived logs can be
backed up by running a command as follows:
BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
* You can use the VALIDATE option of the BACKUP command to verify that database files exist
and are in the correct locations, 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.
B and D are correct
I am with KHAN ON THIS
BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
This command checks for physical corruptions only.
To check for logical corruptions in addition to physical corruptions, run the following variation of the preceding command:
BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
The answer should be B,D
B and D are correct
B and D is the best choice, but, E is also correct
Validating Database Files with BACKUP VALIDATE
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
http://docs.oracle.com/database/121/BRADV/rcmvalid.htm#CHDCEHFD
B&D
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
To validate files with the BACKUP VALIDATE command:
Start RMAN and connect to a target database and recovery catalog (if used).
Run the BACKUP VALIDATE command.
For example, you can validate that all database files and archived logs can be backed up by running a command as shown in the following example. This command checks for physical corruptions only.
BACKUP VALIDATE
DATABASE
ARCHIVELOG ALL;
To check for logical corruptions in addition to physical corruptions, run the following variation of the preceding command:
BACKUP VALIDATE
CHECK LOGICAL
DATABASE
ARCHIVELOG ALL;
Correct answer is B,D
for checking logical corruption
BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
B & D
BD