Cent OS 断电导致数据库日志损坏无法正常打开的问题解决过程

正常的数据库启用应该如下：

SQL> startup
ORACLE instance started.

Total System Global Area 4680843264 bytes
Fixed Size            2933736 bytes
Variable Size          989858840 bytes
Database Buffers     3674210304 bytes
Redo Buffers           13840384 bytes
Database mounted.
Database opened.

由于虚拟机异常断电，导致最后两行不能正常出现。在网上查询问题，输入Ora对应的故障编号，查询问题对应进行解决即可。

ittutorial.org

ORA-01589: Must use resetlogs or nonresetlogs option for database open

ORA-01610: Recovery using the backup controlfile option must be done

1) dump controlfile to trace

SQL>alter databse backup controlfile to trace as '/home/oracle/controlfile.sql';

SQL> startup nomount

SQL>@/home/oracle/controlfile.sql