Re: Yosemite

Well those conditions are the most common conditions for backups. All sites I have been usually set a high retention period, at least a month (I cant imagine one would set a one day recovery window). I know someone who didnt know this effect, set a 200GB Recovery Area for a 30GB database and set a 30 days recovery windows,after a week the customer was calling because his database was haging, archivelog destination full for Oracle but the customer thoght he still had 100GB Free since he was checking the freespace at OS level.

The thing is if someone wants to use RMAN + Recovery Area then he should use backup recovery area command to send the backups to tapes or simply forget using recovery area (unless there are smarter ways).

On 5/6/06, Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com> wrote:
>
> Your original post did not mention these conditions; you said
>
> >>in order for Oracle to free the flash recovery area you must send your
> RMAN backups to tape using RMAN command, i.e >>backup recovery area
> otherwise your flash recovery area will simply fill up
>
> That is not true, and very misleading to someone who's unfamiliar with
> RMAN and Flash Recovery Area. The time to specify the qualifications for
> such a statement is at the time you make it.
>
> *Paul Baumgartel*
> *CREDIT SUISSE*
> Information Technology
> DBA & Admin - NY, KIGA 1
> 11 Madison Avenue
> New York, NY 10010
> USA
> Phone 212.538.1143
> paul.baumgartel_at_credit-suisse.com
> www.credit-suisse.com
>
> -----Original Message-----
> *From:* LS Cheng [mailto:exriscer_at_gmail.com]
> *Sent:* Friday, May 05, 2006 5:43 PM
> *To:* Baumgartel, Paul
> *Cc:* charlottejanehammond_at_yahoo.com; oracle-l_at_freelists.org
> *Subject:* Re: Yosemite
>
> It is true when it becomes obsolete space will be reused however imagine
> you have a high retention period and you actually free the space everyday by
> sending the backup to tape but at databasde level that is not known, unless
> you set a huge recovery area you will end up with the problem I am saying
>
> For example imagine you have a 200gb database and a recovery windows of 30
> days and you perform backup everyday. Are we gonna set a 6TB recovery area
> space?
>
>
>
>
> On 5/5/06, Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com> wrote:
> >
> > In my experience that is not true. Once a backup becomes obsolete (i.e.,
> > a subsequent backup is taken that covers everything in the original), it is
> > eligible for deletion from the flash recovery area and Oracle will delete it
> > when the space it occupies is needed for something else.
> >
> >
> > *Paul Baumgartel*
> > *CREDIT SUISSE*
> > Information Technology
> > DBA & Admin - NY, KIGA 1
> > 11 Madison Avenue
> > New York, NY 10010
> > USA
> > Phone 212.538.1143
> > paul.baumgartel_at_credit-suisse.com
> > www.credit-suisse.com
> >
> > -----Original Message-----
> > *From:* oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org]*On Behalf Of *LS Cheng
> > *Sent:* Friday, May 05, 2006 3:32 PM
> > *To:* charlottejanehammond_at_yahoo.com
> > *Cc:* oracle-l_at_freelists.org
> > *Subject:* Re: Yosemite
> >
> > Hi
> >
> > RMAN is very a mature product. It was already very good at 9i as you
> > noticed and excellent in 10g.
> >
> > However your strategy might not suit very well in 10g and using a flash
> > recovery area because in order for Oracle to free the flash recovery area
> > you must send your RMAN backups to tape using RMAN command, i.e backup
> > recovery area otherwise your flash recovery area will simply fill up.
> >
> >
> >
> > On 4/26/06, Charlotte Hammond <charlottejanehammond_at_yahoo.com > wrote:
> > >
> > > Hi All,
> > >
> > > My sysadmin's been trying to get my opinion on the
> > > Yosemite backup agent for Oracle:
> > >
> > > http://www.yosemitetech.com/products/standard/applications/oracle.htm
> > >
> > > I can't find much on the site to tell me why I might
> > > want to use this (eg instead of RMAN). I know you can
> > > download a trial but I don't want to go to much effort
> > > for something that I don't even really know what it's
> > > for. Does anyone use this product? If so, what does
> > > it provide?
> > >
> > > We're currently in a 9i/10g environment with RMAN to
> > > disk (later non-RMAN to tape as part of a normal
> > > filesystem backup) as the backup configuration.
> > >
> > > Thanks
> > > Charlotte
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam protection around
> > > http://mail.yahoo.com
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> > ==============================================================================
> > Please access the attached hyperlink for an important electronic communications disclaimer:
> > http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> > ==============================================================================
> >
> >
> ==============================================================================
> Please access the attached hyperlink for an important electronic communications disclaimer:
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> ==============================================================================
>
>

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