Subject Re: RES: [firebird-support] Error in DB
Author Yang Jin
Ann Harrison <aharrison@...> wrote:
Marcelo Pitanga wrote:

>gfix -v -full -user SYSDBA -password masterkey c:\temp\copia.gdb
>if this command reports errors then try:
>1) gfix -mend -full -ignore -user SYSDBA -password masterkey
>2) gbak -backup -v -ignore -garbage -limbo -user SYSDBA -password masterkey
>c:\temp\copia.gdb c:\temp\copia.gbk
>the command (1) prepare your database to backup
>gbak -create -v -user SYSDBA -password masterkey c:\temp\copia.gbk
>this command execute a restore creating a new database.

That's generally very good advice, but in this particular case, I think
it won't work. My guess is that he's got a missing TIP (transaction
inventory page). On scenario is that the system was running with forced
writes turned off and crashed - possibly due to a power failure - with a
few pages at the end still in the system cache and not on disk.

I am agree with your guess in my heart.Our product's databases without forced writes often has been corrupted by power failure.

I think turn on the foreced writes is a good method to avoid the crash.Is it right?

If the corrupt had existed,How to fix it?Which method is better and available?

Another question:How to use qli to transport data between two same database.It will failure when the table field is numeric or integer in windows2000.How to over it?It is important to me.


Best Regards


Do You Yahoo!?

[Non-text portions of this message have been removed]