Re: Hot Backups Question

I seem to have been stranded in another thread on this one!

I agree with you, Dave, on the "quicker" business.

The only draw back is the entire set of datafiles has to be copied in one hit, otherwise you are facing vast quantities of redo being generated. The first method (one-at-a-time) gives you the flexibility of backing up different parts of the tablespace on different occasions (a file per night, say).

But ultimately, it makes zero difference which method he uses as far as the ability to recover is concerned.

Regards
HJR "Dave Haas" <davehaas_at_--nospam--hotmail.com> wrote in message news:84qf6.94651$OD6.9422835_at_news1.telusplanet.net...
> 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 Mon Feb 05 2001 - 01:48:03 CST