[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!"
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 ''
++ 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!
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!
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15187685/viewspace-751713/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
記錄登錄用戶信息
下一篇：
statspack 安裝以及相關參數說明
请登录后发表评论
登录
全部评论
