Re: REDO LOG Concepts

On 5/17/07, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
> Hi Stefan
>
> > I've run into this situation before as well. It happens,
> > people accidentally delete files.
> >
> > What would be interesting to research, is if you still
> > can somehow recover those files.
>
> Mhmm... Among other things it's exactly for such situations that we
> should put multiple members in a group. If you have another member, just
> do a "alter system switch logfile" and copy it where it has been
> deleted...

the switch logfile won't work because Deepak removed all the logfiles in his test, so if you try a switch logfile the LGWR process tries to open the next logfile but it doesn't find it.

 Your advice is valid if by mistake you remove only the current logfile.

Regards.

Mario.

--
http://www.freelists.org/webpage/oracle-l