Re: Changing operating system time...

Pretty much anything that depends on time will need to be looked at. For example prescheduled jobs, materialized view refresh (which is sometime done by scheduling a job). The issue with point in time recovery is the biggest one though. Cann't give you a complete list. I experienced it only once before, thank god. Do some search in this NG or Metalink, you may find other issues.

• Jusung Yang

"Anon" <root_at_127.0.0.1> wrote in message news:<PsYr9.6596$c02.42695946_at_news-text.cableinet.net>...
> 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 Sat Oct 19 2002 - 00:58:06 CEST