Received operations sent to a previous extract of this database.... - 04-20-2006 , 03:41 PM
My consolidated database server crashed this morning due to a RAID5 failure.
I had to restore from last night's backup. After I had restored using
last night's backup, I was able to get the logs from the damaged server (not
so the db file), so I copied them and tried to restore the database. That
didn't work because the main logs (inv.log) had different offsets. So I
went back to the backup logs.
The information lost is not much, but dbremote is now reporting the
"Warning: Received operations sent to a previous extract of this database
or sent to pre-recovered version of this database."
Also, I'm getting an error like the following:
Received message from "MPUser" (MPUser is one of the remote databases)
This message does not belong to me. Log offset sent to user 'MPUser' is
'0230509771816' but the message header indicates user 'MPUser' has received
log offset '0230595787158'.
What should I do :-(
Re: Received operations sent to a previous extract of this database.... - 04-20-2006 , 04:59 PM
You should open the case with Tech Support to help you work through applying
the production log files from the time of the crash. Note that I am assuming
that when you say "That didn't work because the main logs (inv.log) had
different offsets." that you are referring to the transaction log and mirror
A couple of background questions to have answers ready for when you do call
1) Were you running dbremote -u ...?
It doesn't sound like you were, but this is a recommended practice for
dbremote at the consolidated site.
2) Was your mirror transaction log file on a separate physical drive/RAID
array from your transaction log file?
3) Does dbtran complete successfully against the transaction log? the mirror
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
SQL Anywhere Studio Supported Platforms and Support Status
"Edgard L. Riba" <elriba at rimith dot com> wrote