OraFAQ Forum: Backup & Recovery » RMAN Backup Strategy

Home » RDBMS Server » Backup & Recovery » RMAN Backup Strategy (Oracle 9i, Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN Backup Strategy [message #331642]

Fri, 04 July 2008 05:42

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

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 10:19:01 CDT 2024