Re: Replaying log files
From: lukebrennan (lukebrennan_at_iinet.net.au)
Date: 02/24/04
- Next message: Pete C: "Forwarding Emails Probs"
- Previous message: lukebrennan: "Re: e-mail accounts"
- In reply to: Jim: "Replaying log files"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Feb 2004 22:40:18 -1000
Jim wrote:
> Hi,
>
> I have a problem with replaying my log files.
> I had to restore my priv.edb offline on another server.
logs write to an explicit database structure and CANNOT be played-in
unless the database structure MATCHES in reality that which the logs are
assuming is the current state of play. The log writes are raw writes to
Page X, offset Y, etc. NOT "the message from Jim.."
You can't play random logs in, you can't skip logs, you can't "fiddle"
with logs...
-offline- means you shut the store down cleanly, all the log data
got committed to the store and it was complete and consistent prior to
the restore. The logs aren't needed because everything IS in the
database properly.
If you did NOT shut it down cleanly and check that it was consistent
prior to the copy/restore then you are in trouble right at this point.
You just ripped the copy out from the live/running database? BZZZT...
-online- restore means you took an ONLINE backup copy and restored,
with the appropriate logs (and a structure .patch file in older
versions) played in FROM THE TAPE BACKUP to ensure that the data and
structure are consistent...
When i tried
> to start the IS my priv.edb was inconsistent. I repaired my priv.edb
> with eseutil /p to make it consistent.
When you did this, you effectively rewrote/dropped the database
portions that were missing/incomplete from the original logs. Once you
did this, the logs CANNOT then be played in, as the structure of the
database has been changed. You *WOULD* end up with oddball/screwy data.
BZZZT... new signature. Old Logs don't like this STORE.
After that i had to defrag the
> priv.edb with eseutil /d to start the IS.
When you did this, you COMPLETELY recreated the database by
extracting the data and dumping into a new store. This has a TOTALLY new
structure compared to the original. AND to make this perfectly clear, it
tagged it with a completely new signature to stop you doing something
utterly destructive - like playing in logs from another database...
BZZZT... new signature. Old Logs don't like this STORE.
> Now my database signature has changed. When i try to replay the log
> files i get the message: The database signature does not match the log
> signature.
ABSOLUTELY TRUE AND CORRECT.
> Can i fix this problem? Please help!!!
This isn't a PROBLEM, it's INTENDED.
Can you go back to an ONLINE BACKUP of the original database and logs?
Can you go back to a consistent OFFLINE backup of the original database?
Luke
- Next message: Pete C: "Forwarding Emails Probs"
- Previous message: lukebrennan: "Re: e-mail accounts"
- In reply to: Jim: "Replaying log files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
