Re: Backups larger than 2gb
I would recommend that you use Informix Storage Manager and
OnBAR. It takes a bit more complicated to configure than OnTape,
but it will be able to handle large database backups.
------Original Message------
From: Norman Erickson Lugtu <elugtu@my-deja.com>
To: informix-list@iiug.org
Sent: January 23, 2001 10:15:00 PM GMT
Subject: Re: Backups larger than 2gb
Yes, its possible.
The TAPESIZE and LTAPESIZE will still defined as 2 GB but you need to
create a script that will manage the renaming of the 2 GB file and
pressing the ENTER key.
Below is the shell script that manages the continuous logical log
backup. If you want to test this script if it really copies the file
before the Press Any Key..., change LTAPESIZE to 20 MB.
Copy this file at $INFORMIXDIR/bin directory and chmod 700 autolog.sh
Usage: nohup autolog.sh [<dir-to-copy] >> /dev/null &
If you are satisfied with this shell scipt, inform me and I will give
you the ontape script to disk.
Erickson
###############################################
# #
# Script Name : $INFORMIXDIR/bin/autolog.sh #
# Developed By: Norman Erickson Lugtu #
# Last Update : November 30, 2000 #
# #
###############################################
# Usage: nohup autolog.sh >> /dev/null &
LLOGFILE=`onstat -c|grep LTAPEDEV|awk '{print $2}'`
LFILENAME=`basename $LLOGFILE`
LOUTFILE=`dirname $LLOGFILE`
if [ $# -gt 0 ] ; then
if [ -d $1 ] ; then
LOUTFILE=`dirname $1`/`basename $1`
else
echo "Directory path not found"
exit 2
fi
fi
LASTLOG=$INFORMIXDIR/.lastlog
LOUTDIR=$LOUTFILE/`date +%m%d`_l
LOUTLOG=$LOUTDIR/autolog.log
export LLOGFILE LFILENAME LOUTFILE LASTLOG LOUTDIR LOUTLOG
mkdir $LOUTDIR
echo "Time Started: `date +%b' '%d,' '%Y' '%T`\\n" >$LOUTLOG
if [ "$LLOGFILE" != "/dev/null" ] ; then
cp /dev/null $LLOGFILE
chmod 660 $LLOGFILE
fi
{
sleep 5
CTR=100
echo
echo "\\nEnter key pressed..." >> $LOUTLOG
while true ; do
sleep 5
CHECK=`tail -1 $LOUTLOG | awk '{print $2}'`
if [ "$CHECK" = "mount" ] || [ "$CHECK" = "over." ] ; then
if [ "$CHECK" = "mount" ] || [ -s $LLOGFILE ] ; then
if [ "$LLOGFILE" != "/dev/null" ] ; then
CTR=`expr $CTR + 1`
mv $LLOGFILE $LOUTDIR/$LFILENAME.$CTR
chmod 660 $LOUTDIR/$LFILENAME.$CTR
touch $LLOGFILE
chmod 660 $LLOGFILE
fi
fi
if [ "$CHECK" = "mount" ] ; then
echo
echo "\\nEnter key pressed..." >> $LOUTLOG
else
echo "autolog.sh exited with $LFILENAME.$CTR" >> $LOUTLOG
exit
fi
fi
done
} | nohup ontape -c >> $LOUTLOG
sleep 10
if [ -s $LASTLOG ] ; then
for lname in `cat $LASTLOG` ; do
rm -r $lname
done
rm $LASTLOG
fi
echo $LOUTDIR >> $LASTLOG
echo "\\nTime Stopped: `date +%b' '%d,' '%Y' '%T`" >>$LOUTLOG
In article <3A6DE43F.75E27A46@nokia.com>,
Allen Wyatt <Allen.Wyatt@nokia.com> wrote:
> Is it possible to make a backup to disk using ontape that is larger
than
> 2 gigabytes? I think I read that it depends on your operating system
> and version of Informix. I'm using Solaris 8 with Informix 2000
version
> 9.21. Does this combination support huge ontape disk archive and log
> backups?
>
>
Sent via Deja.com
http://www.deja.com/
______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup