I have a database that is not open. And I have a redo log that is corrupted.
What would be the best way for me to open the database? This is a testing db and I am not concerned with data loss - but I need to get the database open and working again.
Some additional notes: Trying to switch logs tells me that the log is required for recovery Attempting to recover fails Trying to open gives the error msg that the log is corrupted
Additional clarification: I do need some of the data in the db; but I don't need any of the recent data (about a year worth of data). There is some configuration data which I do want. I don't know the structure of the db, and I have no script to re-create it.