From: Hieraklion <hieraklion@spray.fr>
Newsgroups: comp.databases.oracle.server
Subject: Re: corruption on redo log files
Date: Wed, 06 Jun 2001 11:04:42 +0200
Organization: Service Usenet NoosNet
Lines: 45
Message-ID: <3B1DF22A.4F674539@spray.fr>
References: <3B16573C.7922577D@netscape.net>
NNTP-Posting-Host: 192.168.1.254
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: hadron.noos.net 991818292 5354 192.168.1.254 (6 Jun 2001 09:04:52 GMT)
X-Complaints-To: abuse@noos.fr
NNTP-Posting-Date: Wed, 6 Jun 2001 09:04:52 +0000 (UTC)
X-Mailer: Mozilla 4.7 [fr] (WinNT; I)
X-Accept-Language: fr


"Bonjour" from Paris,

You can try this method :

- do a full offline backup
- Keep only dbf and ctl
- startup mount
- recover database until cancel -> a "media recovery complete" must appear
- alter database open resetlogs
- do full offline backup

"Au revoir" from Paris
Christophe
DBA Oracle

Cantonese Boy a écrit :

> 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