RE: Yosemite
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'LS Cheng'" <exriscer@xxxxxxxxx>
- Date: Fri, 5 May 2006 23:15:55 +0100
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
<mailto: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 <mailto:paul.baumgartel@xxxxxxxxxxxxxxxxx>
www.credit-suisse.com <http://www.credit-suisse.com/>
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto: 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 <mailto:charlottejanehammond@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx <mailto: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
<mailto: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
<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://mail.yahoo.com/>
--
//www.freelists.org/webpage/oracle-l
<//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
<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
==============================================================================
Other related posts:
