575.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
答案解析:
答案解析:http://docs.oracle.com/cd/E11882_01/server.112/e25494/omf.htm#ADMIN11509
CREATE CONTROLFILE Using NORESETLOGS Keyword: Example
The following CREATE CONTROLFILE
statement is generated by an ALTER DATABASE BACKUP CONTROLFILE TO TRACE
statement for a database with Oracle managed data files and redo log files: