052-239(新增70题2018)

You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, and dropped a couple of tablespaces. This morning, due to hardware failure, you lost all your control files.

How would you recover the database from this situation?

A. execute the CREATE CONTROLFILE FROM BACKUP... command

B. restore all database files from the last backup and apply redo logs till the point of failure

C. restore the binary copy of the control file to the respective location and start up the database

D. start up the database in the NOMOUNT state, generate the trace file from binary backup, and re-create the control file using the the mount and open the database

E. restore the binary copy of the control file to the correct location, start up the instance in the mount state, backup the control file to instance, edit the trace file to reflect the added and removed data files, then use the script generated in the trace file to start the in the control file

Answer: E

所有控制文件丢失，只能用之前的二进制备份恢复控制文件，然后靠trace文件中的记录恢复。

• What Is a Control File?

The control file must be available for writing by the Oracle Database server whenever the database is open. Without the control file, the database cannot be mounted and recovery is difficult.

转载于:https://www.cnblogs.com/Babylon/p/8623606.html