Re: Changing operating system time...

Many thanks for the advice.

The system is intended to be a simulation of a single day - a 'groundhog' day scenario - so data will be reset at the end of the day.

Any idea what the other complications to retarding time might be? I've often heard people say there is a problem doing this, but I'm not sure why...

regards
P

"Jusung Yang" <JusungYang_at_yahoo.com> wrote in message news:130ba93a.0210180937.763a8ce3_at_posting.google.com...
> 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
Received on Fri Oct 18 2002 - 20:32:15 CEST