Oracle expdp定时备份脚本

#!/bin/sh# Oracle Environment settings ORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_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).dmpLOG_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 oldcd $backup_dirfind $backup_dir -mtime +2 -name "bak_expdp_*"  -exec rm -f {} \;# That's all