The day light savings time adjustment and Databases

[Q4you]

Our servers are all set to adjust automatically to daylight savings. Does this have any impact on the databses as the system clock will be turned back. Will DBs needs to down for that time duration. Will the SCN records will get out of sync if DB kept runing during that time ?

-Q4U

[Steven E. Protter · Accepted solution]

We have not turned our databases off for the past three years of daylight savings time switches. There has been no ill effect at all.

HP-UX 11/11.11 Oracle 8.1.7.x 32 bit and 64 bit.

Our servers are connected to a time server via ntp. They get the time change from that server.

SEP

[A. Clay Stephenson]

Not at all. Internally the time will continue to march forward. The only thing that will change is how the time is actually displayed.

For example, over a one second period the time will simply go from 01:59:59 CDT to 01:00:00 CST. Again, the internal time representation will continue to count forward. You should also note that you might have database uses scattered across the planet; each with different timezones. The internal representation for each is the same but what differs is the displayed time/date.

[Massimo Bianchi]

Hi,
I full agree for the question regarding the DB, but you should also take into account what application uses the DB.

For oracle only, is perfectly safe to keep the DB open, because it uses the SCN for tracking changes.

For SAP, the advise is to close the application, because it uses an internal rappresentation that is yyyymmddhhss, and this can lead to BIG problems.

Massimo

[Q4you]

Thanks for your replies. Sorry for late feedback...No problems were encountered. We just breezed thro without any any incident.