offline_bk.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
src_dir=/disk6/oradata/xdoctran
backup_dir1=/disk4/ora_data_bak/offline_backup
backup_dir=$backup_dir1/xdoc_off_bk$rq
mkdir $backup_dir

#remove old dump file
find $backup_dir1 -name 'xdoc_off_bk*' -atime +100 -exec rm -r {} \;

sqlplus /nolog <<EOF
conn / as sysdba
shutdown immediate
!cp $src_dir/* $backup_dir
startup pfile=/disk2/oracle/dbs/initorcl9.ora
EOF

cp /disk2/oracle/dbs/orapw* $backup_dir
cp /disk2/oracle/dbs/initorcl9.ora  $backup_dir

#ftp the  backup files to remote site
remote_copy_dir offline_backup xdoc_off_bk$rq $backup_dir