使用crontab进行备份

折腾了几个小时，脚本如下，可以进行备份。

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=PROD1
export PATH=$ORACLE_HOME/bin:$PATH;
mkdir -p /home/oracle/backup/`hostname`_`date +%Y%m%d`
export back_dir=/home/oracle/backup/`hostname`_`date +%Y%m%d`

rman target / <<EOF_RMAN
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup as compressed backupset incremental level 0 database format '$back_dir/PROD1_incr0_%d_%T_%s%U.bak';
sql 'alter system archive log current';
backup as compressed backupset archivelog all not backed up format '$back_dir/ARCH_%d_%_T_%s%U.bak';
backup current controlfile format '$back_dir/controlbak_%U.bak';
release channel c1;
release channel c2;
}

crontab -l 。中间那个不管用，待研究，计划把log写在rman命令中。

[oracle@edbjr2p1 ~]$ crontab -l
33 17 * * * /home/oracle/backup.sh >> /home/oracle/backup/backup.log
06 17 * * * /home/oracle/back_test.sh >> /home/oracle/backup/Log_`hostname`_`date +%Y%m%d`/back_test.log
15 17 * * * /home/oracle/back_test.sh >> /home/oracle/backup/back_test.log

End