Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: REDO LOG Concepts

RE: REDO LOG Concepts

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 17 May 2007 13:46:43 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAFB237E0@MSXVS04.trivadis.com>


> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 17 2007 - 06:46:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US