Bill Van Dyk wrote:
> 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.
>
Ocopy is not a backup. Go to http://tahiti.oracle.com and look up RMAN.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Aug 28 2004 - 11:16:58 CDT
