BLOCK CORRUPTION:
==================
DB maintaince may occur unfortunately and one of the case we can say block corruption.
whenever we find that we are unable to view the data as excepted. We can observer it is block corruption.
Block corruption may happen below scenario's:
1.Hard disk
2.Powerfailuers
3.N/W Issues.
4.OS Issues
Identify methods for block corruption:
1.DBA_BLOCKCORRUPTION
2.DBVERIFY='datafile location'(OS COMMANDS).
3.USING RMAN(Validate datafile, tablespace)
Block media recover :
To do Block Media Recover the database should be in mount or open state.
Connect to RMAN target database.
then fire Recover
