Prev Question
Next Question

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

Prev Question
Next Question

Leave a Reply

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