Re: Hot Backups Question

I might have read it incorrectly. I assumed he was backing up more than 1 tablespace and each tablespace was 1 file. Looking at it again if that is not the case (which is odd,but possible) Then you might as well put a tablespace into backup mode and backup all of its files.

If he really meant that he has multiple tablespaces to backup then he should put the individual tablespace into backup mode, backup all the files associated with that tablespace and then take that tablespace out of backupmode. Then repeat with the next tablespace and its associated files etc.

Jim

"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:07:48 CST