oracle逻辑备份脚本

来源:互联网 发布:2015网络人物 编辑:程序博客网 时间:2024/05/19 00:08

cat   expdp.sh

find /data/expdp_data/ -name "*.dmp" -mtime +0 -exec rm -rf {} \;

today=`date +20%y%m%d%H%M`

expdp boswll/"Wll_S[131209]_andTTpassw0rd"  directory=DUMP_DIR schemas=NEW dumpfile=NEw_bak_A_%U_$today.dmp logfile=NEWMONGO_A_$today.log 


aix_power_db:/data/expdp_data$cat start_exp.sh
su - oracle -c  "/data/expdp_data/expdp.sh"


root

crontab  -e

#45 23 * * * ulimit 5000; /usr/lib/smdemon.cleanu > /dev/null
#0 11 * * * /usr/bin/errclear -d S,O 30
#0 12 * * * /usr/bin/errclear -d H 90
#0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/sbin/dumpctrl -k >/dev/null 2>/dev/null
#0 15 * * *  /usr/lib/ras/dumpcheck >/dev/null 2>&1
#55 23 * * * /var/perf/pm/bin/pmcfg >/dev/null 2>&1      #Enable PM Data Collection
0 6 * * * /data/expdp_data/start_exp.sh
~

0 0
原创粉丝点击