本文深入解析了在数据库管理中遇到数据丢失时的恢复流程，特别关注如何通过恢复目录数据库来恢复控制文件和数据文件。通过连接目录数据库、启动数据库实例、恢复控制文件、进入mount状态、恢复数据文件直至最终使用openresetlogs命令打开数据库，文章详细阐述了每一步骤的操作及重要性，确保数据库能够顺利恢复并运行。
332.David managed to accidentally delete the datafiles for database called DSL. He called Heber and
Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill
saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover
the database and in what order?
A. Restored the control file with the RMAN restore controlfile command.
B. Mounted the DSL instance with the alter database mount command.
C. Restored the datafiles for the DSL database with the RMAN restore command.
D. Opened the DSL database with the alter database open resetlogs command.
E. Recovered the datafiles for the DSL database with the RMAN recover command.
F. Started the DSL instance.
G. Connected to the recovery catalog with RMAN.
H. a, b, c, d, e, f, g
I. b, c, d, g, f, e, a
J. g, f, a, b, c, e, d
K. c, a, d, b, f, e, g
L. g, f, a, b, e, c, d
Answer: C
答案解析：
题中说，在avid不小心删除的数据库和heber删除了控制文件后，怎么使用恢复目录来恢复数据库，数据路实例名：DSL
1，连接到目录数据库
2，启动DSL数据库实例
3，恢复控制文件
4，启动到mount状态
5，恢复数据文件
6，recover数据文件
7，因为是重新恢复的控制文件，所有用open resetlogs打开数据库
扫一扫
1045
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
