Home » RDBMS Server » Backup & Recovery » RMAN Backup Strategy (Oracle 9i, Solaris)
icon4.gif  RMAN Backup Strategy [message #331642] Fri, 04 July 2008 05:42 Go to next message
tushar_kathe
Messages: 1
Registered: July 2008
Location: NZ
Junior Member
Hi,

I have 100GB of DB on Oracle 9i on Solaris.
I am using following plan 1 method for RMAN Backup

Plan - 1
--------
Sunday-Level 0
Monday to Saturday - Differential Incremental Level 1

Plan - 2
--------
Once a month - Level 0
Cummulative - Every Sunday
Differential Incremental - Monday to Saturday

Which plan is better and why? Also which level (1 or 2) should I use for cummulative and incremental plan 2?

Regards,
Tushar

Report message to a moderator

Re: RMAN Backup Strategy [message #331653 is a reply to message #331642] Fri, 04 July 2008 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
None is better. It only depends on your needs.
Don't use level greater than 1, they are no more available in 10g and up.

Regards
Michel

Report message to a moderator

Re: RMAN Backup Strategy [message #331676 is a reply to message #331642] Fri, 04 July 2008 09:03 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member
what about carrying out a full backup on the sunday and the archive log backups for the rest of the week.

regards

Alan

[Updated on: Thu, 17 July 2008 11:15] by Moderator

Report message to a moderator

Re: RMAN Backup Strategy [message #331679 is a reply to message #331676] Fri, 04 July 2008 09:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why not and why not any other option Oracle allows?
It all depends on the requirements for backup and recovery.

Regards
Michel

Report message to a moderator

Re: RMAN Backup Strategy [message #336087 is a reply to message #331642] Thu, 24 July 2008 14:01 Go to previous message
bobs3301
Messages: 2
Registered: July 2008
Location: India
Junior Member
Backups should be designed in such a way that it takes less time to backup and is quickly recoverable .

1) Go for weekly level 0 backup and daily cumulative incremental backups if recovery time is more important in your case .

2) If you want to keep your backup time to minimum , go for level 0 on Sunday and differential level 1 backups from Mon to Sat .

Its for you to decide Option 1 or option 2 .

regards,

bobs3301

Report message to a moderator

Previous Topic: Upgrade Disaster Recovery Database to 9.2.0.8
Next Topic: Applying incremental level 1 backup to backup set
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 13:43:24 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.