attachment_bkall.sh

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

#Backup attaching document files
FILES=""
is_old_file=0
ATTACHMENT_DIR=/disk6/xdoctran/attachment

#if [ -f $ATTACHMENT_DIR/attach.lst ] ; then 
#LAST_BACKUP_FILES=`cat $ATTACHMENT_DIR/attach.lst` 
#else 
LAST_BACKUP_FILES=""
#fi 

CURRENT_FILES=`ls $ATTACHMENT_DIR/XDT*.dat`

for i in $CURRENT_FILES; do
	for j in $LAST_BACKUP_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 $ATTACHMENT_DIR/tmp
	attachment_ftp $ATTACHMENT_DIR/tmp
	cd $ATTACHMENT_DIR/tmp
	rm *
fi
echo $CURRENT_FILES > $ATTACHMENT_DIR/attach.lst