Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 07-07-2018, 12:40 PM   #1
Beta Member
 
kirstenmoran's Avatar
 
Join Date: Jul 2018
Location: USA
Posts: 1
Default I hope there is a way out of this database situation

I work on Visual FoxPro 9 database. Almost every day I add new data in it. This day has become an exception, when opening .dbf, I saw: "Main.dbf is not a table". To repair dbf file I tried to use some solutions from Google, one of colleagues advised a guide, but none of it didn't aid me.
__________________

__________________
kirstenmoran is offline   Reply With Quote
Old 07-10-2018, 04:18 PM   #2
Site Team
 
berry120's Avatar
 
Join Date: Jul 2009
Location: England, UK
Posts: 3,434
Default Re: I hope there is a way out of this database situation

Unfortunately if the normal repair tools don't work, then you're probably out of luck on an "easy" solution. The only other thing I can recommend (short of a data recovery specialist) is to write your own program to examine the file in light of the DBF file structure (DBF file structure. Xbase File Format Description. DBF file type, dbf field type) and use that to pull out at least some of the data. That's by no means a quick & easy solution though, and will need someone with a reasonable amount of development experience to pull off successfully.
__________________

__________________
Save the whales, feed the hungry, free the mallocs.
berry120 is offline   Reply With Quote
Old 07-12-2018, 08:35 AM   #3
Beta Member
 
Benetty's Avatar
 
Join Date: Jul 2018
Location: USA
Posts: 1
Default Re: I hope there is a way out of this database situation

Quote:
Originally Posted by kirstenmoran View Post
I work on Visual FoxPro 9 database. Almost every day I add new data in it. This day has become an exception, when opening .dbf, I saw: "Main.dbf is not a table". To repair dbf file I tried to use some solutions from Google, one of colleagues advised a guide, but none of it didn't aid me.
I assume you have no backup and you are running in 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:

https://www.codeproject.com/Articles...y-power-failer
https://download.cnet.com/Recuva/300...-10753287.html
https://dbf.recoverytoolbox.com/

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;
__________________
Benetty is offline   Reply With Quote
Old 07-15-2018, 02:42 AM   #4
Baseband Member
 
Join Date: Aug 2017
Location: South Africa
Posts: 35
Default Re: I hope there is a way out of this database situation

Did you ever get it fixed, i googled it and it seems like a really common problem with foxpro. I know hindsight is 20/20 but backups. Its unfortunate whenever i see posts like this is reminds me to make backups.
__________________
petershene is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 10:54 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0