Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Data- and control files not updated after insert?!!

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

From: Martijn Rutte <opal_at_xs4all.nl>
Date: 18 Jun 2002 06:22:14 -0700
Message-ID: <aa4da990.0206180522.70047a5a@posting.google.com>


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 Received on Tue Jun 18 2002 - 08:22:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US