Re: How to set the WHOLE Database in backup mode

I prefer to set one tablespace in backup mode, back it up, then set it back to normal. Then repeat for each and every tablespace in the database. You don't have to worry about the tablespaces being "in sync". For one, you may not get datafiles that are "in sync", let alone tablespaces. That is why the archived redo logs resolve these inconsistencies on recovery. When you restore, you will have to apply recovery and the archived redo logs will put everything back in sync to a consistent point in time, or a SCN, etc.

HTH,
Brian

Rick Denoire wrote:
>
> Well we know the command "alter tablespace <tralala> begin backup",
> but if there are a dozen of tablespaces, and one has to make a hot
> Snapshot of the DB files, then I wonder if having to use this command
> a dozen of times (for each tablespace separately) will garantee that
> all tablespaces are in sync when the last of them is set in backup
> mode.
>
> So is there any other command to set the DB as a whole in the backup
> mode?
>
> Thanks
> Rick Denoire
Received on Tue Apr 22 2003 - 13:14:32 CDT