Re: simple backup question...

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 26 Mar 2003 06:48:01 -0800
Message-ID: <1b061893.0303260648.24552da0@posting.google.com>

Not only is it valid, it is the recommended way. That way, the redo generated while the tablespaces are in backup mode is much less than if you put all the tablespaces in backup mode, back them all up, and remove them all from backup mode.

Daniel

timasmith_at_hotmail.com (Tim Smith) wrote in message news:<a7234bb1.0303260355.399c1bd9_at_posting.google.com>...
> Is it valid to do this:
>
> alter tablespace ts begin backup;
> ## os backup of datafile1
> alter tablespace ts end backup;
> alter tablespace ts begin backup;
> ## os backup of datafile2
> alter tablespace ts end backup;
>
> etc.
>
> thanks
>
> Tim
Received on Wed Mar 26 2003 - 08:48:01 CST