Re: checksum error in redo log block

The relevant log member is toast.

If you have a support contract with Oracle, phone them now.

There are too many risks in giving snippets of advice which may not exactly suit your situation.

Speak to as experienced an Oracle DBA as you can find.

D.P.

James Thornton wrote:
>
> Apparently, a redo log is corrupted -- what is the best way to fix
> this...?
>
> --
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> shutdown abort
> ORACLE instance shut down.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 84713632 bytes
> Fixed Size 73888 bytes
> Variable Size 76079104 bytes
> Database Buffers 8388608 bytes
> Redo Buffers 172032 bytes
> Database mounted.
> ORA-00368: checksum error in redo log block
> ORA-00353: log corruption near block 1375 change 1123028 time 04/14/2001
> 10:57:44
> ORA-00312: online log 1 thread 1:
> '/ora8/m01/app/oracle/oradata/ora8/redo01.log'
>
> Thanks.
>
> - JT
> _________________________________________
> James Thornton, http://jamesthornton.com
Received on Sat Apr 21 2001 - 21:15:33 CDT