Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: simple backup question...

Re: simple backup question...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 26 Mar 2003 07:33:13 -0800
Message-ID: <a20d28ee.0303260733.7f415639@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US