1. 编辑oracle自动备份脚本#!/bin/shexport ORACLE_BASE=/opt/oracle;ORACLE_HOME=/opt/oracle/product/11g;export ORACLE_HOMEORACLE_SID=lifedb;export ORACLE_SIDPATH=$PATH:/bin:/usr/bin:/usr/sbin:/root:/opt/binPATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin:$ORACLE_HOME/binexport PATHrq=`date '+%Y%m%d%H%M'`expdp system/life schemas=scott dumpfile=scott_$rq.dmp directory=dmp_dir2. 创建oracle备份目录mkdir dmp_dirsqlplus system/系统管理员密码 as sysdbacreate directory dmp_dir as '/home/oracle/dmp_dir';grant read,write on directory dmp_dir to system;3. 创建crontab定时任务crontab -e52 14 * * * /opt/oracle/orabackup.sh