Re: REDO LOG Concepts

  • From: "Mario Cariggi" <gelfand.transform@xxxxxxxxx>
  • To: Christian.Antognini@xxxxxxxxxxxx
  • Date: Thu, 17 May 2007 12:25:04 +0200

On 5/17/07, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> 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

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.



Other related posts: