Home » RDBMS Server » Backup & Recovery » RMAN redundancy (9i,Windows 2003)
RMAN redundancy [message #330406] Mon, 30 June 2008 02:05 Go to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi all,
My backup procedure is differential level 0 once a week and differential level 1 on the other days as follows,

                     Fri  Sat   Sun   Mon   Tue   Wed  Thur  Fri
Incremental Level      0    -     -    -     -     -     -    0
Incremental Level      -    1     1    1     1     1     1    -

If the retention policy is set to redundancy 2 and on sunday when the incremental level 1 backup starts,will the incremental level 0 and level 1 backups taken on friday and saturday be deleted? Please clarify my doubt.

Thanks,
Arun.

[Edit MC: Format week]

[Updated on: Mon, 30 June 2008 02:18] by Moderator

Report message to a moderator

Re: RMAN redundancy [message #330414 is a reply to message #330406] Mon, 30 June 2008 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No.
They will be deleted 2 weeks later as incrementals don't contain the whole files.

Regards
Michel
Re: RMAN redundancy [message #330714 is a reply to message #330414] Tue, 01 July 2008 00:26 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi Michel,
Thanks for the reply..Once i tested the backup procedure using a test server and found that after i took the level 0 and level 1 backups and issued the RMAN command ,
'Delete Noprompt Obsolete;'
There were some backup pieces(obsolete) getting deleted. I doubted that this happened as i kept the redundancy level to 2. So, what might be the reason Michel??

Thanks,
Arun.
Re: RMAN redundancy [message #330718 is a reply to message #330714] Tue, 01 July 2008 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
From doc:
Quote:
If you specify the OBSOLETE option, then DELETE removes files considered OBSOLETE, that is, "not needed," by the retention policy or because it is orphaned.

Regards
Michel
Re: RMAN redundancy [message #330719 is a reply to message #330718] Tue, 01 July 2008 00:54 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
<<If you specify the OBSOLETE option, then DELETE removes files considered OBSOLETE, that is, "not needed," by the retention policy or because it is orphaned. >>

Michel, I dont understand what you mean here by the term "...because it is orphaned..." , what does it mean?


Thanks and Regards,
Arun.
Re: RMAN redundancy [message #330727 is a reply to message #330719] Tue, 01 July 2008 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You should read the documentation.

Orphan means it is unusable because something is missing to use it.
For instance, an incremental level 1 is unusable if there is no previous available level 0.

Regards
Michel
Re: RMAN redundancy [message #330733 is a reply to message #330727] Tue, 01 July 2008 01:11 Go to previous message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Ok Many thanks Michel...
Previous Topic: RMAN WITH SHARED MAP
Next Topic: Disaster Recovery Site
Goto Forum:
  


Current Time: Fri Nov 29 08:20:08 CST 2024