如何从备份文件（ora 文件）重新创建 oracle 9i 数据库
我是一名开发人员，所以我对 DBA 的世界有点迷失。 我们的系统人员为我提供了 Oracle 9i 数据库的备份。 我已经在我的电脑上安装了 oracle 9i，现在正在尝试“导入”备份文件，以便我有一个正常的数据库可以使用。
备份文件夹包含 SNCF[SID].ora 文件和大约 150 个 [SID]-[Date]-[counter]-[soemnumber].ora 文件。 问题是，如何将这些数据导入到oracle中以便通过sql查询呢？
我已经创建了一个与备份数据库的 SID 相匹配的数据库。 Google 告诉我需要进入 rman 并运行“数据库恢复”。 但它如何知道回溯文件的位置呢？
有任何想法吗？ 谢谢。
我不知道。 说真的，我们备份的 Oracle 数据是一个非常旧的应用程序的一部分，该应用程序正在被淘汰。 没有人真正拥有数据库，而且我们手头上也没有 DBA……所以这一切就落在了我这个唯一的开发人员身上。 明天我可以尝试为您提供更多详细信息。
同时，原始数据库运行在Windows机器上，并且是9i的某个版本。 我在 Windows XP 机器上安装了 Oracle 9i (9.2.0.1.0)（我专门安装了这个旧版本，以便可以从备份文件重新创建数据库）。
备份是专门完成的，这样我就可以尝试在我的电脑上重新创建它（这样我们就不会扰乱生产）。 我们每周只有几个小时的时间窗口，因此以不同的方式重做备份并不容易。
一位DBA朋友建议我们导出数据库而不是做全量备份； 然而，系统人员在导出时遇到了问题，所以现在我有了完整的备份。
就控制文件而言，看起来有一个SNCF[SID].ORA文件，大约2.2兆，这显然是控制文件。 所有其他文件（略多于 150 个）大约有半演出，也以 ORA 结尾。 我猜这些是实际的数据文件。
我很快就会得到准确的 oracle 和 windows 版本。
I'm a developer so I'm a little lost in the DBA world. Our systems guys have given me a backup of an Oracle 9i database. I have installed oracle 9i on my pc and am now trying to 'import' the backup files so I have a normal database to work with.
The backup folder has on SNCF[SID].ora file and around 150 [SID]-[Date]-[counter]-[soemnumber].ora files. The question is, how do I get this data into oracle so I can query it through sql?
I have gotten as far as creating a database which matches the SID of the backed up database. Google tells me that I need to go into rman and run "database restore." But how does it know where the backfiles are located?
Any ideas? Thanks.
I...don't...know. Seriously, the Oracle data we backed up is part of a very old application which is being phased out. No one really owns the database, and we have no DBAs on hand...so it falls on me, the only developer. I can try to get more details for you tomorrow.
In the mean time, the original database runs on a windows machine and is some version of 9i. I installed Oracle 9i (9.2.0.1.0) on my Windows XP box (I installed this older version specifically so I could recreate the database from the backed up files).
The backup was done specifically so I could try to recreate it on my pc (so we wouldn't mess with production). We only have one window of a few hours a week, so it is not easy to just redo the backup differently.
A DBA friend advised that we export the database rather than doing a full backup; however, the systems guys had a problem with the export so now I have this full backup.
As far as control files are concerned, it looks like there is an SNCF[SID].ORA file, about 2.2 megs, which is apparently the control file. All other files (a little over 150) are around half a gig, also with ORA endings. I'm guessing those are the actual data files.
I'll get the exact oracle and windows versions soon.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
好的，首先要做的事情。 备份究竟是从哪个版本的 Oracle 中获取的？ 9i 是一个营销标签——我们需要完整的 4 位版本号（即 9.2.0.4）。 您的 PC 运行的 Oracle 版本是否完全相同？ 您的电脑运行完全相同的操作系统吗？
备份是如何完成的？ 您是否正在寻找数据库的一致冷备份？
您没有任何控制文件（通常是.ctl）吗？
SNCF[SID].ORA 听起来像是参数文件，而不是控制文件。 您需要一个控制文件才能恢复数据库。
如果数据库实际上在某个地方启动并运行，我敢打赌，如果您努力找出为什么使用导出实用程序不起作用并解决该问题，那么您总体上将经历更少的痛苦和痛苦，而不是尝试从冷备份中恢复数据库，特别是在备份方式存在任何混乱的情况下。
OK, first things first. Exactly what version of Oracle was the backup taken from? 9i is a marketing label-- we need the full 4 digit version number (i.e. 9.2.0.4). Is your PC running exactly the same version of Oracle? Is your PC running exactly the same operating system?
How was the backup done? Are you looking at a consistent cold backup of a database?
Do you not have any control files (normally .ctl)?
SNCF[SID].ORA sounds like a parameter file, not a control file. You would need a control file to be able to restore the database.
If the database is actually up and running somewhere, I'm going to wager that you'll go through far less pain and agony overall if you work on figuring out why using the export utility didn't work and fixing that problem than in trying to recover the database from a cold backup, particularly if there is any sort of confusion over how the backup was taken.
.ora 文件？？？ 这通常是 pfile 的扩展名（在 9i 中您更喜欢使用 spfile）。
不知道文件的日期/编号。 也许它们是警报日志？ 或者它们是带有奇怪扩展名的exp转储。 或者它们是 rman 备份的一部分？
您说“备份是专门完成的，因此我可以尝试在我的电脑上重新创建它”，那么为什么您没有具体的说明来恢复它呢？
抱歉，我的问题多于答案。 但我建议您从真正的 DBA 那里获得专家帮助。
你的系统人员是一个不错的选择。 向他们寻求帮助，他们制造了这个混乱。
.ora files??? That's usually the extension for a pfile (in 9i you would prefer having an spfile instead).
No idea about the dated/numbered files. Maybe they're alert logs? or are they exp dumps with a weird extension. or are they part of an rman backup?
You say "The backup was done specifically so I could try to recreate it on my pc", so why don't you have specific instructions to restore it?
Sorry I have more questions than answers here. But I suggest you get expert help from a real DBA.
Your systems guys are a good bet. ask them for help, they created this mess.