Thursday, August 4, 2011

Difference between Redundancy and Recovery window:


RMAN> configure retention policy to redundancy 2;

Let’s say you make five backups of a specific datafile, one on each day of the workweek,
starting on a Monday. Thus, on Friday, you end up with five different backups of that datafile.

However, the first three days backups of the datafile are deemed obsolete by RMAN, since
you’ve set your backup redundancy value at 2. That is, only the Thursday and Friday backups are considered nonobsolete backups.

Recovery window:

RMAN>configure retention policy of recovery window of 2 days.

Well in case of recovery window setting backup is counted as in number of days instead of count. So even if the backup is obsolete then also oracle will keep this backup as to ensure that database will be fully recovered.

Even if you fire report obsolete then also RMAN will display only those backup copies which can be deleted and will cause no harm.

Example: Click on the below link to find out the perfect example of difference between the above two’s:


Anonymous said...

Dear Sir,
I have gone through your blog and i really appreciate for your work and maintaining the blog... Great work sir....
I request you that please add some 11g new features so that it will helpful for us to gain knowledge from you and your blog....
Thanks in Advance ...

Thanks and Regards...

Vishwanath Sharma said...


Very soon i m going to include those topics:-)

Anonymous said...

Ahaa, its fastidious dialogue about this piece of writing here at this
webpage, I have read all that, so now me also commenting at this place.
Look into my blog - get your ex back

Anonymous said...

Highly energetic blog, I liked that a lot. Will there be a part 2?
my page > How to Get rid of bed Bugs

Anonymous said...

ωhoah thiѕ blоg is fаntastic i love reading your aгticles.
Keеp uρ the good work! Үou realize, many indiѵiԁualѕ arе looking aгound for this info, yοu can aiԁ them gгeatlу.

my web site; culinary school chicago

Anonymous said...

We аbsolutely lovе your blοg and find a lot of your poѕt's to be just what I'm
lοoκing for. Do you offeг guest wrіters to wгite contеnt in your cаse?
I ωouldn't mind producing a post or elaborating on a lot of the subjects you write related to here. Again, awesome weblog!

my blog post:

Anonymous said...

This design iѕ wicked! You obviоusly knοw how to keep a гeader еntertained.
Between youг ωit and youг videoѕ, I ωas аlmost moved to staгt my own blog (well, almost.
..HаHa!) Excеllent job. I гeally lοved what yοu had to
say, and more than thаt, how you presented it.
Too сool!

Review my page ... make money buying and selling cars

Zheng junxai5 said...

michael kors outlet
oakley sunglasses wholesale
kate spade outlet
ray ban sunglasses
nike sb janoski
coach outlet online
michael kors outlet
tory burch shoes
kobe shoes
hollister kids
mont blanc pen
jordan retro 4
coach factory outlet online
michael kors bags
retro 11
oakley sunglasses wholesale
nike air max uk
true religion outlet store
adidas uk
michael kors bags
ray ban sunglasses uk
michael kors outlet clearance
louis vuitton handbags
gucci outlet
adidas wings
coach outlet store online
michael kors outlet online
coach outlet
tory burch boots
louis vuitton outlet
michael kors
michael kors outlet
christian louboutin sale
nike roshe one
lebron 12
longchamp handbags
coach outlet store online

raybanoutlet001 said...

nike huarache
longchamp handbags
ugg boots
true religion outlet
fitflops shoes
hugo boss suits
detroit lions jerseys
redskins jerseys
browns jerseys
bears jerseys

jeje said...

pandora jewelry
nike air max 90
adidas stan smith women
michael kors purses
adidas outlet
adidas yeezy
air jordan shoes
adidas ultra boost 3.0
golden goose sneakers
louboutin shoes

Pansys Silvaz said...

uggs outlet
coach outlet
polo ralph lauren
michael kors outlet
nets jerseys
merrell shoes
nike air max 90
fitflops sale clearance
nba jerseys
tory burch outlet

5689 said...

off-white clothing
nike air max 95 ultra
ugg boots
giuseppe zanotti
nike huarache
football pas cher
basket nike
fitflops sale clearance
coach outlet store online

ww we w said...

nike foamposite
lebron james shoes
mbt shoes outlet
kevin durant shoes
adidas pure boost
coach outlet
longchamp bags
nike air max 2018
hermes handbags for sale