Re: REDO LOG Concepts

  • From: "DBA Deepak" <oracle.tutorials@xxxxxxxxx>
  • To: gelfand.transform@xxxxxxxxx
  • Date: Thu, 17 May 2007 17:02:34 +0530

No Mario it works for me but only twice (for CURRENT & ACTIVE log groups)
not for INACTIVE group (It hangs).

Does this confirm that Oracle always puts locks on all CURRENT and ACTIVE
redo log files?


On 5/17/07, Mario Cariggi <gelfand.transform@xxxxxxxxx> wrote:
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
> 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.




Oracle DBA

Other related posts: