#!/bin/sh
i_host=`hostname`
i_log=/cvbak/scripts/cv_db2arch_${i_host}.log
echo " " >> $i_log
if [ $# -lt 3 ]
then
now_time=`date +"%Y%m%d %H:%M:%S"`
echo "-->0 $now_time" >> $i_log
echo "Usage: $0 /db2archlog /db2archlog/cv_db2arch flag=1,2" >> $i_log
exit 1
fi
i_db2arch=$1
i_cv_arch=$2
i_flag=$3
if [ "$i_flag" = "1" -o "$i_flag" = "2" ]
then
echo "-->1 flag=$i_flag" >> /dev/null
else
now_time=`date +"%Y%m%d %H:%M:%S"`
echo "-->2 $now_time" >> $i_log
echo "-->2 flag=$i_flag" >> $i_log
exit 2
fi
if [ -d $i_db2arch -a -d $i_cv_arch ]
then
echo " " > /dev/null
else
now_time=`date +"%Y%m%d %H:%M:%S"`
echo "-->flag=$i_flag" >> $i_log
echo "-->$now_time" >> $i_log
echo "-->$i_db2arch not exist OR $i_cv_arch not exist !!" >> $i_log
exit 3
fi
if [ $i_flag -eq 1 ]
then
now_time=`date +"%Y%m%d %H:%M:%S"`
echo "-->flag=$i_flag,mv archive log to $i_cv_arch for cv soft backup to tape!" >> $i_log
echo "-->$now_time" >> $i_log
echo "-->db2arch=$i_db2arch" >> $i_log
echo "-->cv_db2arch=$i_cv_arch" >> $i_log
find $i_db2arch -name "S*.LOG" -type f -mmin +5 |sort >> $i_log
echo " " >> $i_log
find $i_db2arch -name "S*.LOG" -type f -mmin +5 | xargs -i /bin/mv {} $i_cv_arch
elif [ $i_flag -eq 2 ]
then
now_time=`date +"%Y%m%d %H:%M:%S"`
echo "-->flag=$i_flag,after backup to tape,rm archive log!" >> $i_log
echo "-->$now_time" >> $i_log
echo "-->db2arch=$i_db2arch" >> $i_log
echo "-->cv_db2arch=$i_cv_arch" >> $i_log
rm $i_cv_arch/*
fi
exit 0

ITPub博客

DB2归档备份实现方式cv_db2arch.sh