Re: online backup

From: Peter Buzanits <peter_at_icb.co.at>
Date: Tue, 18 Aug 1998 13:43:31 +0200
Message-ID: <35D968E3.29984629@icb.co.at>

> It's my belief that during a hot backup, updates to the datafile
> continue as normal - ie, the product of your backup operation is
> inconsistent to a point in time or SCN, because your backup operation is
> reading data that's being changed by dbwr on the fly. The datafile
> itself remains current - to satisfy queries - but your OS copy of it is
> inconsistent.
>

You are right. We tested it now: We created a new tablespace, switched into online-backup mode, copied the datafile, made updates to it and forced a checkpoint. After that, the datafile was different from the previously copied file.

Peter Buzanits
ETM Austria Received on Tue Aug 18 1998 - 06:43:31 CDT