Subject | Database Corrupt, can't backup and restore. |
---|---|
Author | midnight_fred@ymail.com |
Post date | 2009-08-01T16:21:42Z |
Hi all,
My 600 Mo Firebird 2.1.1 Database is corrupted (page file problems).
I've tried to do Gfix and Gbak usefull command without success. How could I get my data back ? It seems that the backup of my database are also corrupted... I've tried to use gfix and gbak from 2.1.2 without success.
Any idea ? Thanks, in advance.
Regards from France,
Fred
------------
bellow you can find is some indication for someone who can help me :
Result of the Gfix command :
gfix -mend -i -user SYSDBA -password masterkey D:\SAVE\COPY_BASE.FDB
Summary of validation errors
Number of record level errors : 11
Number of Blob page errors : 6
Number of data page errors : 2
Number of database page errors : 106
------------
Result of gbak backup command (aborted after creating a 180Mo file of backup) :
gbak -b -ig -g -user SYSDBA -password masterkey D:\SAVE\COPY_BASE.FDB D:\SAVE\COPY_BASE.FBK
gbak: ERROR:attempted retrieval of more segments than exist
gbak: ERROR:gds_$get_segment failed
gbak:Exiting before completion due to errors
------------
Errors seen in firebird.log ( a lot of message concerning tra.cpp line 2484 is logged on)
COMPUTER (Server) Sat Aug 01 15:35:39 2009
Database: D:\SAVE\COPY_BASE.FDB
Page 146628 is an orphan
COMPUTER (Server) Sat Aug 01 15:41:48 2009
Database: D:\SAVE\COPY_BASE.FDB
internal gds software consistency check (cannot find tip page (165), file: tra.cpp line: 2494)
My 600 Mo Firebird 2.1.1 Database is corrupted (page file problems).
I've tried to do Gfix and Gbak usefull command without success. How could I get my data back ? It seems that the backup of my database are also corrupted... I've tried to use gfix and gbak from 2.1.2 without success.
Any idea ? Thanks, in advance.
Regards from France,
Fred
------------
bellow you can find is some indication for someone who can help me :
Result of the Gfix command :
gfix -mend -i -user SYSDBA -password masterkey D:\SAVE\COPY_BASE.FDB
Summary of validation errors
Number of record level errors : 11
Number of Blob page errors : 6
Number of data page errors : 2
Number of database page errors : 106
------------
Result of gbak backup command (aborted after creating a 180Mo file of backup) :
gbak -b -ig -g -user SYSDBA -password masterkey D:\SAVE\COPY_BASE.FDB D:\SAVE\COPY_BASE.FBK
gbak: ERROR:attempted retrieval of more segments than exist
gbak: ERROR:gds_$get_segment failed
gbak:Exiting before completion due to errors
------------
Errors seen in firebird.log ( a lot of message concerning tra.cpp line 2484 is logged on)
COMPUTER (Server) Sat Aug 01 15:35:39 2009
Database: D:\SAVE\COPY_BASE.FDB
Page 146628 is an orphan
COMPUTER (Server) Sat Aug 01 15:41:48 2009
Database: D:\SAVE\COPY_BASE.FDB
internal gds software consistency check (cannot find tip page (165), file: tra.cpp line: 2494)