Hi,
I have a tablespace in one of my databases which is offline. I try to put the tablespace online but one of the datafiles has corrupted blocks, so I can't get the tablespace online.
This is a Ad Hoc database used to generate reports outside our production site. The tables within the corrupted tablespace contains only historical data and we just need the most recently data. We don't have a backup, since we can write a program to recover all the data from the main databases, but, since it is a large database with more than 5TB of data, it would be much faster to extract the data from the corrupted database.
I tried to set the event 10231 to force the database to skip the corrupted blocks, but it didn't work.
Anyone knows how to force the tablespace online to export the available data ?
Regards,
Antonio Belloni