Re: Begin / End Backup Question

Joseph Viau wrote:
>
> 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. |
> ---------------------------------------

By all means, use your second alternative. Whenever a tablespace is in backup mode, Oracle logs full blocks for any insert, update, delete to that tablespace. If all tablespaces are in backup mode at the same time, you are maximizing the increased logging activity. When only one tablespace is in backup mode at a time, you minimize the increased logging activity.

Second point: use SQL to create your backup script each time -- it will catch any added or dropped tablespaces and/or data files.

-- 
John P. Higgins      Voice:    (309)765-7868
Deere & Company      Fax:      (309)765-7800
John Deere Road      Internet: jh33378nospam_at_deere.com
Moline, IL 61265     Opinions: My Own