Re: Online backup of tablespaces

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Tue, 10 Nov 1998 22:15:13 -0800
Message-ID: <Pine.OSF.3.95.981110220756.32539C-100000@gonzo.wolfenet.com>

On 8 Nov 1998, Rich Woods wrote:
>
> It is certainly doable. The feasible part will be predicated upon how
> many changes are applied to the tablespaces while in backup mode. You
> generate considerably more (archived) redo in hot backup mode, so pick a
> time to backup these large tablespaces when their rate of change is low.
>
> Ian & Chris wrote:
> >
> > Can anyone tell me if it's feasible to do on-line backups of
> > tablespaces if the tablespace sizes are 34 Gb and 27 GB respectively
> > (I'm using a DEC Alpha running VMS 7.1 and Oracle 7.3.2.......)
> > Would it be a better idea to have multiple sets of tables on multiple
> > tablespaces (say 3 Gb each) ??

You can do some things to increase the speed with which the backup completes. If the tablespace is made up of multiple datafiles, and you have the facilities to do so, you can copy the datafiles in parallel.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Wed Nov 11 1998 - 00:15:13 CST