Database Backup and Recovery (MOSC)

MOSC Banner

Backup Strategy

edited May 18, 2011 12:54AM in Database Backup and Recovery (MOSC) 19 commentsAnswered
 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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center