kishoredba

 Profile Answers by kishoredba 

• Jul 21st, 2008

 

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

Rman>block recover datafile <dbfileid> block <blockid>;

using above statement we recover corrupted blocks.

sangeethaso

 Profile Answers by sangeethaso 

• Aug 25th, 2010

 

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.

sangeethaso

 Profile Answers by sangeethaso 

• Aug 26th, 2010

 

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.
 

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;

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