Re: Hot Backups Question

No it's not. The second method will work fine and will actually generate LESS redo (and probably be quicker).

Dave Haas

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:xWnf6.375558$U46.11091924_at_news1.sttls1.wa.home.com...
> 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 - 22:35:16 CST