Hi,

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
following errors:

"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 :-(

Best regards,
Edgard

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
transaction log.

A couple of background questions to have answers ready for when you do call
Support are:

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
transaction log?

--
-----------------------------------------------
Robert Waywell
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:
http://case-express.sybase.com/cx/cx...c?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Edgard L. Riba" <elriba at rimith dot com> wrote