Re: RedoLog file corrupted!!

Hi Andrea

First make a copy off what you have now. If we are talking about mirrored logfiles, which we off course are ?!!, you should take a copy of the good one, rename put it where the corrupted logfile should be, then start the database.

If both are corrupted, and not the active one, start up in the correct mode and remove the group.

If we are talking about the active logfile, i think the only thing you can do is to start the database up with one off the undocumentet parameters which start with a _ , I cant remeber which one it is but somethin like _logfile_reset bla bla=false/true

"michael ngong" <mngong_at_yahoo.com> wrote in message news:ecf365d5.0210230456.6895699b_at_posting.google.com...
> please my oracle db server (8.1.6) doesn't work because one of redolog
> member is corrupted... in my alertlog file show that cannot start
> instance
> because don't find redo02.log!
>
> I have another 2 members logfile, someone knows how i can restore the
> second
> redolog ??
>
>
> If you cannot start up it implies you had a shutdown.Did you backup
> after the shutdown?If you did and could restore you might not have
> started this thread.
> If you had multiple copies of the logfiles which is normally advised
> ,one of them would simply have been used if another member was corrupt
> and you could drop and recreate the corrupt member.
> Was there an Oracle error #.Are you in archivelogMode or not?
>
> Michael Tubuo Ngong
Received on Fri Oct 25 2002 - 10:23:16 CDT