Thursday, August 4, 2011

Difference between Redundancy and Recovery window:


Redundancy:

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:

12 comments:

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...

Thanks!

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: howtobuyandsellcarsguide.com

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

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

Unknown said...

qzz0704
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...

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

yanmaneee said...

yeezy boost 350 v2
michael kors factory outlet
adidas yeezy
fitflop
kd 11
jordan shoes
kd shoes
kd 10
lebron 11
supreme clothing

yanmaneee said...

nike sneakers
nike max
retro jordans
balenciaga shoes
kanye west yeezy
supreme new york
timberland boots
nike lebron 16
lebron 17 shoes
kd 11