ORA-01122 ORA-01208 故障处理---惜分飞

数据库突然故障ORA-01122 ORA-01208,导致实例crash

Tue Jul 11 09:06:43 2023 Thread 1 cannot allocate new log, sequence 254989 Private strand flush not complete   Current log# 3 seq# 254988 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\xff\REDO03.LOG Thread 1 advanced to log sequence 254989 (LGWR switch)   Current log# 1 seq# 254989 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\xff\REDO01.LOG Tue Jul 11 09:09:46 2023 Read of datafile 'E:\APP\ADMINISTRATOR\ORADATA\xff\SYSTEM01.DBF' (fno 1) header failed with ORA-01208 Rereading datafile 1 header found valid data Repaired corruption in datafile 1 header Read of datafile 'E:\APP\ADMINISTRATOR\ORADATA\xff\SYSAUX01.DBF' (fno 2) header failed with ORA-01208 Rereading datafile 2 header found valid data Repaired corruption in datafile 2 header Read of datafile 'E:\APP\ADMINISTRATOR\ORADATA\xff\UNDOTBS01.DBF' (fno 3) header failed with ORA-01208 Rereading datafile 3 header failed with ORA-01208 Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\trace\xff_ckpt_5820.trc: ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01122: database file 3 failed verification check ORA-01110: data file 3: 'E:\APP\ADMINISTRATOR\ORADATA\xff\UNDOTBS01.DBF' ORA-01208: data file is an old version - not accessing current version Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\trace\xff_ckpt_5820.trc: ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01122: database file 3 failed verification check ORA-01110: data file 3: 'E:\APP\ADMINISTRATOR\ORADATA\xff\UNDOTBS01.DBF' ORA-01208: data file is an old version - not accessing current version CKPT (ospid: 5820): terminating the instance due to error 1242 ………… Tue Jul 11 09:10:10 2023 Instance terminated by CKPT, pid = 5820 Tue Jul 11 09:18:32 2023

重启实例无法open

Tue Jul 11 09:18:41 2023 alter database mount exclusive Successful mount of redo thread 1, with mount id 1485684209 Database mounted in Exclusive Mode Lost write protection disabled Completed: alter database mount exclusive alter database open Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\trace\xff_ora_406776.trc: ORA-01113: file 3 needs media recovery ORA-01110: data file 3: 'E:\APP\ADMINISTRATOR\ORADATA\xff\UNDOTBS01.DBF' ORA-1113 signalled during: alter database open...

通过Oracle Database Recovery Check工具分析
 

---

确认数据库恢复需要sequence为254986的日志,但是数据库为非归档模式,redo已经被覆盖,因此常规方法无法正常open库,通过Oracle Recovery Tools工具快速修改文件头实现数据库文件头一致,open数据库成功