RE: REDO LOG Concepts

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

> 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.

Hi Mario

IMHO with a bit of common sense the method works. 
You simply copy non-current redos before doing the switch...

The point is:
- Oracle opens the members of a group when the group becomes active.
- It is possible to force the switch.


Take care,
Chris
--
//www.freelists.org/webpage/oracle-l


Other related posts: