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

[@more@]

ITPub博客

RMAN全备

最新文章