Re: Changing System Clock
- From: "Dennis Heisler" <oracle@xxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Apr 2004 21:24:06 -0700
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
