exp_cum.sh

利用DOS批处理文件实现oracle自动备份

# Setup ORACLE environment

ORACLE_HOME=/disk2/oracle; export ORACLE_HOME
ORACLE_SID=orcl9; export ORACLE_SID
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
LD_LIBRARY_PATH=/disk2/oracle/lib:/lib:/usr/lib:/usr/openwin/lib:/usr/dt/lib:/usr/ucblib:/usr/local/lib; export LD_LIBRARY_PATH
PATH=/bin:/usr/bin:/usr/sbin:/opt/bin:/usr/ccs/bin:/opt/local/GNU/bin
PATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin:$ORACLE_HOME/bin
PATH=$PATH:/export/home/oracle/bin:/usr/local/samba/bin:/usr/ucb:.
export PATH

#get current date
rq=`date +'%y%m%d'`

#set backup directory
backup_dir=/disk4/ora_data_bak/exp_cum_dmp

#remove old dump file
find $backup_dir -name 'xdoc_cum*' -atime +10 -exec rm {} \;

#exp the database
exp system/HZgov2809285 full=y inctype=cumulative statistics=none file=$backup_dir/xdoc_cum$rq.dmp >> $backup_dir/xdoc_cum$rq.log 2>&1

#ftp the dmp file to remote site
remote_copy /xdoctrans/ora_data_bak/exp_cum_dmp $backup_dir  xdoc_cum$rq.dmp
remote_copy /xdoctrans/ora_data_bak/exp_cum_dmp $backup_dir  xdoc_cum$rq.log