Interbase repair collection method and common error message

xiaoxiao2021-03-06  128

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).

转载请注明原文地址:https://www.9cbs.com/read-98703.html

New Post(0)