RE: Semi-OT: Solaris file dates don't match system date after DST change
- From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
- To: <christopherdtaylor1994@xxxxxxxxx>
- Date: Thu, 13 Mar 2014 10:13:10 +0800
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Chris Taylor
Sent: Wednesday, March 12, 2014 10:18 PM
To: dale fanning
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxx>
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.
Other related posts:
