impact of changing server time in Production Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: impact of changing server time in Production Database

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Hi ,

    most of u might be aware that in UK ,
    during summer and winter resons , time is changed by by 1 hour .
    could anybody tell me the impact of changing the server time in the above cases .
    do we need to take any special precaution during this time ( like backup, applying reset logs etc... )
    we are backing up using RMAN with catalog in tapes .
    catalog is in different server .

    looking to share your views .
    siva prakash
    DBA

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Time changing is very common in US.
    You need to aware the consequences when time gets changed.
    1 Your cron or any other scheduled jobs will run 2 times when the time is set backwards, example 2 am to 1 am, if the job is scheduled to run between 1 and 2 am.
    2 Your cron will not run because you move the time by 1 hr ( at 1 am , it is changed to 2 am.)

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    oracle uses the system change number (scn) for recovery
    so changing the clock will not affect your backups
    unless you need to do point in time recovery based on time

    steve
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Thanx .

    my concern was do i need to take a full 1 hour outage .

    situation is
    i have around 10 databases . i have not seen some of the tables structure . if any of the table is having internal audit build , columns like ( createdby , updatedby , deletedby , modifiedby ) etc.. then timestamp might be wrongly recorded or overwrite during any transaction .

    i am looking for a generic plan which can be applied for any database inspite of such circumstances .

    hope i am clear .

    [Edited by prakashs43 on 09-26-2002 at 01:41 PM]
    siva prakash
    DBA

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