Re: REDO LOG Concepts

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?

Deepak

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

-- 
Regards,

Deepak
Oracle DBA

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