Flush

I am testing Ocopy for the purpose of backing up our Oracle database and   I'm confused by something. When I make some test entries into a table, the Oracle data files appear to be unchanged. I assumed that the data would eventually flush into the data files, after a few hours or so. It's been two days, and still no sign that the data files have been updated. (This is a test system with no other users accessing the tables.) What gives? How long should it take before the new data is written to the actual Oracle data files? Or is it determined by the size of the buffers in the log?

The database is called doris. The only file that has changed, on that drive, during the time I entered the test data, is \oracle\ora81\network\doris.log.

Second question: for a complete backup, do I copy the log files? And do they require "Ocopy"? Am I correct in assuming that the Ocopy utility is only required for the .dbf files-- the other Oracle files including the *.log and *.ctl files-- can they be copied with a standard dos command? Any harm in using Ocopy on them as well?

Thanks. Received on Fri Aug 27 2004 - 08:37:52 CDT