急!有酬谢：修复INTERBASE损坏的数据库

[rac998]

数据库文件：
http://www.21sec.com/sf/ggtv3.rar

谁能修复请和我们联系：
013597339811 李先生
[e-mail] [e-mail]
有酬谢!

[SuperTitan001]

你说的情况和我在
http://expert.csdn.net/Expert/topic/2175/2175127.xml?temp=.9967462
说的情况是一样的，我一直没有办法修好，不知道哪位高手能修好，呵呵！

[SuperTitan001]

我个人认为靠gfix是无法修好这个数据库的。
不过这个问题不解决，我总是不敢在大型项目中推荐使用interbase。
希望大家能集思广益，看是否能解决。
我来抛砖引玉：我认为这个数据库只有最后的数据页面损坏了，不知道能否通过修改数据库的表头信息，将这坏的数据页面抛弃。（我认为没有必要修那几个数据页面）但是我没有这方面的资料。

[rac998]

是的，就是有4个PAGE坏了。
我新安了7.0版的INTERBASE，里面有新版的GFIX.EXE，可是连错误也不报了，就是像死机那样没有响应了？
那位有新版的7.0请帮忙试试看

[rac998]

-------------------------------------
被损坏数据库修复工具 （试用版）
-------------------------------------


http://www.officerecovery.com/interbase/download_demo.htm

试过修复过一个坏数据库，还可以，只是有试用版限止

[SuperTitan001]

上面的工具好象确实可以修复不少数据！

[kerosun]

UP

[honestsky]

chinahorse2003(天马星空) 在 《如何修复interbase 数据库》http://expert.csdn.net/Expert/topic/2365/2365750.xml?temp=.1000482 里说：

完全可以修复,资料来自FIRBIRD 站
1. Define the following two variables, it makes life easier, in that you do not have to type in the user name and password every time you issue a command.

SET ISC_USER=SYSDBA
SET ISC_PASSWORD=masterkey
2. Always make sure you work on a copy of the database, not the production database. Use the operating system to make a copy of the database. You must have exclusive access to the database to do this.

copy employee.gdb database.gdb
3. Now check for database corruption. You must have exclusive access to do this, but since you're working on a copy of the original database, this is not a problem.

gfix -v -full database.gdb
4. If the previous command has indicated that there are problems with the database, we now need to mend it.

gfix -mend -full -ignore database.gdb
5. Now check to see if the corruption has been repaired.

gfix -v -full database.gdb
6. If you still see errors, you should now do a full backup and restore. In its simplest format the backup command line should be:

gbak -backup -v -ignore database.gdb database.gbk
7. However if gbak falls over because it is having trouble with garbage collection, then use the following command:

gbak -backup -v -ignore -garbage
database.gdb database.gbk
8. If there is corruption in record versions of a limbo transaction, then you may need to include the -limbo switch:

gbak -backup -v -ignore -garbage -limbo
database.gdb database.gbk
9. Now create a new database from the backup:

gbak -create -v atlas.gbk atlas_new.gdb
屡试不爽


我试了一下，真的很有效。推荐需要的试试上述方法。

[kerosun]

study