| tush |
Posted: Jul 03, 2008 08:22:44 AM |
Total Post: 5
Joined: May, 2008
|
Hi,
I have 100GB of DB on Oracle 9i.
I am using following 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 should I use for cummulative and incremental plan 2?
Regards,
Tushar
|
|
|
 MOH_DBA |
| Posted: Jul 03, 2008 02:53:38 PM |  |
|
Total Post: 155
Joined: Nov, 2007
|
i prefer plan 1, why? less time recovery, less losses could happened.
and i usually keep the level 0 and it's incremental backups for 2 weeks before delete it.
|
|
|
|
|
| GOPU |
| Posted: Jul 04, 2008 01:08:05 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
every sunday you can go for a full backup and the other days you can take the incremental backup includng the archive files.
|
|
|
|
|
| tush |
| Posted: Jul 07, 2008 06:59:02 AM | |
|
Total Post: 5
Joined: May, 2008
|
Hi,
We are doing presently full backup along with controlfile and archive log on Sunday. From Mon to Sat we take incremental level 1 backup along with control file and archive log files. Is this ok.
Is their any way to reduce disk space and have a RMAN backup?
|
|
|
|
|
| MOH_DBA |
| Posted: Jul 08, 2008 12:07:29 PM | |
|
Total Post: 155
Joined: Nov, 2007
|
which type on incremental you are using?
deferential or cumulative?
|
|
|
|
|
| tush |
| Posted: Jul 10, 2008 02:11:30 AM | |
|
Total Post: 5
Joined: May, 2008
|
Hi,
Its differential incremental.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
