This content has been marked as final. Show 2 replies
Set ALLOWRESETLOGS_CORRUPTION=TRUE. It is an hidden parameter which allows you to open the database in inconsistent state. I hope you are doing this on the different server. Recover it there, export the content you want and import that in your production environment. This link will help.
Thanks for the tip. That's an interesting idea, maybe something we might able to try as a last resort. I could do a complete restore of the db on a temporary system, open that one up with the hidden parameter and grab the data I need. Unfortunately it's a 5 terabyte database and we probably don't have storage available to make another copy of it ... it's looking like the most efficient option may be to lose the little bit of data left in the file (it will be dropped anyway once it's a few months old). I'll post an update with the outcome here ... if we have one soon ... Thanks !