定期expdp

定期任务：

[root@hisdb01 dmp]# crontab -l
0 4 * * *  /usr/neu/backup/backup.sh
0 5 * * *  /usr/neu/backup/clearbackup.sh

备份脚本：

cd /usr/neu/backup
C="/opt/oracle/flash_recovery_area/ORCL11G/archivelog"
B="/u01/app/dmp"
A=`date +%Y-%m-%d-%H-%M-%S`
echo $A
if [ -f "$B/$A.dmp" ];then
mv $B/$A.dmp $B/bak-$A.dmp
touch $B/$A.dmp
else
touch $B/$A.dmp
fi
if [ -f "$B/$A.log" ];then
mv $B/$A.log $B/bak-$A.log
touch $B/$A.log
else
touch $B/$A.log
fi
chmod 777 $B/$A.dmp
chmod 777 $B/$A.log

su - oracle -c "expdp 'system/Tjhy#1031@10.88.0.21:1521/hisdb' dumpfile=$A.dmp directory=dumpdir schemas=foundation,ipo,opo,pmr,spd,vas,smc,cockpit,cas,adapter,report,gateway log=$A.log"
#su - oracle -c "expdp 'system/neusoftjc1234@192.168.130.1/cloudonepdb' dumpfile=$A.dmp directory=dumpdir schemas=foundation,ipo,opo,pmr,spd,vas,smc,cockpit,si,adapter,report,medpack log=$A.log"
#su - oracle -c "expdp 'system/neusoftjc1234@192.168.130.1/cloudonepdb' dumpfile=$A.dmp directory=dumpdir schemas=report log=$A.log"

清理脚本：

/usr/neu/backup/clearbackup.sh
find /u01/app/dmp -mtime +3 -type f -name "*.dmp*" -exec rm -rf {} \;
find /u01/app/dmp -mtime +3 -type f -name "*.log*" -exec rm -rf {} \;