Re: recovery puzzler

Matt,

If the log switched from 66 to 67 on Monday, and you want to do a PIT recovery to Friday, the recovery will never want to look at log # 67, as it contains transactions that all occurred *after* the PIT on Friday that you wish to recover to.

Jared

On Friday 08 June 2001 13:05, Adams, Matthew (GEA, 088130) wrote:
> This is puzzling me.
>
> On monday morning, the log file switched from sequence 66 to 67.
> On monday night, a hot backup was taken.
>
> On Friday, this backup was written to an alternate machine
> an attempt was made to do a point-in-time-recovery to Friday
> Morning.
>
> Why did it ask for archive file 66? I should have thought it
> would start with file 67.
>
> ----
> R. Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
> Meddle not in the affairs of troff,
> for it is subtle and quick to anger.

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).