Backup Strategy
Dear All,
I have recently move to RMAN and implement it with the help of the following scripts and its working fine but i want your expert views on it, Please give me your usefull suggestions. to make this backup strategy more productive.
On Every Sunday
run{
backup incremental level 0
format 'H:\RMANBackup\bak_%s_%t_level0.bak'
database include current controlfile;
}
On every Wednesday, Saturday
run{
backup incremental level 1
format 'H:\RMANBackup\bak_%s_%t_level1.bak'
database include current controlfile;
}
On Monday, Tuesday, Thursday, Friday
run{
backup incremental level 2
format 'H:\RMANBackup\bak_%s_%t_level2.bak'
database include current controlfile;
I have recently move to RMAN and implement it with the help of the following scripts and its working fine but i want your expert views on it, Please give me your usefull suggestions. to make this backup strategy more productive.
On Every Sunday
run{
backup incremental level 0
format 'H:\RMANBackup\bak_%s_%t_level0.bak'
database include current controlfile;
}
On every Wednesday, Saturday
run{
backup incremental level 1
format 'H:\RMANBackup\bak_%s_%t_level1.bak'
database include current controlfile;
}
On Monday, Tuesday, Thursday, Friday
run{
backup incremental level 2
format 'H:\RMANBackup\bak_%s_%t_level2.bak'
database include current controlfile;
0