by Hello,
# Solstice Backup 6.0.1
# Legato Networker Module for Informix release 2.0
# Informix Dynamic Server 2000 Version 9.21.UC4
# Sun Solaris 7
We have two tape devices one for data and one for logical logs.
The logical logs are backed up with the log_full.sh script.
(continuously)
In the nsrdmi script I have put DO_LOGFILE_BACKUPS to NO.
When we try to take a full backup of our database server it sometimes
succeeds
other times it fails with the message :
* toots_ge:INFORMIX:/ol_besrvdb01:dba02 1 retry attempted
* toots_ge:INFORMIX:/ol_besrvdb01:dba02 ! no output
Further investigation in the bar_act.log learned that the backup fails
because after
the backup of the dbspaces a backup of a logical log is initiated.
But there is already a backup of a logical log going on.
The backup fails completely and retries.
bar_act.log :
2001-06-21 09:23:13 27465 27464 /software/ius/bin/onbar_d -b -L 0
dba02
2001-06-21 09:23:26 27465 27464 Begin level 0 backup dba02.
2001-06-21 09:23:26 27465 27464 Successfully connected to Storage
Manager.
2001-06-21 09:44:36 27465 27464 Completed level 0 backup dba02
(Storage Manager copy ID: 993108207 993108208).
2001-06-21 09:44:43 27465 27464 A log backup is already running. Can't
start another.
2001-06-21 09:44:47 25196 25194 Begin backup logical log 53788.
2001-06-21 09:44:49 27465 27464 /software/ius/bin/onbar_d complete,
returning 152 (0x98)
2001-06-21 09:44:51 28225 28224 /software/ius/bin/onbar_d -b -L 0
dba02
2001-06-21 09:44:55 25196 25194 Completed backup logical log 53788
(Storage Manager copy ID: 993109487 993110183).
...
2001-06-21 09:44:59 28225 28224 Begin level 0 backup dba02.
2001-06-21 09:45:00 28225 28224 Successfully connected to Storage
Manager.
2001-06-21 09:55:10 28225 28224 Completed level 0 backup dba02
(Storage Manager copy ID: 993109500 993109501).
2001-06-21 09:55:14 25196 25194 Begin backup logical log 53867.
2001-06-21 09:55:16 28225 28224 A log backup is already running. Can't
start another.
2001-06-21 09:55:22 28225 28224 /software/ius/bin/onbar_d complete,
returning 152 (0x98)
We are doing bulk operations and use a log of logical log. The change a
logical log is backing up when
the full backup tries also to backup a logical log is very high.
If we are lucky the backup succeeds otherwise it fails (in most of the
cases)
Is there a workaround for this problem ?
Tanks,
Stefan