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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
*From:* LS Cheng [mailto:exriscer@xxxxxxxxx]
*Sent:* Friday, May 05, 2006 5:43 PM
*To:* Baumgartel, Paul
*Cc:* charlottejanehammond@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
*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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx
> www.credit-suisse.com
>
> -----Original Message-----
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of *LS Cheng
> *Sent:* Friday, May 05, 2006 3:32 PM
> *To:* charlottejanehammond@xxxxxxxxx
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *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@xxxxxxxxx > 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
> > --
> > //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
==============================================================================
