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
Explanation:
Refer to here
CREATE CONTROLFILE Using NORESETLOGS 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: CREATE CONTROLFILE
D is correct:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5003.htm
NORESETLOGS
Specify NORESETLOGS if you want Oracle Database to use all files in the LOGFILE clause as they were when the database was last open. These files must exist and must be the current online redo log files rather than restored backups. The database reassigns the redo log file groups to the threads to which they were previously assigned and reenables the threads as they were previously enabled.
Yes, that is true.