You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?
A. Mount the database
B. Open the database in NORMAL mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
在使用备份重建控制文件之后,你需要使用这个重建的控制文件挂载数据库,然后执行 recover,最后以RESETLOGS 的方式打开数据库。
--丢失数据文件,无法正常关闭,需要 abort 关闭数据库
恢复操作过程如下:
1. startup nomount;
2. restore controlfile from autobackup;
3. alter database mount;
4.recover database;
5. alter database open resetlogs;