Re: Putting tablespaces in Hot Backup

From: spencer <spencerp_at_swbell.net>
Date: Tue, 26 Sep 2000 21:54:04 -0500
Message-ID: <iidA5.1900$lf2.103132@nnrp2.sbc.net>

interesting question. AFAIK, the statement will NOT return until the tablespace is in backup mode, that is, it does NOT return before all of the datafiles in the tablespace are ready to be backed up. if there is a possibility that the statement returns BEFORE the operation is completed (that is, before the tablespace is ready for backup) then my databases may be smelling like burnt toast if we need to recover.

on a related point, what about the "... archive log all" statement ? is there any chance that this statement will return BEFORE the log files are archived ?

"David F. Newman" <dnewman_at_damocles.maraudingpirates.org> wrote in message news:m3og1crx6a.fsf_at_damocles.maraudingpirates.org...
> Can someone tell me if
>
> ALTER TABLESPACE ... BEGIN BACKUP;
>
> blocks until the tablespace is in backup
> mode? Or do I need to continually check
> the status of the tablespace before proceding?
>
> --
> David F. Newman
> dnewman_at_maraudingpirates.org
>
Received on Tue Sep 26 2000 - 21:54:04 CDT