Fixing a broken GDB file

Databases
InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)

Fixing a broken GDB file

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

My *.gdb file is damaged. When I run gfix, I get this error message:

database file appears corrupt ()
-wrong page type
-page 469 is of wrong type (expected 3, found 0)

I tried -mend, -full etc. all the combinations, but no luck with the *.gdb file. Can I ignore broken pages with gfix from my GDB file, so that I can rescue as much data as I can? I really need that data.

Answer:

make a safety bulk *.gdb file backup. You should shutdown IBServer for that. Always make copies of the .GDB and/or backups. It can be done without shutting down the interbase server, but it's not 100% safe.
There is no way to use gfix to ignore the bad page. So to get to as much data as possible: Do a metadata only backup. Restore that to a new database. Use a data pump to pump data from the damaged database to this restored database.

Alternatively, you can contact the folks at www.ib-aid.com and see if they can fix the database manually.

Send a message to
Subject

Comments:

NEW: Optional: Register Login Email address (not necessary): Rate as	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option, or post under a registered account.

	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material. Add a picture:


	Search: