dump備份並定時刪除過去檔案

 
[oracle@** ~]$ cat /exp/backup/export.sh
#!/bin/sh
#function:using data pump backup databae
export ORACLE_SID=sgspcdb1
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=.:$ORACLE_HOME/bin:$PATH:.
action_time=`date +%Y_%m_%d`
del_time=`date -d "32 day ago"  +%Y_%m_%d`
echo action time:$action_time
filename=sgspcdb1_$action_time.dump
logname=sgspcdb1_$action_time.log
expdp system/*** content=all full=y  directory=dump dumpfile=$filename logfile=$logname
cd /u09/orabackup/dump
#mv *.gz *.log /u02/hisdp/
tar -czvf sgspcdb1_$action_time.tar.gz $filename $logname
rm $filename
path="/u09/orabackup/dump"
echo "delete  dump data 32 day ago"
rm -rf $path/sgspcdb1_$del_time.tar.gz
rm -rf $path/sgspcdb1_$del_time.log
echo "delete 32 dump data OK!"

在dump備份中增加如下：

del_time=`date -d "32 day ago"  +%Y_%m_%d`
path="/u09/orabackup/dump"
echo "delete  dump data 32 day ago"
rm -rf $path/sgspcdb1_$del_time.tar.gz
rm -rf $path/sgspcdb1_$del_time.log
echo "delete 32 dump data OK!"

[oracle@* dump]$ sh -x /exp/backup/deldump.sh
++ date -d '32 day ago' +%Y_%m_%d
+ del_time=2012_11_22
+ path=/u09/orabackup/dump
+ echo ''

+ echo 'delete  dump data 32 day ago'
delete  dump data 32 day ago
+ rm -rf /u09/orabackup/dump/sgspcdb1_2012_11_22.tar.gz
+ rm -rf /u09/orabackup/dump/sgspcdb1_2012_11_22.log
+ echo 'delete 32 dump data OK!'
delete 32 dump data OK!