Thursday, July 28, 2011

RMAN daily backup script




To call RMAN without a catalog
rman nocatalog target system/manager @<day>.txt log 'rman.log'
SUNDAY - Level 0
run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
set maxcorrupt for datafile 1,2,3,4,5,6 to 0;
backup
incremental level 0 cumulative
skip inaccessible
tag sunday_level_0
format '/export/home/oradata/backups/df_t%t_s%s_p%p'
database;
copy current controlfile to '/export/home/oradata/backups/sunday.ctl';
sql 'alter system archive log current';
backup
format '/export/home/oradata/backups/al_t%t_s%s_p%p'
archivelog all
delete input;
release channel d1;
}
MONDAY - Level 2
run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
set maxcorrupt for datafile 1,2,3,4,5,6 to 0;
backup
incremental level 2 cumulative
skip inaccessible
tag monday_level_2
format '/export/home/oradata/backups/df_t%t_s%s_p%p'
database;
copy current controlfile to '/export/home/oradata/backups/monday.ctl';
sql 'alter system archive log current';
backup
format '/export/home/oradata/backups/al_t%t_s%s_p%p'
archivelog all
delete input;
release channel d1;
}
TUESDAY - Level 2
run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
set maxcorrupt for datafile 1,2,3,4,5,6 to 0;
backup
incremental level 2 cumulative
skip inaccessible
tag tueday_level_2
format '/export/home/oradata/backups/df_t%t_s%s_p%p'
database;
copy current controlfile to '/export/home/oradata/backups/tuesday.ctl';
sql 'alter system archive log current';
backup
format '/export/home/oradata/backups/al_t%t_s%s_p%p'
archivelog all
delete input;
release channel d1;
}
WEDNESDAY - Level 2
run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
set maxcorrupt for datafile 1,2,3,4,5,6 to 0;
backup
incremental level 2 cumulative
skip inaccessible
tag wednesday_level_2
format '/export/home/oradata/backups/df_t%t_s%s_p%p'
database;
copy current controlfile to '/export/home/oradata/backups/wednesday.ctl';
sql 'alter system archive log current';
backup
format '/export/home/oradata/backups/al_t%t_s%s_p%p'
archivelog all
delete input;
release channel d1;
}
THURSDAY - Level 1
run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
set maxcorrupt for datafile 1,2,3,4,5,6 to 0;
backup
incremental level 1 cumulative
skip inaccessible
tag thursday_level_1
format '/export/home/oradata/backups/df_t%t_s%s_p%p'
database;
copy current controlfile to '/export/home/oradata/backups/thursday.ctl';
sql 'alter system archive log current';
backup
format '/export/home/oradata/backups/al_t%t_s%s_p%p'
archivelog all
delete input;
release channel d1;
}
FRIDAY - Level 2
run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
set maxcorrupt for datafile 1,2,3,4,5,6 to 0;
backup
incremental level 2 cumulative
skip inaccessible
tag friday_level_2
format '/export/home/oradata/backups/df_t%t_s%s_p%p'
database;
copy current controlfile to '/export/home/oradata/backups/friday.ctl';
sql 'alter system archive log current';
backup
format '/export/home/oradata/backups/al_t%t_s%s_p%p'
archivelog all
delete input;
release channel d1;
}
SATURDAY - Level 2
run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
set maxcorrupt for datafile 1,2,3,4,5,6 to 0;
backup
incremental level 2 cumulative
skip inaccessible
tag saturday_level_2
format '/export/home/oradata/saturday/df_t%t_s%s_p%p'
database;
copy current controlfile to '/export/home/oradata/saturday/saturday.ctl';
sql 'alter system archive log current';
backup
format '/export/home/oradata/saturday/al_t%t_s%s_p%p'
archivelog all
delete input;
release channel d1;
}

No comments:

Post a Comment