05389

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?
A. Open the database in NORMAL mode
B. Open the database in read-only mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option

执行灾难恢复需要满足下列条件:
1.所有数据文件的备份
2.备份中产生的归档日志
3.至少一个备份的控制文件
4.数据库的 DBID(标识符)
在重建数据库并加载剩余归档日志后,也就是在新主机上进行重建后,由于是不完全恢复,此时必须以resetlogs 的方式打开数据库。
基本过程:
• 还原服务器参数文件的自动备份。
• 启动目标数据库实例。
• 从自动备份还原控制文件。
• 装载数据库。
• 还原数据文件。
• 恢复数据文件。
• 使用 RESETLOGS 选项打开数据库

原文地址:https://www.cnblogs.com/Babylon/p/7839027.html