1、

$sqlplus /nolog
$conn sys /as sysdba
SQL> create directory expdata as '/home/oracle/oraclebak';
Directory created.
SQL> grant read,write on directory expdata to public;  
SQL> exit

2、

$mkdir /home/oracle/oraclebak

3、创建备份角本，给执行权限

  #!/bin/sh  
      
    export ORACLE_BASE=/home/oracle/app/oracle
    export ORACLE_HOME=$ORACLE_BASE/db11g
    export ORACLE_SID=X
    export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin  
      
    export DATA_DIR=/home/oracle/oraclebak  
   
    export DEL_TIME=`date -d "5 days ago" +%Y%m%d`  
    export BAKUP_TIME=`date +%Y%m%d%H%M%S`  
    echo "Starting bakup..."  
    echo "Bakup file path $DATA_DIR/$BAKUPTIME.dmp"  
    expdp system/'密码' directory=expdata dumpfile=$BAKUP_TIME.dmp full=y logfile=$BAKUP_TIME.log
      
    echo "Delete the file bakup before 5 days..."  
    rm -rf $DATA_DIR/$DEL_TIME*.dmp  $DATA_DIR/$DELTIME*.log  
    echo "Delete the file bakup successfully. "

4、

$crontab -e

#!/bin/sh  
00 3 * * * /home/oracle/orale.bak.sh

更多内容：http://www.网站建设

Oracle服务器自动备份？这个是使用数据泵导出数据，测试系统用用就好，生产慎用。

http://xueshu.baidu.com/s?wd=paperuri%3A%286c680811b1706fbb945d9ec20182ef4d%29&filter=sc_long_sign&tn=SE_xueshusource_2kduw22v&sc_vurl=http%3A%2F%2Fwww.doc88.com%2Fp-9932382734223.html&ie=utf-8&sc_us=2450127806702055583

http://xueshu.baidu.com/s?wd=paperuri%3A(6c680811b1706fbb945d9ec20182ef4d)&filter=sc_long_sign&tn=SE_baiduxueshu_c1gjeupa&ie=utf-8&sc_ks_para=q%3D%E5%B0%8F%E5%8C%BA%E7%89%A9%E4%B8%9A%E6%94%B6%E8%B4%B9%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F%E7%9A%84%E8%AE%BE%E8%AE%A1%E4%B8%8E%E5%AE%9E%E7%8E%B0