Re: server time reset

From: Ben <benalvey_at_yahoo.com>
Date: Tue, 17 Jun 2008 10:23:37 -0700 (PDT)
Message-ID: <d49d56dc-a587-4dec-ba87-32b4ccad7862@k13g2000hse.googlegroups.com>


On Jun 17, 11:37 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Tue, 17 Jun 2008 06:21:46 -0700, fitzjarr..._at_cox.net wrote:
> > On Jun 17, 7:52 am, Ben <benal..._at_yahoo.com> wrote:
> >> 10.2.0.2 EE aix 5.2
>
> >> we have a server that somehow got behind in time by 5 minutes. I
> >> mentioned it to the sysadmin and next thing I knew she had changed the
> >> time on the server ahead 5 minutes. First thought was panic and what is
> >> going to happen to the database now. Nothing seemed to happen. We
> >> haven't rebooted the server yet or restarted the database that was
> >> running on that server yet. I could see some really disasterous
> >> scenarios if the time was pushed back, but essentially we skipped about
> >> 5 minutes of the day. Anyone ever have this happen before or have any
> >> comments on things they could see coming down the line when the
> >> database restarts?
>
> > This happens, twice yearly, when Daylight Savings Time commences and
> > when Standard Time returns, and this involves an hour difference either
> > way, and I've yet to experience any issues with Oracle.  Yes, during the
> > above-mentioned scenario you can duplicate an hour which could make it
> > difficult to perform a PITR based upon clock time, but you still have
> > the SCN as a reference point, and that doesn't change when the clock
> > does.
>
> > I really see no issue here.
>
> > David Fitzjarrell
>
> Especially because the database coordination mechanisms depend on the
> SCN, not on the time. I have the experience of recovering a database
> up to the point right after the DST switch. Nothing happened. Nothing at
> all.
>
> --http://mgogala.freehostia.com- Hide quoted text -
>
> - Show quoted text -

thank you both very much for the info. hadn't thought of it in comparison to DST, makes perfect sense. Received on Tue Jun 17 2008 - 12:23:37 CDT

Original text of this message