Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Data- and control files not updated after insert?!!
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