试题详情
- 单项选择题You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）
A、Start the instance and open the database， instance recovery automatically recoverscontrol files
B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
- D
关注下方微信公众号，在线模考后查看
热门试题