[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Recovering from a recent backup

From: Dean Iverson <diverson_at_drivesafety.com>
Date: 2005-04-27 21:57:39 CEST

We switched to subversion from CVS a few months ago. We have now
experienced a server crash and I am attempting my first recovery of a
subversion database.

 From searching the internet and the archives of this newsgroup, I have
understood that if I have a recent snapshot of the repository and
recent log files, I should be able to copy the log files into the older
repository and do a "db_recover -vec" to have the database reapply the
changes from the log files.

I had a dump of the database from a couple of months ago. In addition
I was able to salvage most of the recent log files from the repository.
  So I created a new repository and loaded the dump file into it. This
got me up to log.0000000099. I then copied log files log.*99 through
log.*227 into this new repository and ran "db_recover -vec" from the
repository's db directory.

The recover completed with the following output:

db_recover: Finding last valid log LSN: file: 227 offset 416148
db_recover: Recovery starting from [1][28]
db_recover: Recovery complete at Wed Apr 27 12:53:34 2005
db_recover: Maximum transaction ID 800264f1 Recovery checkpoint
[227][416196]
db_recover: warning: changes: No such file or directory
db_recover: warning: copies: No such file or directory
db_recover: warning: nodes: No such file or directory
db_recover: warning: representations: No such file or directory
db_recover: warning: revisions: No such file or directory
db_recover: warning: strings: No such file or directory
db_recover: warning: transactions: No such file or directory
db_recover: warning: uuids: No such file or directory
db_recover: Recovery complete at Wed Apr 27 12:53:34 2005
db_recover: Maximum transaction id 80000000 Recovery checkpoint
[227][416196]

After this, when I run a dump or verify of this repository it still
shows that it is only at the revision number that coincides with the
log.*99 file. It didn't reapply the changes from the additional log
files I copied in. The changes, copies, nodes, etc. files are in the
db directory so I'm not sure why it can't find them. What am I missing
here?

I would be extremely grateful if anyone could shed some light here.

Dean Iverson
DriveSafety, Inc.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Wed Apr 27 22:12:20 2005

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.