自动执行任务crontab

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博客 ” ，链接：http://blog.itpub.net/21302630/viewspace-1719301/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21302630/viewspace-1719301/