Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple backup question...
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
valid but inefficient. You would better backup *all* datafiles of *1* tablespace in one shot, provided 'ts' in your pseudo code refers to *1* tablespace.
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Wed Mar 26 2003 - 09:33:13 CST