any issue if i adjust the UNIX server clock that run an oracle database??

[ngwh]

hi,

asking u guys some opinion....will there be any issue if I adjust the UNIX server system clock forward that run a Database server w/o shutting it down ?

pls enlighten..

[Orca777]

Hi,
i believe that oracle calls the sysdate from the system.
so the time will adapt immediatly.

The problem i do not know could be dba_jobs and time sensitve operations of the application whiche use your database.

Orca

[ngwh]

yup..my worries are the DB checkpoint issue wonder if any forward time adjustment w/o shutting down Oracle Database...will there be any problem ??

[Orca777]

Hi,
the worst thing could happen that checkpoint runs immediatly
no problem;
and i am not shure if checkpoint-interval dependes on absolute system-time or is based on relative time-interval ( internal counter )
But this should not be a problem!
think of the switching from winter time to summer time we have in europe. never heared rising problems due to this time-change (1 hour )
Orca

if you have still doubt then
use : ALTER SYSTEM CHECKPOINT;
and switch time after this command
ORca

[marist89]

Moving the clock forward, no problem.

Moving the clock backwards, database crashes.

Learned this from Y2K testing.