Re: Recovering database with corrupted redo log files and no good backup

What Alex and Jeremiah said is correct but you should also name the corrupted rollback segments in your init.ora parameters using a line like this:

_corrupted_rollback_segments = (r01)

This technique can destroy your database so you should use it only if you're sunk anyway. And it is not supported by Oracle. However, I was on a site about a month ago where this situation occurred and I used this method and we saved the database minus about two hours of users' work.

Van

David Schwartz wrote in message <369D3D6F.BDE6A4AD_at_elucidate.com>...
>I think the subject says it all. Is it possible?
>I cannot start up my Oracle 8.0.4 database, because of an error
>indicating that the sequence in the redo log is off by a few. I don't
>really care about losing a little data.
>I've tried unsuccessfully to do an incomplete recovery. I'd at least
>like to be able to get at the data in my datafiles in some way or other.
>Please help.
> Thanks a lot,
> David
>
Received on Thu Jan 14 1999 - 13:04:25 CST