any issue if i adjust the UNIX server clock that run an oracle database??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

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

    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..

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

  3. #3
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    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 ??

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Moving the clock forward, no problem.

    Moving the clock backwards, database crashes.

    Learned this from Y2K testing.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width