IDS Forum

RE: Auto Informix Backup Error

Posted By: Knox, Ernest
Date: Saturday, 3 October 2009, at 10:32 a.m.

In Response To: Auto Informix Backup Error (MONTE HEEREN)

Something we created and use. It may not be perfect, but it works for
multiple file backups.

$cat /usr/informix/Admin/cron_scripts/rrc_backup_exec.sh
#!/bin/ksh

. $1

rm /ifmx_backup/backup_*

/usr/informix/Admin/tools/bin/ibackupt.pl /ifmx_backup/backup_

cat
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log
>> /usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup.log

echo >>
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log
echo " sls0440 Backup File System with RRC " >>
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log
echo >>
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log
echo $(df -k | grep Filesystem) >>
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log
echo $(df -k | grep ifmx_backup) >>
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log
echo >>
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log

SUFFIX=`hostname`.d`date "+%m%d%y"`

chmod 700
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log
#rcp
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log
cartman:/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_ma
il.log
rm
/usr/informix/Admin/Logs/backup_logs/${INFORMIXSERVER}_backup_mail.log

rsh lydia "rm /ifmx_backup/Backups_from_RRCs/*`hostname`*.tar.gz"

cp /ifmx_backup/backup_01.gz /ifmx_backup/backup_01_$SUFFIX.gz
chmod 700 /ifmx_backup/backup_01_$SUFFIX.gz
rcp /ifmx_backup/backup_01_$SUFFIX.gz
lydia:/ifmx_backup/Backups_from_RRCs/backup_01_$SUFFIX.gz
rm /ifmx_backup/backup_01_$SUFFIX.gz

cp /ifmx_backup/backup_02.gz /ifmx_backup/backup_02_$SUFFIX.gz
chmod 700 /ifmx_backup/backup_02_$SUFFIX.gz
rcp /ifmx_backup/backup_02_$SUFFIX.gz
lydia:/ifmx_backup/Backups_from_RRCs/backup_02_$SUFFIX.gz
rm /ifmx_backup/backup_02_$SUFFIX.gz

$cat /usr/informix/Admin/tools/bin/ibackupt.pl
#!/usr/bin/perl

use FileHandle;

use IPC::Open2;

#
# Set constants and arguments.
#

$ibdev = $ARGV[0] ;

# New files will have mode 660
umask 016;

sub prnt {
select LH;
$| = 1;
print LH @_ ;
}

#
# This function returns timestamp in the format "mm/dd/yy hh:mm:ss"
#
sub tstamp{
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst ) =
localtime(time);

return sprintf("%02d/%02d/%04d %02d:%02d:%02d",

$mon+1,$mday,$year+1900,$hour,$min,$sec );
}

#
# This function returns today's date in the format "mmddyy"
#
sub today{
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst ) =
localtime(time);

return sprintf("%02d%02d%04d", $mon+1,$mday,$year+1900 );
}

sub chk_device{

return if system( " [ -r @_ -a -w @_ ] " ) == 0 ;

if ( system( " [ -f @_ ] " ) == 0 ) {
prnt("File @_ has incorrect permissions.\n");
exit( 1 );
}

return if ( system("touch @_") == 0 ) ;

prnt("Failed to create new file @_\n");
exit(1);

}

sub cmp_device{

return if ( system("/usr/bin/gzip @_") == 0 ) ;

print("Failed to gzip compress file section @_\n");
exit(1);

}

sub set_device{

( $ld, $rd, $num ) = @_;

unlink $ld || prnt("Unlink failed\n") && die ;

$curdev = sprintf( "%s%02d", $rd, $num );
prnt("\nCurrent backup device: ", $curdev, "\n\n" );

chk_device( $curdev );

symlink $curdev, $ld || prnt("Symbolic link failed.\n") && die ;

}

sub set_device2{

( $ld, $rd, $num ) = @_;

cmp_device( $curdev );

unlink $ld || prnt("Unlink failed\n") && die ;

$curdev = sprintf( "%s%02d", $rd, $num );
prnt("\nCurrent backup device: ", $curdev, "\n\n" );

chk_device( $curdev );

symlink $curdev, $ld || prnt("Symbolic link failed.\n") && die ;

}

sub get_backtape {

open( LTH, " onstat -c | grep '^TAPEDEV' | awk '{print \$2}' |" ) ||
prnt( "onstat error\n" ) && die ;

return( <LTH> );
}

sub sigtrap {
prnt("\nSignal @_ received. Exiting. ", tstamp(), "\n\n" );
exit(1);
}

#
# Main program starts here.
#

die "Usage:$0 ifmx_backup_device" unless $ibdev;

$SIG{TERM} = 'sigtrap' ;
$SIG{QUIT} = 'sigtrap' ;
$SIG{INT} = 'sigtrap' ;
$SIG{STOP} = 'sigtrap' ;

#
# All output goes to log file and stdout.
# Open handler here.
#
$logfile="
/usr/informix/Admin/Logs/backup_logs/$ENV{\"INFORMIXSERVER\"}_backup_mai
l.log" ;

open( LH, ">> $logfile" ) || prnt( "Couldn't open logfile\n" ) && die;

prnt("###################################################\n");
prnt("Informix backup started: ", tstamp(), "\n\n");

prnt( "Server is ", $ENV{"INFORMIXSERVER"}, "\n" );

chop ( $itd = get_backtape()) ;

$curnum = 1 ;

set_device( $itd, $ibdev, $curnum );

$pid = open2( \*Reader, \*Writer, "ontape -s -L 0");

Writer->autoflush();

$status = -1;

while( ! eof Reader ) {
read Reader, $char , 1;

$str .= $char ;

if( ($char eq "\n") || (grep /\.\.\./, $str) ||

grep /\(y\/n\)/, $str ) {

if( (length $str) > 2 ) {

if( ++$lines > 250 ) {

prnt("\nToo many output lines. Something is wrong. Stop here.",

tstamp(), "\n\n"
);

exit(1);

}

prnt( $str, "\n") ;

@fields = split(" ", $str );

if( $fields[0] eq "Please" && $fields[1] eq "mount" &&

$fields[2] eq "tape" ) {

if ( $fields[3] > 1 ) {

set_device2( $itd, $ibdev, ++$curnum )

}

print Writer "\n";

}

}

$status = 0 if( grep /Program over/, $str );

$str = $char = "";

}

}

$cstat = ( $status == 0 ) ? "completed: " : "failed: " ;

prnt("Informix backup ", $cstat, tstamp() ,"\n\n");

cmp_device( $curdev );

exit(0);

Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
Page via Skytel: 2244650553@sprint.skytel.com
Informix or MySQL Primary: 9110210@skytel.com
Informix or MySQL Secondary: 7276872@skytel.com

" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
MONTE HEEREN
Sent: Friday, October 02, 2009 4:14 PM
To: ids@iiug.org
Subject: Auto Informix Backup Error [17310]

Trying to automate my informix backup.
This is my script so far:
________________________________________________________________________
______
.. ./ifasenv # this sets my environment variables
echo "Backing up Ifastest Logical Logs"
{
ontape -a << EOF

Y
EOF
} | tail -5 >> /backup_ifastest.log
echo "Backing up Ifastest Database"
ontape -s -L 0 << ^M |head -100 >> /backup_ifastest.log;

echo "Archive Complete"

----------------------------
The above script works, but after the ontape -s command runs, the script

completes and does not echo "Archive Complete".
Also saw other posts to change the ontape command to :
ontape -s << EOF

0
EOF |tail -5 >> /backup_ifastest.log

This flavor keeps erroring with "<<" unmatched.

Any suggestions why the "Archive Complete" message does not show?

Any suggestions for a better writen script?

Informix 9.4 on HP-UX 11.1

Thanks in advance.

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Auto Informix Backup Error
  MONTE HEEREN -- Friday, 2 October 2009, at 5:14 p.m.
  • RE: Auto Informix Backup Error
    Knox, Ernest -- Saturday, 3 October 2009, at 10:32 a.m.
  • Re: Auto Informix Backup Error
    Art Kagel -- Sunday, 4 October 2009, at 7:59 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.