053402

While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block
corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?
A. RECOVER FILE=1201 BLOCK=1968;
B. RECOVER CORRUPTION LIST;
C. RECOVER DATAFILE 1201 BLOCK 1968;
D. RECOVER BLOCK CORRUPTION LIST;
E. None of the above

  Option A is incorrect because the syntax is wrong.Option D is incorrect because BLOCK doesn't belong.B is how we recover all corrupt blocks listed in V$DATABASE_BLOCK_CORRUPTION.C is the correct syntax to recover just the one block that we've identified as corrupt.

ORA-01578数据库块损坏

 

原文地址:https://www.cnblogs.com/Babylon/p/7831109.html