Re: Changing System Clock

Jeremy,

There should be no problem changing the system clock while Oracle is running. Oracle records its changes via the SCN. The only issue would be if you had to do a point in time recovery for the time period where the clock changed. In that case, you'd have to recover using SCN instead of time.

If you have Metalink access, take a look at note 1013279.6, "How does daylight savings time affect the database?"

Dennis

> Hi Team
> My organisation is in the process of setting up an NTP (network time
> protocol) service, to keep all our servers/pc's on the same time.
>
> I have asked Google if there are any issues with making changes to the
> system clock while Oracle is running, I was unable to find much
advise.
>
> I would appreciate any input from the list
>
> Environment: Redhat ASE 2.1 Oracle 8.1.7.4
>
> Cheers
> Jeremy
>
> ~~~~~~~~~~~~~~~~~~~~~~~~
> Jeremy Bainbridge-Smith
> Database Administrator
> Hamilton City Council
>
> Ph. +64 7 838 6428
> Mob. +64 21 894481
> ~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>

-- 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------