crosscheck archivelog all;
run{
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/controlfile-%F.bkp';
allocate channel cha1 type disk;
backup database format '/home/oracle/%d_dbfull_%u_%T.bkp' include current controlfile tag full_backup;
sql 'alter system archive log current';
backup archivelog all format '/home/oracle/%d_archlog_%u_%T.bkp' delete all input;
release channel cha1;
}
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
手动调用脚本执行备份:
vi rman_bak.sh:
export ORACLE_SID=orcl
rman target sys/oracle msglog='/home/oracle/rman_bak.log' cmdfile='/home/oracle/rman_bak.sh'(/表示需要连接的目标数据库,msglog表示日志文件,cmdfile表示的是脚本文件);
自动调用脚本执行备份:
crontab -e -u oracle(命令的意思是编辑oracle用户的定时执行(-e,edit -u oracle,oracle用户))
45 23 * * 0 rman target / msglog=bakl0.log cmdfile=/home/oracle/rman_bak.sh(星期天的23:45会以oracle用户的身份来执行命令)
然后启动crontab ,启动crontab的命令:
root> service crond restart
root> chkconfig crond on
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24586480/viewspace-1049471/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24586480/viewspace-1049471/