db_archive.sh.txt

管理online的shell程序

###############################################################################
#
#       Module:         db_archive.sh
#       Author:         Peter R. Schmidt
#       Description:    Perform an Informix Level 0 Archive in background
#
#       Change Log
#
#         Date    Name               Description.................
#       08/08/99  Peter R. Schmidt   Start Program 
#
###############################################################################

LOCALDIR=/usr/local/etc

. /usr/local/bin/setenv.sh

if [ -f $LOCALDIR/archive_disable ]
then
    echo "NOTE: Informix online database archive was NOT run because:"
    cat $LOCALDIR/archive_disable
    exit
fi

LOGDIR=$INFORMIXHOME/logs

#---------------------------------------------------------------------------
#	Rotate the disk file holding the ontape archive

/home/informix/bin/rotate_informix_archive.sh

echo "----------------------------------------------------------------------"

date
echo "Starting ONCHECK Consistency Checks of INFORMIX-Online database "

#---------------------------------------------------------------------------

echo
echo "OnLine Consistency Check - Validate reserved pages (oncheck -cr)"

OUTFILE=$LOGDIR/oncheck-cr.out
oncheck -cr > $OUTFILE

if [ $? != 0 ]
then
	echo "Error: oncheck -cr failed to complete normally"
fi

grep -i ERROR $OUTFILE

chown informix:informix $OUTFILE

#---------------------------------------------------------------------------

echo
echo "OnLine Consistency Check - Validate chunk free list (oncheck -ce)"

OUTFILE=$LOGDIR/oncheck-ce.out
oncheck -ce > $OUTFILE

if [ $? != 0 ]
then
	echo "Error: oncheck -ce failed to complete normally"
fi

grep -i ERROR $OUTFILE

chown informix:informix $OUTFILE

#---------------------------------------------------------------------------

echo
echo "OnLine Consistency Check - Validate system catalogs (oncheck -cc)"

OUTFILE=$LOGDIR/oncheck-cc.out
oncheck -cc > $OUTFILE

## Note: check of return code removed because oncheck -cc always creates
##	     stupid warning messages.
##
## if [ $? != 0 ]
## then
## 	 echo "Error: oncheck -cc failed to complete normally"
## fi

grep -i ERROR $OUTFILE

chown informix:informix $OUTFILE

#---------------------------------------------------------------------------

echo
echo "OnLine Consistency Check - Validate Indexes (-cI)"

OUTFILE=$LOGDIR/oncheck-cI.out
oncheck -cI -y $DATABASE > $OUTFILE

if [ $? != 0 ]
then
	echo "Error: oncheck -cI failed to complete normally"
fi

grep -i ERROR $OUTFILE

chown informix:informix $OUTFILE

#---------------------------------------------------------------------------

echo
echo "OnLine Consistency Check - Validate TBLspace data (-cD)"

OUTFILE=$LOGDIR/oncheck-cD.out
oncheck -cD $DATABASE > $OUTFILE

if [ $? != 0 ]
then
	echo "Error: oncheck -cD failed to complete normally"
fi

grep -i ERROR $OUTFILE

chown informix:informix $OUTFILE

echo "----------------------------------------------------------------------"

date
echo "Starting level 0 ARCHIVE of INFORMIX-Online database"

ontape -s -L 0 <<-EOF

EOF

if [ $? = 0 ]
then
	date
	echo "Completed level 0 archive of INFORMIX-Online database"
else
	date
	echo "Level 0 archive of INFORMIX-Online database FAILED"
fi