Re: Date Modified on logfiles not changing

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Thu, 03 Sep 2009 14:23:45 GMT
Message-ID: <RjQnm.42471$Db2.42237_at_edtnps83>

"joel garry" <joel-garry_at_home.com> wrote in message news:2fbfd9c9-156c-4567-b02c-921f4aaba2b7_at_z4g2000prh.googlegroups.com... On Sep 2, 3:28 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> I have a 10.2.0.4 database on W3K where the Date Modified (as shown in
> windows explorer) is stuck on 07/07/2009 6:42PM. That's the time that the
> instance was last started.
> But looking in v$log and v$logfile I can see that the filenames and
> timestamps are all correct. So this is a mystery to me. Anyone ever seen
> this behavior?
>
> --
> Terry Dykstra

(Sorry for previous brain-damaged reply, for those who see it even though it is now deleted. Been a crazy day.)

I believe this is because Oracle reuses the log files, so it just keeps them open from when the instance is started. I bet if you create a new one, or offline/online one, you'll see the newer date. Don't see this on other platforms.

jg

--
_at_home.com is bogus.
http://www.theregister.co.uk/2009/08/19/att_dumps_kevin_mitnick/

With 9i I don't see this behavior either.

-- 
Terry Dykstra

Received on Thu Sep 03 2009 - 09:23:45 CDT