Re: Backup Optimisation and Alexander Fatkulin

Hrishy,

the article was related to skipping already backed up archivelogs, hence my comment about backup optimization.

Backup optimization often provides the desired effect for most environment but turning it on for the needs of skipping archivelog backups only will require evaluating other things. Say you have a read only tablespaces and you back these up once every 3 months (for offsite shipment, to have reduntant copies, to protect yourself from media aging, etc.) -- turning backup otpimization on will affect how backup for read only tableaspaces are done. Same might apply to your FRA backups to tape.

That's why you usually don't want to trun optimzation on for the sake of skipping up archivelog backups without taking a look at other affected areas first.

hth

On Tue, Jun 10, 2008 at 6:07 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:

> Hi Alex
>
> Thanks for the link.
> You mentioned something like "it can (and will) affect other things "
>
> I am not a native english speaker and that sentence of your's should it
> trigger of alarm bells to anyone who is planning to turn on backup
> optimization on in thier environments ?
>
> on the pythian thread you seem to prefer doing
> ("more precise thing is to specify "not backed up 1 times".") modifying the
> backupscript rather then setting the backup optimization parameter on.
>
> I am not seeing any negative ramifications of turning on the backup
> optimization on the case outlined by the OP on the pythian thread
>
> regards
> Hrishy
>
>
>
>
>
> --- On Mon, 9/6/08, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
>
> > From: Alexander Fatkulin <afatkulin_at_gmail.com>
> > Subject: Re: Backup Optimisation and Alexander Fatkulin
> > To: hrishys_at_yahoo.co.uk
> > Cc: oracle-l_at_freelists.org
> > Date: Monday, 9 June, 2008, 5:14 PM
> > please refer to
> >
> >
> http://download.oracle.com/docs/cd/B28359_01/backup.111/b28273/rcmsynta010.htm#g1028761
> >
> > for the list what else backup optimization includes and how
> > it determines
> > what can be skipped
> >
> > On Mon, Jun 9, 2008 at 4:30 AM, hrishy
> > <hrishys_at_yahoo.co.uk> wrote:
> >
> > > Hi
> > >
> > > I was reading up the pythian blogs and came across
> > this comment by Alex
> > > Fatkulin.(I am sure alex is frequenting this list)
> > >
> > > Can somebody have a look at this thread and explain
> > what alex means by
> > >
> > > Quote Backup optimization is "all or
> > nothing" - it can (and will) affect
> > > other things Unqote
> > >
> > > I am curious to know what effect does it have if i
> > enable it in my
> > > environment and what positive and negative
> > implications could there possibly
> > > be.
> > >
> > >
> > http://www.pythian.com/blogs/478/plus-archivelog-and-rman-optimization
> > >
> > > I have a host of 9i and 10g databases
> > >
> > > regards
> > > Hrishy
> > >
> > > regards
> > > Hrishy
> > >
> > >
> > >
> > >
> > >
> > __________________________________________________________
> > > Sent from Yahoo! Mail.
> > > A Smarter Email
> > http://uk.docs.yahoo.com/nowyoucan.html
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
> >
> > --
> > Alex Fatkulin,
> > The Pythian Group,
> > http://www.pythian.com/blogs/author/alexf
>
>
> __________________________________________________________
> Sent from Yahoo! Mail.
> A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
>

-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf

--
http://www.freelists.org/webpage/oracle-l