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

You're problem is quite simple in fact : it seems that on your Windows server, data are not written on disks immediately. They remain in memory. And it's normal that data files are updated when you stop your database because at that time, Oracle flushes the memory to the disks.

If you want that all data would be written on disk before you backup data files, just do a checkpoint before your backup. I don't know how you launch your backup, but if it is by a script (launched by the cron for instance), just put in this script the SQL command to perform a checkpoint. This command is the following :

alter system checkpoint

Good luck

"Martijn Rutte" <opal_at_xs4all.nl> a écrit dans le message news: aa4da990.0206180522.70047a5a_at_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 - 09:10:20 CDT