This day I worked in Visual FoxPro 9 during some hard hours. I know that it's very old software, but I have to use it for my job. But only twenty minutes ago my laptop couldn't open working database, it simply powered off. When database was finally launched I got error message: The table will need to be repaired before using again. Error: 2091. I tried to fix dbf file by the facilities. But all my efforts were unsuccessful.
I assume you have no backup and you are running in
Additional resources that could be useful for you might be following, good luck...
https://support.microsoft.com/en-us/help/193952/how-to-troubleshoot-to-resolve-suspected-corruption-in-visual-foxpro
https://www.codeproject.com/Articles/20116/Repair-DBF-File-corrupted-by-power-failer
https://dbf.recoverytoolbox.com/
NOARCHIVELOG mode, otherwise you wouldn't be asking this question.
Assuming that your db file is really corrupted, then you can startup the database without this file:
1. take a full backup of all your current db files, control files, redo log files.
2. Startup mount the instance
3. ALTER DATABASE DATAFILE 'fullpath/filename' OFFLINE DROP;
4. ALTER DATABASE OPEN;
This will drop the file from your db, so all data in it will be lost, but the data in other tablespaces will be accessible.
If this doesn't work, restore to its original state using the backup taken in step 1.
However, before concluding that your file is corrupt, try to see what happened to it.
Post the following info:
Your archivelog/noarchivelog mode.
Tablespace to which this file belongs.
Oracle error when starting up the database.
Also, startup mount your db and :
SELECT * FROM V$DATABASE;
SELECT * FROM V$DBFILE;
SELECT * FROM V$RECOVER_FILE;
SOURCE: Is it possible to Repair DBF file?
If the file needs to be repaired, it is already damaged. To make things worse not only keeps a spare copy. And so - foxfix very powerful tool for recovery. Or a hex editor to see what is written in the tail of the file if the garbage - it cut before the "normal" data (aligned along the border post), to calculate the size and the size of the .dbf header records how many there really are, and to correct the record count in the header. Also there is a file header, which is similar to can (and should) rule in heh mode.
here you can see this topic. Here is the link to the forum
and even try to program DBF Recovery Kit
SOURCE: Clipper program: Error: 2091
Hello.
DBF Repair Toolbox restores corrupted DBF database files, used in FoxPro, Clipper, dBase and other programs. Software reads a corrupted database and saves a recovered data into new one.
https://www.repairtoolbox.com/dbfrepair.html
132 views
Usually answered in minutes!
×