Re: Effect on Oracle of changing server time from EST to GMT
Another issue might be related to doing time-based recovery. Oracle has a couple of notes on metalink related to changing server time and database impact. Note:1013279.6 - HOW DOES DAYLIGHT SAVINGS TIME AFFECT THE DATABASE? Note:77370.1 - What are the effects of changing the system clock on an Oracle Server instance? From: Stephane Faroult [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Effect on Oracle of changing server time from EST to GMT Date: Thu, 16 Oct 2003 15:04:40 -0800 Well, some jobs (including snapshot refreshes) may get confused, and if you create or alter objects I wonder how Oracle may handle dependencies ... Fortunately you are moving 5 hours ahead, rather than back, so risks are probably quite limited. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Effect on Oracle of changing server time from EST to GMT
Another thought for 9i...how would a time change impact flashback query? Daniel Fink david davis wrote: Another issue might be related to doing time-based recovery. Oracle has a couple of notes on metalink related to changing server time and database impact. Note:1013279.6 - HOW DOES DAYLIGHT SAVINGS TIME AFFECT THE DATABASE? Note:77370.1 - What are the effects of changing the system clock on an Oracle Server instance? From: Stephane Faroult [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Effect on Oracle of changing server time from EST to GMT Date: Thu, 16 Oct 2003 15:04:40 -0800 Well, some jobs (including snapshot refreshes) may get confused, and if you create or alter objects I wonder how Oracle may handle dependencies ... Fortunately you are moving 5 hours ahead, rather than back, so risks are probably quite limited. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Effect on Oracle of changing server time from EST to GMT
Good point, Dan. If using SCN to flashback then it's a non-issue. Avoid using date/time stamp to flashback during that 1 hour period. Or find out the SCN from SYS.SMON_SCN_TIME table closest to the past time, and use it to flashback. - Kirti --- Daniel Fink [EMAIL PROTECTED] wrote: Another thought for 9i...how would a time change impact flashback query? Daniel Fink david davis wrote: Another issue might be related to doing time-based recovery. Oracle has a couple of notes on metalink related to changing server time and database impact. Note:1013279.6 - HOW DOES DAYLIGHT SAVINGS TIME AFFECT THE DATABASE? Note:77370.1 - What are the effects of changing the system clock on an Oracle Server instance? From: Stephane Faroult [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Effect on Oracle of changing server time from EST to GMT Date: Thu, 16 Oct 2003 15:04:40 -0800 Well, some jobs (including snapshot refreshes) may get confused, and if you create or alter objects I wonder how Oracle may handle dependencies ... Fortunately you are moving 5 hours ahead, rather than back, so risks are probably quite limited. -- Regards, Stephane Faroult Oriole Software __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Effect on Oracle of changing server time from EST to GMT
Title: Effect on Oracle of changing server time from EST to GMT Only if the application is using sysdate ,otherwise I dont see any problems with databases. Hope this helps. Regards Pawan -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 9:04 PMTo: Multiple recipients of list ORACLE-LSubject: Effect on Oracle of changing server time from EST to GMT To support internationalization, we may need to change our server time zone from US EST to GMT. What effect, if any, will this have on the Oracle databases? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com ...OLE_Obj... The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
Re: Effect on Oracle of changing server time from EST to GMT
Well, some jobs (including snapshot refreshes) may get confused, and if you create or alter objects I wonder how Oracle may handle dependencies ... Fortunately you are moving 5 hours ahead, rather than back, so risks are probably quite limited. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Effect on Oracle of changing server time from EST to GMT
Guiness Mean Time will not have effect on the time recorded in the database, just how it is displayed. On 10/16/2003 11:34:26 AM, David Wagoner wrote: To support internationalization, we may need to change our server time zone from US EST to GMT. What effect, if any, will this have on the Oracle databases? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com ...OLE_Obj... The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).