JMCraig
2007-12-24 19:47:53 UTC
Hi Folks,
I've been happily restoring copies of dump files from one box onto
another for several years.
But, during a recent upgrade to the application software that uses
Sybase on the primary box, we shut down the auto-restores on the
secondary box (no big deal: done it multiple times before). But this
time, when I try to get the secondary box caught up (it's set up to be a
standby-access copy of the live DB on the primary box), I'm getting this:
Backup Server: 4.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP
or LOAD session must exit.
I get one instance of these 3 error messages for each of the 12 stripe
files. This isn't anything fancy, just a LOAD DATABASE from a
multi-stripe series of dump files that have been copied to the secondary
box.
This is all very puzzling because nothing has changed on the live DB
except the addition of a few columns to tables that were already there.
Nothing has changed on the secondary box except that we turned off the
cron jobs that normally kept the DB in sync with the live one (by doing
load transaction of the most recent tran dump from the primary DB--and
an occassional load database [just to be sure our dumps were good]).
I have done some file comparisons to verify that the copies of the dump
files on the secondary box are identical to the originals. And, I shut
down and restarted the backup server on the primary box--as well as
a full shutdown/restart on the secondary of both the dataserver and
backup server: no luck.
Here's the version info on the primary server (note that although
they're on different ESD's, this has been the case for many months--hard
to find times to bring down the live box to update it and it's worked fine):
Adaptive Server Enterprise/12.5.3/EBF 12600 ESD#3/P/Linux
Intel/Enterprise Linux/ase1253/1911/32-bit/OPT/Fri Jul 8 02:32:50 2005
And the secondary:
Adaptive Server Enterprise/12.5.3/EBF 13332 ESD#7/P/Linux
Intel/Enterprise Linux/ase1253/1951/32-bit/OPT/Fri Mar 24 00:40:52 2006
Any suggestions gratefully accepted.
JMCraig
I've been happily restoring copies of dump files from one box onto
another for several years.
But, during a recent upgrade to the application software that uses
Sybase on the primary box, we shut down the auto-restores on the
secondary box (no big deal: done it multiple times before). But this
time, when I try to get the secondary box caught up (it's set up to be a
standby-access copy of the live DB on the primary box), I'm getting this:
Backup Server: 4.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP
or LOAD session must exit.
I get one instance of these 3 error messages for each of the 12 stripe
files. This isn't anything fancy, just a LOAD DATABASE from a
multi-stripe series of dump files that have been copied to the secondary
box.
This is all very puzzling because nothing has changed on the live DB
except the addition of a few columns to tables that were already there.
Nothing has changed on the secondary box except that we turned off the
cron jobs that normally kept the DB in sync with the live one (by doing
load transaction of the most recent tran dump from the primary DB--and
an occassional load database [just to be sure our dumps were good]).
I have done some file comparisons to verify that the copies of the dump
files on the secondary box are identical to the originals. And, I shut
down and restarted the backup server on the primary box--as well as
a full shutdown/restart on the secondary of both the dataserver and
backup server: no luck.
Here's the version info on the primary server (note that although
they're on different ESD's, this has been the case for many months--hard
to find times to bring down the live box to update it and it's worked fine):
Adaptive Server Enterprise/12.5.3/EBF 12600 ESD#3/P/Linux
Intel/Enterprise Linux/ase1253/1911/32-bit/OPT/Fri Jul 8 02:32:50 2005
And the secondary:
Adaptive Server Enterprise/12.5.3/EBF 13332 ESD#7/P/Linux
Intel/Enterprise Linux/ase1253/1951/32-bit/OPT/Fri Mar 24 00:40:52 2006
Any suggestions gratefully accepted.
JMCraig