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