Re: Begin / End Backup Question

And while you're at it ....

What if there are multiple files associated with a given tablespace. Is there anything wrong with:

ALTER TABLESPACE ts1 BEGIN BACKUP;
do the tar/cpio of file1
ALTER TABLESPACE ts1 END BACKUP;
ALTER TABLESPACE ts1 BEGIN BACKUP;
do the tar/cpio of file2
ALTER TABLESPACE ts1 END BACKUP;

My intuition tells me there can be problems hear. Can anyone confirm?

Thanks,
Mike Morgan

Joseph Viau <JoeViau_at_ids.net> wrote in article <33FCB8CC.2787_at_ids.net>...
| I have a question regarding the begin / end backup ALTER TABLESPACE
| option. This is a 24 x 7 shop that has archive log running.
|
| Is it better to alter all tablespaces to BEGIN BACKUP, use tar or cpio
| to backup the data files, and alter all to END BACKUP, or should the
| tablespaces be done one at a time (BEGIN BACKUP, !tar the data file from
| Server Manager using a host command, then END BACKUP, etc. for other
| tablespaces)? Is there any performance detriment in altering all of the
| tablespaces at once?
|
| Thanks for any and all input. Just curious.
| --
| ---------------------------------------
| | JoeViau_at_ids.net | Beware of Data Base |
| | | Administrators with |
| | | screwdrivers. |
| ---------------------------------------
|
Received on Thu Aug 21 1997 - 00:00:00 CDT