数据泵备份还原脚本

数据泵备份还原脚本

oracle_backup.sh

#!/bin/bash
. ~/.bash_profile
CURDAY=`date +%Y%m%d`
/u01/app/oracle/product/11.2/bin/expdp system/password schemas=xxxx directory=dump_dir dumpfile=xxxx_$CURDAY.dmp logfile=xxxx_$CURDAY.expdp.log
cd /u01/backup_dump
/bin/gzip -f /u01/backup_dump/xxxx_$CURDAY.dmp

oracle_restore.sh

#!/bin/bash
. ~/.bash_profile
CURDAY=`date +%Y%m%d`
sqlplus / as sysdba <
drop user hbcms cascade;
quit
EOF
/bin/gunzip /u01/backup_dump/xxxx_$CURDAY.dmp.gz
/u01/app/oracle/product/11.2/bin/impdp system/password directory=dump_dir dumpfile=xxxx_$CURDAY.dmp logfile=xxxx_$CURDAY.impdp.log