Re: log corruption

From: <markp7832_at_my-deja.com>
Date: Thu, 23 Dec 1999 23:35:03 GMT
Message-ID: <83ubgl$7hd$1@nnrp1.deja.com>

In article <83tclo$99u_at_sirio.tno.it>,
"Tony Martino" <T.Martino_at_tno.it> wrote:
> Hi there,
>
> after a system crash my Oracle Server 8.0.5 cannot start anymore. The
> following is the starting log:
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 28146960 bytes
> Fixed Size 48400 bytes
> Variable Size 21880832 bytes
> Database Buffers 6144000 bytes
> Redo Buffers 73728 bytes
> Database mounted.
> ORA-00354: corrupt redo log block header
> ORA-00353: log corruption near block 66 change 789623 time 12/22/99
16:02:27
> ORA-00312: online log 1 thread 1:
> '/home/oracle/u02/oradata/SIM1/redoSIM101.log'
>
> --
>
> How can I take my server running again?
>
> Any help will be appreciated.
>
> _____________________________________________________
> Tony Martino
>

Start by looking at the backup and recovery manual. There is a section about recovering from losing a redo log. Is the corrupted log the current log or not.. If not I belive there is a command to clear the log that you can use. It is documented in the manual, but I am at home and do not have a copy handy. I believe that you can determine which log is current by using the archive log list command or maybe select * from v$logfile.

I think the process is something like:
startup mount
archive log list or select * from v$log alter database clear [unarchived] logfile xx alter database open resetlogs

But you should check the manual. Good luck.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 23 1999 - 17:35:03 CST