RE: Semi-OT: Solaris file dates don't match system date after DST change
Date: Thu, 13 Mar 2014 10:13:10 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB60189015B_at_HKMGAXMB103A.zone1.scb.net>
I don’t think that Oracle is sensitive to the timestamp of datafiles. Even RMAN’s SET UNTIL clause uses an SCN to TIMESTAMP match on the database server.
Hemant K Chitale
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Taylor
Sent: Wednesday, March 12, 2014 10:18 PM
To: dale fanning
Cc: oracle-l_at_freelists.org
Subject: Re: Semi-OT: Solaris file dates don't match system date after DST change
Yep - the filer has the wrong date and timezone offset after the maintenance.
So, now I'm wondering about the impact to a running database when the timestamp on the datafiles jump ahead when they correct the time on the netapp filer. Since the netapp filer is "behind" I'm thinking this will be okay. But if the netapp filer had been ahead, I can imagine this would be a problem if we had to adjust the date backward in time.
Chris
On Wed, Mar 12, 2014 at 8:38 AM, dale fanning <rv9deltafox_at_gmail.com> wrote:
Haven’t actually seen anything like that, but I’d check the time on the filer.
On Mar 12, 2014, at 9:36 AM, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:
We have a Solaris 10 server and I just noticed that the dates on newly created files aren't matching the SYSTEM date of the server. The filesystem in question is mounted on a Netapp device and the netapp device was taken down for maintenance (controller upgrade) this past weekend.
Has anyone seen this behavior before - I've sent an email to the SA but thought I'd ping the list to get some input. (Perhaps I'm just sleepy and am overlooking something obvious):
Date:
$ date
Wednesday, March 12, 2014 6:05:17 AM PDT
$ touch test.txt
$ ls –lart test.txt
-rw-r--r-- 1 oracle oinstall 230016 Mar 12 00:07 test.txt
Am I missing something, or could this be a problem?
Chris
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 13 2014 - 03:13:10 CET