Re: Daylight Savings and Logs

vanwegen@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 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. OnLine does not use the real time to determine when a log item should be restored. It uses an internal mechanism a bit like a counter. The first write is 1, the second 2, the third 3 etc. This is how it knows which pages to flush during a checkpoint, it reads through the buffers looking for pages with a value greater than the one used at the last checkpoint. As far as your timezone change is concerned, you shouldn't have any problems. The internal timestamps will continue to be incremented even though your system clock will go back one hour. Regards Paul McGuire