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

From: Alex Hudghton <alex.hudghton_at_capgemini.co.uk>
Date: Thu, 14 Jan 1999 09:11:11 +0000
Message-ID: <369DB4AF.EDE427CE@capgemini.co.uk>

Try this - courtesy of http://www.orafaq.org/faq2.htm (the Oracle Underground FAQ)

Regards

Alex

> I've lost my REDOLOG files, how can I get my DB back?
>
> The following INIT.ORA parameter may be required if your current redologs are corrupted or blown away. Caution is
> advised when using it as you might end-up with lost or inconsistent data!!!
>
> _allow_resetlogs_corruption = true
>

David Schwartz wrote:

> 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 - 03:11:11 CST