Oracle-L: Re: Effect on Oracle of changing server time from EST to GMT

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Fri, 17 Oct 2003 13:19:33 -0800
Message-ID: <F001.005D382E.20031017131933@fatcity.com>

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 <Daniel.Fink_at_Sun.COM> 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 <sfaroult_at_oriole.com>
  > > >Reply-To: ORACLE-L_at_fatcity.com
  > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
  > > >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: kirtikumar_deshpande_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Oct 17 2003 - 16:19:33 CDT