Re: Data- and control files not updated after insert?!!

On 18 Jun 2002 06:22:14 -0700, opal_at_xs4all.nl (Martijn Rutte) wrote:

>I've got 2 oracle 8.1.6 databases, one running on AIX 4.3.3, the other
>on Windows2000.
>
>When I insert a record in a table on the Oracle-AIX database, the
>concerned datafile on the unix filesystem as well as both oracle
>control-files are instantly updated (date-time as well as size are
>adjusted).
>
>When I do exactly the same on my Oracle-Windows2000 database, the
>date-time and size of the datafile and the controlfiles is NOT
>updated, although I commit the transaction immediately and although
>the insert shows when I perform a 'SELECT * FROM' on the table I
>inserted the record in.
>
>As I am running an incremental backup of all files on the windows2000
>system and the backup tool decides whether or not to backup files
>comparing date/time and size with their last succesful backup, those
>oracle data- and controlfiles are NOT put on tape, thereby causing
>loss of database data.
>
>Strange thing: after shutting down and starting up the database, the
>date-time and size of those files is indeed adjusted. But I don't want
>to shutdown and startup every time before/after performing a backup,
>because the system should be up-and-running 24 hours a day.
>
>This causes me serious trouble. Anyone who can help me out? Do I need
>to set some parameters in the init-file, or somewhere in Windows2000?
>
>Any help will be greatly appreciated,
>
>Martijn Rutte

Apparently you have enabled the win2k file system cache. I do know how to disable it on NT4, but regrettably I don't know how to disable it on win2k. That is the direction you need to search in, some other responses are not to be trusted.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jun 18 2002 - 12:20:07 CDT