Oracle 10g 备份与恢复恢复
以下是场景：
- 运行 Windows Vista Business 的 Oracle 10g 数据库。这是一个生产/实时数据库。
- 每晚备份（整个数据库、在线备份、ARCHIVELOG 模式）移动到网络上的不同计算机。
- 硬盘坏了。
- 在新硬盘上安装操作系统和 Oracle 10g。 Oracle 还没有任何数据库实例。
是否有一种简单（或至少相对简单）的方法从备份恢复数据库？ 我不是 Oracle DBA，我的 Oracle 知识非常有限。我看过一些“高级 RMAN 命令”，但我不知道该文档是关于什么的。是否有可以简化恢复过程的第 3 方实用程序？
如果 RMAN 脚本是唯一的方法，那么我是否必须在继续之前在 Oracle 中创建一个空数据库？
谢谢
Here is the scenario:
- Oracle 10g database running Windows Vista Business. This is a production/live db.
- Nightly backups (Whole database, online backup, ARCHIVELOG mode) moved to different machine on the network.
- Hard disk dies.
- Setup OS and Oracle 10g on the new hard drive. Oracle does not have any db instances yet.
Is there an easy (or at least relatively easy) way to restore the database from the backup?
I'm not an Oracle DBA and my Oracle knowledge is very limited. I have seen some "advanced RMAN commands", but I have no clue what the doc is about. Is there a 3rd party utility that simplifies the restore process?
If the RMAN scripts are the only way to go, then do I have to create an empty database in Oracle before proceeding?
thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
恢复数据库的能力是 DBA 最基本的职责——如果数据丢失，其他一切都毫无意义。
如果您对恢复过程的了解有限并且您负责恢复生产实例，我的第一个建议是联系支持人员：您不想犯错误。相信我，您不想在生产环境中练习。
一旦数据库恢复，当您有足够的时间时，我建议您首先仔细阅读文档。您应该可以使用 备份和恢复基础知识指南。
现在，您可以通过 Entreprise Manager Web 界面（这是 RMAN 的一个很好的包装）。
The ability to recover a database is the most fundamental responsibility of a DBA -- All else amounts to nothing if data is lost.
If you have limited knowledge of the recovery process and you are in charge of recovering a production instance, my first suggestion would be to contact support : you don't want to make a mistake. Trust me, you don't want to practice on a production environment.
Once the database is restored, when you have plenty of time, I'd suggest you start by having a thorough look at the documentation. You should be fine with the Backup and Recovery Basics Guide.
Nowadays, you can perform recovery through the Entreprise Manager web interface (this is a nice wrapper of RMAN).