Re: Changing operating system time...

The behaviour when running ntpd, strongly depends on the OS you're running. Solaris 7 on Intel e.g. is known to have problems with it (due to the fact that absolute timers i.s.o. relative occur at kernel level). Running it on Linux, nicely adapts the time when drift occurs, and should cause no problem.

Changing time abruptly without bringing down Oracle is indeed asking for problems !

mdsc

> I clearly recall a UNIX admin that I worked with some years back
> changed the system clock and brought down all ORACLE instances running
> on that server. So, restarting ORACLE would be a certainty. There are
> other complications when you change the system clock, especially when
> you set it backward. You are going to have trouble doing point in time
> recovery should you ever need to do that. I would say do a full backup
> of your databases before you start changing the system time. I am not
> sure what would happen if you run NTPD in the background continuously.
> I would not recommend it though.
>
> - Jusung Yang
>
> "anonymous" <anonymous_at_prefer.not.to.say> wrote in message news:<yoQr9.5846$n9.38524017_at_news-text.cableinet.net>...
> > Hi,
> >
> > I need some advice wrt changing system time, underneath a running Oracle 8
> > or 9 database...
> >
> > Is it possible to change system time significantly (ie, one month back in
> > time) without restarting Oracle?
> > Can Oracle co-exist with an NTPd process continually tweaking system time?
> > Does changing system time backwards significantly (i.e., back by a month)
> > affect Oracle?
> >
> > What little info I've been able to find suggests you might have to stop
> > Oracle, change time, start Oracle. And I can't find anything definitive
> > about Oracle co-existing with an NTPd.
> >
> > Thanks in advance!
> > P.
> > http://www.planetsaturn.pwp.blueyonder.co.uk

--
______________________________________________________________________________
 Marc De Schryver - Unix Software Engineer

______________________________________________________________________________
 In a world without walls and fences, who needs Windows and Gates?
______________________________________________________________________________
 If we learnt something, it's that freedom wins !
 Breaking Down the Barriers to Open Source Development
______________________________________________________________________________