Fix corrupted block
I have a database 11.2.0.4.
User gets a corrupted block error on a specified datafile.
I issued:
VALIDATE DATAFILE '/oradata1/dbname/filename01.dbf';
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 1 10781 89600 312773762
File Name: /oradata1/dbname/filename01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 77996
Index 0 0
Other 0 823
Also
select * from V$DATABASE_BLOCK_CORRUPTION ;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
5 2810 1 0 FRACTURED
The db is backed up through RMAN. What is the best way to proceed to recover.