- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Adjusting data backwards slowly in HPUX10.20
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
тАО01-18-2005 04:59 PM
тАО01-18-2005 04:59 PM
Adjusting data backwards slowly in HPUX10.20
I have a ntp server which is running HPUX10.20, lets call it server 1.
I have other ntp clients being synchronised to server1. The ntp clients include Oracle database servers
Unfortunately, server1 is 15 minutes ahead of the official time. How do I adjust server1 time backwards safely? I understand that it is not safe to adjust an Oracle database server time backwards
Note that in HPUX10.20, the date command does not have the -a option
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2005 05:07 PM
тАО01-18-2005 05:07 PM
Re: Adjusting data backwards slowly in HPUX10.20
indeed it is not safe to adjust the Oracle Database time backward, especially if the gap is so big!
We did it some times back. This should be how you must proceed:
1. shutdown the database
2. wait for 15 minutes.
3. Change the time backwards (use set_parms date_time).
4. restart the server and database
hope this helps!
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2005 05:15 PM
тАО01-18-2005 05:15 PM
Re: Adjusting data backwards slowly in HPUX10.20
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2005 05:32 PM
тАО01-18-2005 05:32 PM
Re: Adjusting data backwards slowly in HPUX10.20
You will then have wait for a time when you have less load to do.
make sure your scheduled JOBs (DBMS_JOBS) are not affected by this change...
You will have to do a proper assessment of all your applications and database and prepare this change properly!
Ask yourself questions...
e.g.
what will be the impact of the number of data entered for a particular process doubles for a 15 minutes time interval? What happens to my KPIs? etc.
if this is not a problem, you can safely do the changes.
A server restart will only ensure that all logs are in sync..
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2005 06:27 PM
тАО01-18-2005 06:27 PM
Re: Adjusting data backwards slowly in HPUX10.20
Strictly speaking one should bounce the database when you change the server time.
Changing the system date will not cause corruption. You could get problems with point in time recovery and flash back queries if you set the time backwards. Oracle is generally not affected by dates as it uses the SCN to record changes not the date timestamp.
Most of the time, if you have DBMS_JOBS, they are the ones really affected. They will not run as desired and will be hung. Especially when you wanted to the server time switched back. And there could be application that will be effected.
Really well designed applications, when timestamping data, should either record the timezone used or store the date/time in UCT.
If you can afford the downtime, it would probably be wise to shutdown the database, change the time, and reboot the server as Yogeeraj mentioned.
This will ensure that ALL daemons (and other stuff) are working in (and logging with) the same (new) time.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2005 07:13 PM
тАО01-18-2005 07:13 PM
Re: Adjusting data backwards slowly in HPUX10.20
If this is a critical system (as you would rather not shut the db down for 15 min) I would strongly recommend upgrading to a supported version of HP-UX.
Also if correct time is critical you should sync time with a reliable source.
Regards,
Trond
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2005 07:27 PM
тАО01-18-2005 07:27 PM
Re: Adjusting data backwards slowly in HPUX10.20
have a look at the following metalink document too:
Note: 77370.1
Subject: What are the effects of changing the system clock on an Oracle Server instance?
hope this helps too!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2005 02:37 AM
тАО01-20-2005 02:37 AM
Re: Adjusting data backwards slowly in HPUX10.20
Look at xntpd but the catch is also talk to your oracle guys ... xntpd gives you the ability to "slow" the time on your machine.
The safest way is off course the 15 minute outage method. This is not always possible especially if the date goes ours off.
Regards
Gerhard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2005 02:47 AM
тАО01-20-2005 02:47 AM
Re: Adjusting data backwards slowly in HPUX10.20
Man 2 adjtime for details. This is probably safer than running the 10.20 version of ntpdate because if you write the program, you know exactly what it does.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2005 03:00 AM
тАО01-20-2005 03:00 AM
Re: Adjusting data backwards slowly in HPUX10.20
You should even be able to set the speed it uses to do it.
In question or doubt, crosspost to comp.protocols.time.ntp - they should be able to tell You within minutes.
otoh - can't You 'hold time'* after You finished backups? this probably would be the best moment.
regards,
florian
*I remember some women also ask for that - is oracle female?