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: Online backup of tablespaces

Re: Online backup of tablespaces

From: Rich Woods <rawoods_at_concentric.net>
Date: 08 Nov 1998 18:22:08 PST
Message-ID: <36465351.B3FB4D66@concentric.net>


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:

> Hi,
> 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) ??
>
> Thanks in advance
>
> Ian (a newbie DBA)
>
> --
> to return e-mail remove NOSPAM from address......
Received on Sun Nov 08 1998 - 20:22:08 CST

Original text of this message

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