We are getting to several occurences of ORA-01578: ORACLE data block corrupted (file # 9, block # 13)
ORA-01110: data file 9: '/oracle/dbs/tbs_91.f'
There are several block numbers which are mentioned. The alert log shows the what exactly is corrupt. It is a table. Now because of this our RMAN backups have failed too. So how do i recover the datafile?. Do i need to go back to the last successful backup restore the datafile and roll forward from there? if so, how do u tell RMAN which backup u need to restore from(just the datafile!)? Please help urgently!
Thanking u advance,