RMAN 回复数据库流程

2009532140

最先答对且答案未经编辑的cuber将根据试题的难度可能获得10-50不等的积分悬赏：
注意：会员需对此贴答案进行说明和简要分析，无说明者不能获得奖励。
或者，给出相关的文档说明，如果能用实验模拟的积分翻倍。


You are using Recovery Manager (RMAN) with a recovery catalog to back up your production
database. The backups and the archived redo log files are copied to a tape drive on a daily basis.
Because of media failure, you lost your production database completely along with the recovery
catalog database. You want to recover the target database and make it functional.
You could consider performing the following steps to accomplish this task:

1) Restore an autobackup of the server parameter file.
2) Restore the control file.
3) Start the target database Instance.
4) Mount the database.
5) Restore the data files.
6) Open the database with the RESETLOGS option.
7) Recover the data files.
Set DBID for the target database

Which option illustrates the correct sequence that you must use?

A.  8, 1, 3, 2, 4, 5, 7, 6
B.  1, 8, 3, 4, 2, 5, 7, 6
C.  1, 3, 4, 2, 8, 5, 6, 7
D.  1, 3, 2, 4, 6, 5, 7, 8

www_xylove

答案是A

简要说明：
恢复流程如下：因为该数据库环境有catalog数据库，所以：

1.设置dbid，读取catalog数据库，指定要恢复哪一个数据库
2.恢复参数文件
3.开启数据库实例
4.恢复控制文件
5.mount数据库
6.restore数据库文件
7.recovery数据库文件
8.打开数据库

2009532140

回复 2# www_xylove


    说实话我也觉得选A~~