Re: Redo log file damaged. Help!

Danil wrote:
>
> Hello, all. Please help!
>
> When I try to open database, I get error messages:
> ORA-0368 Checksum error in redo log block
> ORA-0353 Log corruption near block 316 change 248148
> ORA-0312 Online log 2 thread 1 : 'logfile1.ora'
>
> I think that is due to redo log file damage.
> How to recover redo log file?
> Or how to recover information in database?
> ( There is no backup copy of database :-(( )
>
> Danil Krasnov.
> If possible, copy answer to email: danil_at_maginfo.net
>
> Thanks in advance.

Ring up your local Oracle support representative, with whom of course you have an annual support contract ? :-)

Definitely back up everything you currently have that constitutes the Oracle database - data files, log files, control files, init.ora files and any other files I can't remember. Do this before attempting anything else. At least then you can get back to this screwed up point in time if you have to.

There is an option when opening the database "RESETLOGS" which seems to reinitialise the log files. Does anyone know if that would work? I confess I've never had to use it.

Oh yes, and get a proper backup strategy!

Dave O'Keeffe
--
For email replys remove "n0spam." from the above address Received on Tue Apr 21 1998 - 15:12:21 CDT