 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
|
|
|
| Re: RMAN Backup Strategy [message #331653 is a reply to message #331642 ] |
Fri, 04 July 2008 06:17  |
Michel Cadot
Messages: 18894
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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
|
|
|
| Re: RMAN Backup Strategy [message #331676 is a reply to message #331642 ] |
Fri, 04 July 2008 09:03 |
alanm
Messages: 266
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
|
|
|
| Re: RMAN Backup Strategy [message #331679 is a reply to message #331676 ] |
Fri, 04 July 2008 09:09 |
Michel Cadot
Messages: 18894
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Why not and why not any other option Oracle allows?
It all depends on the requirements for backup and recovery.
Regards
Michel
|
|
|
| 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
|
|
|
]
Members
Search
Help
Register
Login
Home
