ITPub博客

首页 > 数据库 > Oracle > 自动执行任务crontab

自动执行任务crontab

原创 Oracle 作者:peng163fj 时间:2015-07-01 17:21:25 0 删除 编辑




chmod -R 775 /u01/dbackup/
[oracle]$ crontab -l
0 0 * * * /u01/dbackup/rman.sh >/u01/dbackup/crontab.log 2>&1 &




[oracle]$ more /u01/dbackup/rman.sh
#!/bin/ksh
ORACLE_SID=crm                                                                    
ORACLE_HOME=/u01/app/oracle/11.2.0.0/db_home                                       




export  ORACLE_SID   ORACLE_HOME
RMAN=$ORACLE_HOME/bin/rman
LOG=/u01/dbackup/rman.log                                                     
D=`date +%Y%m%d`




$RMAN  target /    cmdfile=/u01/dbackup/rman.src LOG=$LOG append 
cat /u01/dbackup/rman.log
#cd /u01/dbackup
#zip backup_${D}.zip /u01/dbackup/*_crmdbk_${D}*.back
[oracle]$ 
[oracle]$ 
[oracle]$ more /u01/dbackup/rman.src
run{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup  spfile format '/u01/dbackup/%d_%T_%s_%p_%u_SPFILE';
backup  AS COMPRESSED  BACKUPSET   database format '/u01/dbackup/%d_%T_%s_%p_%u_FULL';                     
sql 'alter system archive log current';
backup  AS COMPRESSED BACKUPSET   archivelog all format '/u01/dbackup/%d_%T_%s_%p_%u_ARCHIVE' delete all input;
backup current controlfile format '/u01/dbackup/%d_%T_%s_%p_%u_CONTROLFILE';              
release channel d1;
release channel d2;
}
configure controlfile autobackup on;
crosscheck backup;
crosscheck archivelog all;
delete expired backup;
delete expired archivelog all;
CONFIGURE BACKUP OPTIMIZATION ON;
[oracle]$ 

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/21302630/viewspace-1719301/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 自动备份任务
请登录后发表评论 登录
全部评论

注册时间:2013-11-20

  • 博文量
    155
  • 访问量
    440179