Re: How to set the WHOLE Database in backup mode

Alex Filonov wrote:
> drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0304221633.67ee444e_at_posting.google.com>...
>

>
> They are not. Any hot backup set is consistent if you:
> 1. Have current controlfiles or backup controlfile from the time later
> than last hot backup was taken.
> 2. Have all archived logs from the time before first file in the set
> was backed up.

That does not make it consistent. SCN's in the first file you backup are bound to be different than the ones in other datafiles, than the ones in your controlfiles.
That's inconsistency.
>
> You can easily have consistent backup set even if you do hot backup of
> one tablespace a day.
>

Same as above - inconsistent. Requires recovery.
> BTW, it's all described in documentation.
>

Sure thing.

-- 
Regards, Frank van Bortel