- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Linux
- >
- Re: Time running forward
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2011 02:01 AM
тАО03-24-2011 02:01 AM
Time running forward
I have a system whose time is running forward.
It has a database on it. the time has jumped by 15 days forward.
I cannot just set the time back as this will mess up the data base.
I cannot stop the system and wait the 15 days as it is a production system'
if i use ntpdate -B i get an invalid argument error.
How do i slow time down so we can catch up?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2011 04:13 AM
тАО03-24-2011 04:13 AM
Re: Time running forward
Tuning the kernel timekeeping parameters with the adjtimex command would probably be the best way to implement such a large time-change operation. You would do it by using "adjtimex -t
So with the timetick value set to the minimum, you can adjust the clock by 8640 seconds, or about 2 hours per day.
15 days is 1 296 000 seconds. So it will take about 150 (= 1296000 / 8640) days to fix your time difference.
You might want to ask your DBA and application people if it is possible to fix things with a like this:
Step 1.) applications shutdown, database remains up
Step 2.) DBA runs a mass update to fix the erroneous time values inside the database
Step 3.) Database shutdown: only the OS remains running.
Step 4.) You adjust the system clock.
Step 5.) Reboot and start database, verify the database is OK
Step 6.) Start applications, verify everything is OK.
This would have the advantage of having a clearly-defined transition point. Before the transition, the time values are 15 days off; after the transition, they are correct again. If you adjust the time gradually, everyone that uses the time data of your database must know how to calculate the correct time from your database time values.
MK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2011 04:18 AM
тАО03-24-2011 04:18 AM
Re: Time running forward
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2011 03:53 PM
тАО03-28-2011 03:53 PM
Re: Time running forward
Ours always use logical date -- the DB "never" relies on OS time.
Is this server a Virtual Server by any chance? If it is -- can you give us the virtualization environment?
EIther way -- do you have NTP enabled?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2011 02:28 AM
тАО03-31-2011 02:28 AM
Re: Time running forward
On vmware. Not sure of all the details as the vm specialist set it up.
I look at the os side only.
But just started to jump a day ahead at random.
It is linux redhat enterprise 5.5.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2011 05:37 AM
тАО03-31-2011 05:37 AM
Re: Time running forward
Also - what kind of vMware Hypervisor? -- Is it Vmware Server 2.0 or ESXi or ESX or vSphere?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2011 08:32 AM
тАО03-31-2011 08:32 AM
Re: Time running forward
What is the verson of your vMware and RHEL Guest?
Have a look here too:
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1006427