扩展名为 .BAK 的 Oracle 文件
我从客户那里收到了 10 个备份文件，扩展名为 .bak。现在，创建这些备份文件的客户端人已经离开，没有人知道那是什么类型的bak文件。 我尝试使用各种工具通过查看元数据来识别文件类型，但没有成功。
我们尝试在 SQL Server 上使用它来恢复它，但是，我们无法恢复它。客户端认为这可能是使用 RMAN 进行的 Oracle 备份。
请有人确认是否可以使用 .BAK 扩展名进行 Oracle 备份？如果是，我该如何恢复？我不擅长使用 RMAN 或 sql plus
一步一步的指导会有帮助
谢谢！
I have received 10 backup files from the client with the extension .bak. Now, the person from the client side who created those backup files left and no one knows what kind of bak file that is.
I tried identifying the file type by looking at the metadata using various tools with no success.
We tried restoring it using on SQL server, however, we were unable to restore it. The client thinks it can be an oracle backup taken using RMAN.
Can please someone confirm if an oracle backup can be taken with .BAK extension? If yes, how can I restore it? I am no good in using RMAN or sql plus
A step by step guidance would be help
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
在 rman 备份中，文件名几乎没有任何意义。只有一种方法可以了解它们的真实情况，那就是备份过程的日志记录。
如果这确实是 rman 备份文件，您可以尝试根据已安装的数据库对它们进行编目。那将是我的第一步。
如果成功了，你就可以尝试继续奋斗。有关 oracle rman 的一些知识，当然还有使用 rman 创建、备份和恢复它们肯定会有所帮助。 SQL Server 知识根本没有多大帮助。
如果对文件进行编目，下一步将恢复控制文件和 spfile。有了这些，您应该能够创建一个可以恢复数据库的可用实例。
这篇文章可以在目录过程中提供一些指导： https://ittutorial.org/rman-catalog-start-with-command-tips-in-oracle/amp/
这假设是 Linux，但同样适用于 Windows。如果您知道数据库来自哪个平台，这会有所帮助，因为跨平台恢复是另一回事。
In rman backups the filenames hardly have any meaning. There is only one way to know what they really are and that is the logging of the backup process.
If this really are rman backup files, you could try to catalog them against a mounted database. That would be my first step.
If this succeeds you can try to struggle ahead. Some knowledge of oracle rman and ofcourse creating, backing up and restoring them using rman certainly helps. SQL server knowledge won’t be of much help at all.
If the files are catalogued, next step would be to restore the control file and the spfile. With those you should be able to create a useable instance that can restore the database.
This post could give some guidance in the catalog process: https://ittutorial.org/rman-catalog-start-with-command-tips-in-oracle/amp/
This assumes Linux but the same applies to windows. It helps if you know from what platform the database came since cross platform restores are an other story.