Re: Backup using only one CPU - SA wants to know why
Date: Tue, 13 Nov 2012 13:46:28 -0700
Message-ID: <CAJzM94CYz8h_LBtWp5=LkKFSJy9SCZf0SO-H14uSPOSGfdvOJg_at_mail.gmail.com>
Moot point for me. We run EE, not SE to disk. If my backups were performing poorly, I would be more concerned. As it is, they perform well, run in the middle of the night when few people are accessing the OLTP, and finish well before the bulk of our customers are logging in. Is it really that important to try to force use of additional CPUs given the above just as a feel good for the SA? For my situation I would have to say no. Definitely working much better than when I had to run backups when we were using SE1. Now THAT'S a serious pain when backing up!
Sandy
On Tue, Nov 13, 2012 at 11:07 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
> Oracle's RMAN product does not support parallel backup with SE.
>
> That is slightly different from "at all." But we were discussing RMAN, so I
> guess I'm pickin' nits.
>
> I don't know whether there is a problem space where it would be worthwhile
> to roll your own backup in order to get CPU parallelism and give up RMAN
> functionality to keep an SE license. I also have not explored the issue of
> whether this makes overall economic sense. It might in some cases, I
> suppose, perhaps if you have very many sites so you want to minimize
> license
> cost, but the sites are similar so you could create the backup solution
> once
> and deploy it many times, AND you have the case where CPU parallelism is
> required to reach an optimal point on the elapsed time of backup and
> compression factor matrix.
>
> Rats. Now I realize I'm not sure which types of compression are available
> for SE. There seems to always be more to research than time available for
> research.
>
> mwf
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Jared Still
> Sent: Tuesday, November 13, 2012 11:34 AM
> To: Martin Klier
> Cc: sbecker6925_at_gmail.com; oracle-l
> Subject: Re: Backup using only one CPU - SA wants to know why
>
> On Mon, Nov 12, 2012 at 2:42 PM, Martin Klier <usn_at_usn-it.de> wrote:
> > Hi,
> >
> > Jared Still schrieb:
> > > On Mon, Nov 12, 2012 at 12:52 PM, Martin Klier <usn_at_usn-it.de
> > > <mailto:usn_at_usn-it.de>> wrote:
> > >
> > > Often SBT media disallows that and breaks the parallelism.
> > > Silly, but necessary: Do you have Enterprise Edition?
> > >
> > >
> > > Why necessary?
> > Beacuse SE does not support parallel backup at all.
> >
> >
> Ah, I had forgot about that.
>
> Jared
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Sandy Transzap, Inc. -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 13 2012 - 21:46:28 CET