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!
I thought of doing this. However i did not quite understand how it worked. Firstly, i had several corrupt blocks and secondly we had backups which were failing, hence the last good backup was about 7 days old. So i could have block recovered to the log sequence number of the of the last known good backup but then how would i have rolled forward to get it all in synch with the rest of the db?
BTW the datafile restore/recover worked fine. Thanks Davey for your help!