archivedlog_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

sqlplus /nolog <<EOF
conn / as sysdba
alter system switch logfile;
archive log stop;
exit
EOF

#Backup Archived log
FILES=""
is_old_file=0
ARCHIVEDLOG_DIR=/disk3/ora_arch_log/xdoctran
echo $ARCHIVEDLOG_DIR
CURRENT_FILES=`ls $ARCHIVEDLOG_DIR/xdoc*.arc`

sqlplus /nolog <<EOF
conn / as sysdba
archive log start;
exit
EOF

find $ARCHIVEDLOG_DIR -name 'xdoc*.arc' -atime +100 -exec rm {} \;

if [ -f $ARCHIVEDLOG_DIR/arch.lst ] ; then 
LAST_ARCHIVEDLOG_FILES=`cat $ARCHIVEDLOG_DIR/arch.lst` 
else 
LAST_ARCHIVEDLOG_FILES=""
fi 


for i in $CURRENT_FILES; do
	for j in $LAST_ARCHIVEDLOG_FILES ; do
		if test "$i" = "$j" ; then
			is_old_file=1
			break
		fi
	done
	if test $is_old_file -eq 1 ; then
		is_old_file=0
	else
		FILES=$FILES$IFS$i
	fi
done 

#backup or ftp to remote host
if test "$FILES" != "" ; then
	cp $FILES $ARCHIVEDLOG_DIR/tmp
	archivedlog_ftp $ARCHIVEDLOG_DIR/tmp
	cd $ARCHIVEDLOG_DIR/tmp
	rm *
fi
echo $CURRENT_FILES > $ARCHIVEDLOG_DIR/arch.lst