ORA-00742:oracle数据库服务器断电后文件丢失恢复（非归档模式下noarchive）

错误提示：

SQL> startup
ORACLE instance started.

Total System Global Area 5368709120 bytes
Fixed Size		    8632016 bytes
Variable Size		 2281703728 bytes
Database Buffers	 3070230528 bytes
Redo Buffers		    8142848 bytes
Database mounted.
ORA-00742: Log read detects lost write in thread 1 sequence 31 block 217928
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/zydb/redo03.log'

执行恢复：
1、通过使用备份控制文件直到取消，来恢复数据库

RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

2、执行提示的重做日志文件

/u01/app/oracle/oradata/zydb/redo03.log

3、数据库不完全启动

 ALTER DATABASE OPEN RESETLOGS;

SQL>  RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
ORA-00279: change 3057923 generated at 09/11/2019 10: