oracle通过导出方式备份

时间：2006-07-18 来源：ghbspecial

#/bin/bash
date=`date +%Y%m%d` export ORACLE_BASE=/opt/ora9
export ORACLE_HOME=/opt/ora9/product/9.2.0.4
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin
export ORACLE_OWNER=oracle
export ORACLE_SID=aaaa
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.4.19
export THREADS_FLAG=native
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data exp system/1234 file=/opt/oraclebak/user_$date.dmp owner=user >/dev/null 2>&1 tar cjf /opt/oraclebak/album_$date.dmp.tar.bz2 /opt/oraclebak/album_$date.dmp > /dev/null 2>&1 && rm -rf /opt/oraclebak/album_$date.
dmp
file=`ls -l /opt/oraclebak/ |grep album_$date.dmp.tar.bz2` if test -z "$file"
       then
            echo "$date backup fail " >> /opt/oraclebak/oraclebak.log

       else
            echo "$date backup oracle successful " >>/opt/oraclebak/oraclebak.log fi

相关阅读更多 +