Which two statements are true?

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?

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



Leave a Reply 4

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


Piotr

Piotr

B, D

To verify logical errors following should be used:
BACKUP VALIDATE
CHECK LOGICAL
DATABASE
ARCHIVELOG ALL;

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

Chris

Chris

I’d rather say BCD.

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup005.htm

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.

Chris

Chris

Sorry, you’re right.