异常断电，开库报错ORA-00742

某客户数据库服务器异常断电，电源恢复后，开启数据库报错ORA-00742。

SYS@db19c> startup
ORACLE instance started.

Total System Global Area 2147481656 bytes
Fixed Size                  8898616 bytes
Variable Size             570425344 bytes
Database Buffers         1560281088 bytes
Redo Buffers                7876608 bytes
Database mounted.
ORA-00742: Log read detects lost write in thread 1 sequence 1231 block 208153
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/DB19C/onlinelog/o1_mf_1_lpcc2wn3_.log'

查看redo情况

SYS@db19c> SELECT group#, sequence#, status, archived FROM v$log;

    GROUP#  SEQUENCE# STATUS           ARC
---------- ---------- ---------------- ---
         1       1231 CURRENT          NO
         3       1230 INACTIVE         YES
         2       1229 INACTIVE         YES

CLEAR 报错的 redo

SYS@db19c> ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance db19c (thread 1)
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/DB19C/onlinelog/o1_mf_1_lpcc2wn3_.log'

使用redo recover database

SYS@db19c> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
ORA-00279: change 73137062 generated at 07/15/2025 22:02:17 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/oradata/DB19C/arch/1_1231_1154106076.dbf
ORA-00280: change 73137062 for thread 1 is in sequence #1231

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u01/app/oracle/oradata/DB19C/onlinelog/o1_mf_1_lpcc2wn3_.log
Log applied.
Media recovery complete.

resetlogs 开库

SYS@db19c> alter database open RESETLOGS;

Database altered.