OCP CBT Question 567

Please solve the following question.

A DBA identifies a corrupt block in a data file using `V$DATABASE_BLOCK_CORRUPTION`. The corruption is isolated to a single block within the USERS01.DBF data file (file #4, block #123). The database is in ARCHIVELOG mode and fully operational. Which RMAN command can be used to repair this specific corrupt block without affecting the rest of the database?

sql-- Database is open and in ARCHIVELOG mode-- Query results from V$DATABASE_BLOCK_CORRUPTION:FILE# BLOCK# BLOCKS CORRUPTION_TYPE------ ------- ------- -------------------4 123 1 LOGICAL

sqlRMAN> RECOVER DATAFILE 4 BLOCK 123;

sqlRMAN> RECOVER DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf' BLOCK 123;

sqlRMAN> RESTORE DATAFILE 4 BLOCK 123;RMAN> RECOVER DATAFILE 4 BLOCK 123;

sqlRMAN> RECOVER DATABASE BLOCK 123;