053-402

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数据库块损坏

 

posted @ 2017-11-14 10:11  巴啦啦大魔王  阅读(124)  评论(0编辑  收藏  举报