oracle11g 自动备份

1. 编辑oracle自动备份脚本
#!/bin/sh
export ORACLE_BASE=/opt/oracle;
ORACLE_HOME=/opt/oracle/product/11g;
export ORACLE_HOME
ORACLE_SID=lifedb;
export ORACLE_SID
PATH=$PATH:/bin:/usr/bin:/usr/sbin:/root:/opt/bin
PATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin:$ORACLE_HOME/bin
export PATH
rq=`date '+%Y%m%d%H%M'`
expdp system/life schemas=scott dumpfile=scott_$rq.dmp directory=dmp_dir

2. 创建oracle备份目录
mkdir dmp_dir
sqlplus system/系统管理员密码 as sysdba
create directory dmp_dir as '/home/oracle/dmp_dir';
grant read,write on directory dmp_dir to system;

3. 创建crontab定时任务
crontab -e
52 14 * * * /opt/oracle/orabackup.sh