The first is the preferred method.
--
Our new email address is kennedy-family_at_home.com
.
<humorous_at_my-deja.com> wrote in message news:95l06u$oij$1_at_nnrp1.deja.com...
>
>
> Hey gurus
> I have a question. I have a tablespace with 6 tablespaces. They are
> being backed up inthe
> following way .
> alter tablespace tablespace name begin backup;
> cp filenum1 to filenum1.back
> alter tablespace tablespace name end backup;
>
> alter tablespace tablespace name begin backup;
> cp filenum1 to filenum2.back
> alter tablespace tablespace name end backup;
>
> alter tablespace tablespace name begin backup;
> cp filenum1 to filenum3.back
> alter tablespace tablespace name end backup;
>
>
> alter tablespace tablespace name begin backup;
> cp filenum1 to filenum4.back
> alter tablespace tablespace name end backup;
>
> alter tablespace tablespace name begin backup;
> cp filenum1 to filenum5a.back
> alter tablespace tablespace name end backup;
>
> Can this be a problem in the backups being consistent ?
> Do y'all see any problem with this ?
>
>
> Or should I go for the
>
> alter tablespace tablespacename begin backup;
> cp filenum1 to filenum1.bak
> cp filenum2 to filenum2.bak
> cp filenum3 to filenum3.bak
> cp filenum4 to filenum4.bak
> cp filenum5 to filenum5.bak
>
> alter tablespace tablespacename end backup;
>
>
> Is this a more preferred option ? If so why ?
>
> Thanks a lot for the responses.
> Any thoughts, outbursts, raves, rants, ideas will be appreciated.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sun Feb 04 2001 - 20:08:29 CST
