从 *.DBF 恢复 Oracle XE 数据
是否可以从*.DBF 文件恢复oracle 数据库？如果是，那么如何？我真的发现与 SQL Server 相比，Oracle 中的备份和恢复处理起来很困难。 我有整个 oraclexe 文件夹的备份，包括这些文件。
Is it possible to restore oracle database from *.DBF files? If yes, then how? I really find it hard to deal with backup and restore things in Oracle compared to SQL Server.
I have a backup of the whole oraclexe folder including these files.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
它需要的不仅仅是 DBF 文件。
活动数据库正在写入重做日志、表空间数据文件（DBF）和控制文件。但由于内存中也有信息，因此这些文件在任何时间点都不一定彼此一致。
如果在复制整个 oraclexe 文件夹时数据库被关闭，那么将整个文件夹复制回来并打开数据库应该可以，因为数据库有足够的一致性来恢复。
如果它正在运行，那么您可能必须考虑不完全恢复，这可能（或可能不）成功，具体取决于目录复制花费的时间。
如果在 Windows 中运行，“开始”菜单的 OracleXE 部分下有一个“备份数据库”选项
It needs more than just the DBF files.
An active database is writing to redo logs, tablespace data files (the DBFs) and control files. But because it also has information in memory, none of those files is necessarily consistent with each other at any point in time.
If the database was shut down when you took the copy of the whole oraclexe folder, then copying the whole folder back and opening up the database should work, as there would be sufficient consistency for the database to be recovered.
If it was running, then you'd probably have to look into an incomplete recovery, which may (or may not) be successful depending on how long the directory copy took.
If running in Windows, the Start Menu has a 'Backup Database' option under the OracleXE section