Oracle expdp定时备份脚本

#!/bin/sh
# Oracle Environment settings 
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;  export ORACLE_HOME 
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdk/bin:$ORACLE_BASE/scripts:$PATH  
#SQL>CREATE DIRECTORY dump_backup_dir as '/home/oracle/backup/bak/logicbak';
#SQL>grant read,write on directory dump_backup_dir to dbmon;  
DMP_FILE=bak_expdp_$(date +%Y%m%d).dmp
LOG_FILE=bak_expdp_$(date +%Y%m%d).log
#  Let's start with an export of the database 
expdp dbmon/dbmon_1Q#@orcl schemas=test directory=dump_backup_dir DUMPFILE=$DMP_FILE logfile=$LOG_FILE compression=all;
#expdp user/pwd@orcl schemas=schema_name DIRECTORY=$dump_backup_dir DUMPFILE=$DMP_FILE logfile=$LOG_FILE compression=all parallel=3;
# delete the backups and logs that are more than 1 days old
cd $backup_dir
find $backup_dir -mtime +2 -name "bak_expdp_*"  -exec rm -f {} \;
# That's all