Block Corruption

using Rman we can find it.
V$block_corruption view there to find out corrupted blocks.

Rman>block recover datafile block ;

using above statement we recover corrupted blocks.

  2 Users have rated as useful.

  

Login to rate this answer.

Block corruption can be viewed from the view v$database_block_corruption, there is no view like v$block_corruption.

Using RMAN backup – block media recovery (oracle 10g database)

i.) Select * from v$database_block_corruption; --> Return rows if any corrupted blocks are found.

Multi block corrupted:
BLOCKRECOVER DATAFILE <file#> BLOCK <block#> DATAFILE <file#> BLOCK block#>;
Single block corruption:
BLOCKRECOVER DATAFILE <file#> BLOCK <block#>;

backup validate datafile 8;
Select * from v$database_block_corruption; --> no rows returned

The block media recovery is completed.

Block corruption can be viewed from the view v$database_block_corruption there is no view like v$block_corruption.

Using RMAN backup – block media recovery (oracle 10g database)

i.) Select * from v$database_block_corruption; --> Return rows if any corrupted blocks are found.

Multi block corrupted:
BLOCKRECOVER DATAFILE <file#> BLOCK <block#> DATAFILE <file#> BLOCK block#>;
Single block corruption:
BLOCKRECOVER DATAFILE <file#> BLOCK <block#>;

backup validate datafile <file#>;
Select * from v$database_block_corruption; --> no rows returned

The block media recovery is completed.
 

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;