IB repair collection method:
GFIX method:
Set ISC_USER = SYSDBA
Set ISC_Password = MasterKey
Copy Employee.gdb Database.gdb
gfix -v -full database.gdb
gfix -mend -full -ignore database.gdb
gfix -v -full database.gdb
GBAK -BACKUP -V -IGNORE DATABASE.GDB Database.gbk
GBAK -BACKUP -V -IGNORE -GARBAGE DATABASE.GDB Database.gbk
This method can't be repaired .. Show
Error: Database File APPEARS CORRUPT ()
Error: WRONG Page Type
Error: Page 2796 IS of WRONG TYPE (Expected 6, Found 7)
Error: GDS_ $ Compile_Request Faled
EXITING BEFORE COMPLETIE TO ERRORS
Method 2: IBCONSOLE Validation method:
After the register database, click Right click to try the options inside to true, False has tried it.
shown as:
Database File APPEARS CORRUPT ()
Bad Checksum
Checksum Error on Database Page 14824
Method 3: DBRECOVERY1.0 Enterprise Edition,
Fixed, a bunch of SQL scripts and a BAT file. But will not be used. And the scripts inside have no original data records.
Please enlighten me!
Method 4. IBEXPERT method:
It also appears similar errors. Can restore Domain, but there is no table,
It also shows that the stored procedure is also displayed, the trigger is wrong.
------------ can't!
Method 5: EMS IB Manager
The effect of the display is not just like IBExpert.
Ugh!!!!!!!!
Method 6: DataPump: An error later after SELECT TABLES to Move.
Show error
General SQL Errror.Internal GDS Software Consistency Check (Wrong Record Length (183))
Just received the phone, another customer's IB has a problem!!
Fix is wrong as follows ::
Database File APPEARS CORRUPT ()
Bad Checksum
Checksum Error on Database Page 17784
However, there is a good news, that is, after using several methods, I have mixed it later that night. These methods should be the best with the time of me database. I only have this mixing method. I have been mixed with 3 o'clock to more strange things happened. After the GDB replicated several times, I tried it, but I found that the broken table can be read. Import speed software and try again, the result can be used. However, there are four storage procedures that cannot be modified and the system table is also broken. The system table is not fixed. It can only be done this place for a temporary. Customers are also very satisfied with this fix result. Just I am worried about the problem in my heart (because some are not repaired).
