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

How do you identify the block corruption in RMAN database? How do you fix it?

oracle56

 Profile Answers by oracle56 Questions by oracle56

• Aug 24th, 2008

First check whether the block is corrupted or not by using this commandsql>select file#, block#  from v$database_block_corruption; file#  block  2        507the above block is corrupted.....

kishoredba

 Profile Answers by kishoredba Questions by kishoredba

• Jul 21st, 2008

Using v$block_corruption view u can find which blocks corrupted.Rman>> block recover datafile block ;Using the above statement u recover the corrupted blocks.Thanks & Regards,Kishore.

Answer Question  Select Best Answer

If Several databases are up and running, which command will help to monitoring in os ?

saneshkale

 Profile Answers by saneshkale Questions by saneshkale

• Apr 5th, 2010

Ps -ef|grep pmon

tendulkar

 Profile Answers by tendulkar Questions by tendulkar

• Mar 27th, 2010

Df -h

Answer Question  Select Best Answer

kishoredba

 Profile Answers by kishoredba Questions by kishoredba

• Jul 23rd, 2008

BR* Tools

Answer Question  Select Best Answer