If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Block Corruption

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?