where we can find block corruption? which view desc block corruption?

phanindra

• Oct 29th, 2014

Simple way is to run
RMAN>block recover corruption list;

Corruption list specifies info of corrupted blocks from v$database_block_corruption

naveenkumar

• Apr 3rd, 2012

We can find corrupted block by this command in sql>select * from database_block_corruption;

we can also find the corrupted block from unix command by database verify $ dbv file=path block size=8192;

Answer Question  Select Best Answer