Monday 11 April 2011

ASE : Apply multiple transaction dumps

This script accepts a directory and dbname as parameters, and applies
the dumps in the directory, in filename order

#!/usr/bin/ksh
#-------------------------------------------------------
# Log File Applier
# Parms: database name, dump directory containing logs
#-------------------------------------------------------
if test $# -lt 2 ; then
echo " "
echo "usage: "
echo "syb_applylogs dbname sourcedir"
echo " "
exit
fi

if test -d $2 ; then
mstatus="OK"
else
echo " "
echo " Invalid path: "
echo $2
echo " "

exit
fi

for fname in $2/log*.dmp ; do
echo $fname
if test -f $fname ; then
/usr2/dumps/scripts/syb_applylog $1 $fname
fi
done

No comments:

Post a Comment