如何恢复/加载dbf以提取数据 [英] How to restore/load dbf to extract data

问题描述

嘿那里，



我有一个要求，我需要从< b> dbf< / b>加载数据，svd，arc，ctl，obk文件，这样我可以运行选择查询（使用复杂的连接）从这些文件中提取数据。这些文件由第三方供应商提供，它采用Oracle 11g数据库的数据库备份。我有Toad for Oracle软件（版本10.5.1.3），但无法完成任务。如果可以使用Toad，请告诉我，如果是，那么如何使用？如果没有，请建议任何可行的免费软件。我没有这个数据库的DBA权限。



非常感谢你对此的快速帮助。

Hey there ,

I have a requirement where I need to load the data from <b>dbf</b> , svd ,arc , ctl ,obk file such that I can run select queries (with complicated joins)to extract the data from these files . These files are provided by 3rd party vendor by taking database back-up of an Oracle 11g database . I have Toad for Oracle software (Version 10.5.1.3), however couldn't accomplish the task . Please let me know if Toad can be used and if yes then how ? If not please suggest a freeware ar anything that will work . I don't have DBA rights on this database .

Your quick help on this is much appreciated.

推荐答案

即使oracle从DBF文件中提取数据，它们也不是有效的备份。恢复数据的唯一方法是使用运行数据文件的相同版本创建新的oracle数据库并恢复数据库。请注意，在不知道原始结构的情况下无法恢复文件，这不是一件容易的事。



请检查是否可以从供应商而不是dbf文件获取dmp文件。

Even though oracle fetches data from the DBF files, they are NOT a valid backup. The only way to recover the data is to create a new oracle database using the same version that the datafiles were running in and recover the database.Please note that you cannot restore a file without knowing the original structure and this is not an easy task.

Please check if you can get dmp file from vendor instead of dbf files.

忘记使用备份或dbf文件。您需要一个与文件来源的服务器几乎相同的设置（文件系统，安装文件和用户帐户，可能还有更多。）

在Oracle上执行此操作的适当方法是< a href =http://www.orafaq.com/wiki/Import_Export_FAQ>导入导出 [ ^ ]文件。

Forget using the backup or dbf files. You would need an almost identical setup as the server the files originate from (file system, setup files and user accounts, and probably a lot more.)
The appropriate way to do it on Oracle is to import an export[^] file.

这篇关于如何恢复/加载dbf以提取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！