使用EXPDP自动备份数据

1.创建ORACLE Directory对象，如：­

DATA_DUMP_DIR=/home/oracle/databak­

2.创建备份脚本­

#cd /home/oracle/databak­

#touch expdp.sh­

#chmod 775 expdp.sh­

#vi expdp.sh­

3.编辑expdp.sh文件内容如下：­

#/bin/sh­

now=`date +%Y%m%d`­

dmpfile=db$now.dmp­

echo start exp $dmpfile ...­

expdp system/sys@dev DUMPFILE=$dmpfile DIRECTORY=DATA_PUMP_DIR SCHEMAS=kf,cyts­

cp -f $dmpfile /home/zengxb/share­

4.编辑crontab文件如下：­

0 23 * * * sh -c "su - oracle -c /home/oracle/databak/expdp.sh"­

5.重启crond­

#service crond restart­

转载于:https://www.cnblogs.com/xiaobo/archive/2010/12/24/1915467.html