Subject | Re: [firebird-support] Yecchh - 8.5GB corrupted db |
---|---|
Author | Alexey Kovjazin |
Post date | 2004-01-27T07:47:32Z |
Hello, Bob!
Your error message means the physical corruption of your database - some
index pages (with type 7) will be written instead data pages (5). Why - I
cannot say, this error is rather seldom and still elusive both in InterBase
and Firebird.
I think it is not a heavy corruption.
To repair, follow these step:
gfix -v -full ...
gfix -mend ..
(To see errors you should look in firebird.log file, not to output.)
After that try to backup without garbage collecting
gbak -b -g -v ...
and after that restore
gbak -c -v ...
If you want to know more, you can find a lot of useful links here
http://www.google.com/search?num=50&hl=en&ie=UTF-8&oe=windows-1251&inlang=ru
&safe=off&q=firebird+database+repairing&spell=1
Sincerely yours,
Alexey Kovjazin
www.ibsurgeon.com / www.ib-aid.com
Your error message means the physical corruption of your database - some
index pages (with type 7) will be written instead data pages (5). Why - I
cannot say, this error is rather seldom and still elusive both in InterBase
and Firebird.
I think it is not a heavy corruption.
To repair, follow these step:
gfix -v -full ...
gfix -mend ..
(To see errors you should look in firebird.log file, not to output.)
After that try to backup without garbage collecting
gbak -b -g -v ...
and after that restore
gbak -c -v ...
If you want to know more, you can find a lot of useful links here
http://www.google.com/search?num=50&hl=en&ie=UTF-8&oe=windows-1251&inlang=ru
&safe=off&q=firebird+database+repairing&spell=1
Sincerely yours,
Alexey Kovjazin
www.ibsurgeon.com / www.ib-aid.com