corruption on redo log files

From: Cantonese Boy <cantoneseboy_at_netscape.net>
Date: Thu, 31 May 2001 22:37:49 +0800
Message-ID: <3B16573C.7922577D@netscape.net>

Hi,

My most current redo log files was corrupted and my database doesn't turn on the archive log mode. Is it possible to recover it?

I have try to clear the redo log file but it doesn't work.

SVRMGR> alter database open;
alter database open
*

ORA-00355: change numbers out of order
ORA-00353: log corruption near block 2 change 545248014 time 05/19/01 03:50:04
ORA-00312: online log 5 thread 2: '/dev/rhl_redo0502.lg' ORA-00312: online log 5 thread 2: '/dev/rhl_redo0501.lg' SVRMGR> alter database clear unarchived logfile group 5; alter database clear unarchived logfile group 5
*

ORA-00600: internal error code, arguments: [2752], [2], [3], [], [], [], [], []

I'm using oracle 7.4.3 on AIX 4.2.1

Thanks for any suggestion

Wayne Received on Thu May 31 2001 - 09:37:49 CDT