#脚本
set oracle_sid=orcl
rman target / nocatalog
run{
allocate channel c1 type disk ;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
backup full format 'db_%d_%T_%p_%s_%U.bak' database plus archivelog delete input;
backup format 'db_backup\control_%d_%T_%U.bak' current controlfile;
release channel c1;
}
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
把此脚本存为后缀.bat的格式,然后推拽到计划任务,选定点击属性,设置计划任务的时间等。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22821701/viewspace-696233/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22821701/viewspace-696233/