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?
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 ==============================================================================