Thursday, 7 April 2016

Re: [firebird-support] help to repair a corrupted database

 

On Thu, Apr 7, 2016 at 11:28 AM, korkless@yahoo.it [firebird-support] <firebird-support@yahoogroups.com> wrote:


hi, i'm trying to repair a corrupted db for firebird 2.5.2,  the database file is of about 30 gb.

i have disconnected all the user, i did a copy of the file and then i executed the command
gfix -validate 'dbname' with the credentials of the user that created the db (not the sysdba)

now the gfix process is 90 minutes that is on 0 cpu usage and 1 mb of ram but the firebird process sometime works,

is the gfix process freezed or it's normal?

Probably normal.  Gfix itself doesn't do much, it just connects to the database with options
that cause Firebird to validate the database.   

 
can i terminate it and retry or maybe this can add other problems to my database file?

I wouldn't terminate it for another couple of hours.  It's unlikely that stopping gfix will
have adverse effects on the database, though stopping the Firebird server could.

What are the symptoms of the corruption?

Good luck,

Ann 

__._,_.___
Posted by: Ann Harrison <aharrison@ibphoenix.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)