QUESTION NO: 175
You have lost all your database control files. To recover them, you are going to use the results of the alter
database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.
Which of the following is true regarding your recovery?
A. You will need to open the database with the resetlogs command.
B. All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
C. You will use the resetlogs version of the create controlfile command.
D. You will use the noresetlogs version of the create controlfile command.
E. You will use the trace file to create a backup control file, and then you will recover the database with the
recover database using backup controlfile command
Answer: D
你已经失去了所有的数据库的控制文件。要恢复它
们,你要使用修改数据库备份控制文件到跟踪文件命令的结果。你的数据文件和联机重做日志都完好无
损。关于你的恢复操作下列哪一项是正确的?
D.您将使用创建控制文件命令的非重置日志版本。
Since the online redo logs are intact, you will be able to use the noresetlogs version of the create