Re: corruption on redo log files

"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
Received on Wed Jun 06 2001 - 04:04:42 CDT