Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Will time synchronization affect Oracle?

Re: Will time synchronization affect Oracle?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 04 Jan 2000 19:17:50 +0800
Message-ID: <3871D6DE.FF4@yahoo.com>


Chuck wrote:
>
>
>
> I have some 805 db's running on Sol. 2.6. I sync the times of these
> servers frequently using rdate. The db's are not running in archive
> log mode. How does Oracle respond to changes in the system time?
>
> Thanks,
> CHuck

Use NTP instead of rdate - its more accurate, and does changes in deltas rather than 'big' changes that rdate does.

I've crashed an instance by setting the date backwards in oracle...I wouldn't recommend it.

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Jan 04 2000 - 05:17:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US