ORA-00742:Log read detects lost writein thread 1 sequence 1202 block 137840

刘泽宇

数据库启动时，启动到mount报错：
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/db/redo03.log'


执行恢复：
通过使用备份控制文件直到取消，来恢复数据库
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL


指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
介质恢复已取消。

SQL> alter database open resetlogs; --一般情况下到这里就能启动

数据库已更改。