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
答案解析:有
微信扫一扫手机做题