attach_inc_bk

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

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

if [ -f $ATTACHMENT_DIR/attach.flist ] ; then 
LAST_BACKUP_FILES=`cat $ATTACHMENT_DIR/attach.flist` 
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 [ $i = $j] ; then
			is_old_file=1
			break
		fi
	done
	if [ is_old_file=1 ] ; then
		is_old_file=0
	else
		FILES=$FILES$IFS$i
	fi
done 

#backup or ftp to remote host
#cp FILES <backup directory>
#remotecp ......
echo $FILES
echo $CURRENT_FILES > $ATTACHMENT_DIR/attach.flist