Re: Daylight Savings and Redo Logs

tkyte_at_us.oracle.com (Thomas J Kyte) wrote:
>don't worry about it. Oracle doesn't use the system clock to figure out how to
>recover. It uses the scn (system commit number) to do that. The scn is sort of
>like an internal clock.
>
>vanwegen_at_firststate.com.au (Paul van Wegen Esq.) wrote:
>
>>We here in Australia(Sydney) are about to set our clocks back one hour
>>on 31/3/1996 at 03:00.
>>What implications are there regarding the redo logs.
>>We plan to stop our databases at 03:00 and leave them down for an
>>hour. Does anyone have any other suggestions. We are worried about
>>restore implications as the log timestamps would go from 3:00 back to
>>2:00.
 

>>Regards
>>pvw
>>-----------------------------------------------------------------------------
>>Paul van Wegen Esq. | EMail: vanwegen_at_firststate.com.au
>>First State Computing Pty. Ltd. | Phone: 061 2 2569887
>>Sydney. Australia. | Fax: 061 2 2569727
>>-----------------------------------------------------------------------------
>
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>
>
>--------------------------------------------------------
>opinions and statements are mine and do not necessarily
>reflect the opinions of Oracle Corporation.
>

What about recovery up to a certain point-in-time? We users don't used Oracle's clock. I guess this could only be an issue during a "fall back" when there could be two of the same time.

DL Kray Received on Tue Mar 26 1996 - 00:00:00 CET