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 corruptionConfirm that all database files exist and are in the correct locations.
Note:
You can use theVALIDATEoption of theBACKUPcommand 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 aBACKUP…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).
B and C
C is NOT CORRECT see the documentation:
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;
“validation
In an RMAN context, a test that checks database files for block corruption or checks a backup set to determine whether it can be restored. RMAN can check for both physical and logical block corruption.”
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/glossary.htm#i433696
“In a physical corruption, the database does not recognize the block at all. In a logical corruption, the contents of the block are logically inconsistent. By default, the VALIDATE command checks for physical corruption only. You can specify CHECK LOGICAL to check for logical corruption as well. RMAN populates the V$DATABASE_BLOCK_CORRUPTION view with its findings.”
BD
BD – OK
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;
https://docs.oracle.com/database/121/BRADV/rcmvalid.htm#BRADV89562
BD
Ref: Oracle documentation
You can use the BACKUP VALIDATE command to do the following:
Check datafiles for physical and logical block corruption
Confirm that all database files exist and are in the correct locations
When you run BACKUP VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. RMAN does not, however, actually produce any backup sets or image copies.
You cannot use the BACKUPSET, MAXCORRUPT, or PROXY parameters with BACKUP VALIDATE. To validate specific backup sets, run the 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.
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
To check for logical corruptions in addition to physical corruptions, run the following variation of the preceding command:
RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
Hence, I would go with B, D
B and D
C incorrect
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
11 OK 0 7377 33280 2662221
File Name: /u01/app/oracle/oradata/cdb2/pdb2_12/system01.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 14440
Index 0 8814
Other 0 2649
Checks are physicals and no logicals
VMC,did u find the dumps helpful??
what % of questions u got in exam from these questions??
Thanks,
LC
BD
This command can validate logical corruptions, but it requires command like below
BACKUP VALIDATE
CHECK LOGICAL <– This required for the logical correction. Without this, it can check only physical corruptions.
DATABASE ARCHIVELOG ALL;
BD
B,D are correct