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

联系：手机/微信(+86 17813235971) QQ(107644445)

标题：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数据库成功

---

• Oracle Recovery Tools快速恢复断电引起的无法正常启动数据库(ORA-01555,MISSING000等问题）
• 分享一次ORA-01113 ORA-01110故障处理过程
• win系统删除oracle数据文件恢复
• Oracle Recovery Tools 解决ORA-600 3020故障
• ORA-600 kcratr_scan_lastbwr 恢复
• Oracle Recovery Tools快速恢复ORA-19909
• ORA-600 3600恢复—-resetlogs scn异常
• drop tablesapce 数据恢复
• ORA-00322 ORA-00312恢复
• Oracle Recovery Tools快速恢复重建ctl遗漏数据文件故障
• ora-600 kcratr_scan_lastbwr
• Oracle Recovery Tools 解决ORA-01190 ORA-01248等故障