Re: DB file not updated in ARCHIVELOG mode?

From: Yong Huang <yhuang_at_indigopool.com>
Date: Mon, 11 Sep 2000 12:45:03 -0500
Message-ID: <8pj5sb$itl$1@news.sinet.slb.com>

Others have answered your questions.

When you say the datafile timestamp doesn't change, with what are you comparing? I think and remember datafiles could have a rather old timestamp on NT relative to checkpoint. That was on 7.3.4. Can you do this:

look at the timestamp of the datafile
immediately do a alter system checkpoint in SQL*Plus (or svrmgr) immediately look at the timestamp of the file again

BTW, what version of Oracle and what OS are you using?

Yong Huang
yhuang_at_indigopool.com

Ortwin Glück <glueck_at_freesurf.ch> wrote in message news:39B941D3.3E0B9B77_at_freesurf.ch...
> I have Oracle running in ARCHIVELOG mode (for backup reasons).
> I recognized that the modified date of the database file does not change
> unless i shutdown/startup the instance. In NOARHCIVE mode the modified
> date is changed on logfile switch. Archived Logfiles are created though.
> Is the data actually written to the DB file on logfile switch? Can I
> safely delete old archived logfiles without losing data?
>
> Ortwin Glueck
Received on Mon Sep 11 2000 - 12:45:03 CDT