联系:手机/微信(+86 17813235971) QQ(107644445)
标题:一键恢复ORA-00704 ORA-00702故障—202512
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
alert日志相关报错信息
Mon Dec 15 14:10:56 2025 ALTER DATABASE OPEN Beginning crash recovery of 1 threads parallel recovery started with 5 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 654, block 2, scn 16937055 Recovery of Online Redo Log: Thread 1 Group 3 Seq 654 Reading mem 0 Mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 654, block 3, scn 16957057 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Thread 1 advanced to log sequence 655 (thread open) Thread 1 opened at log sequence 655 Current log# 1 seq# 655 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Dec 15 14:10:57 2025 SMON: enabling cache recovery Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_7952.trc: ORA-00704: 引导程序进程失败 ORA-00702: 引导程序版本 '' 与版本 '8.0.0.0.0' 不一致 Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_7952.trc: ORA-00704: 引导程序进程失败 ORA-00702: 引导程序版本 '' 与版本 '8.0.0.0.0' 不一致 Error 704 happened during db open, shutting down database USER (ospid: 7952): terminating the instance due to error 704 Instance terminated by USER, pid = 7952 ORA-1092 signalled during: ALTER DATABASE OPEN... opiodr aborting process unknown ospid (7952) as a result of ORA-1092 Mon Dec 15 14:11:00 2025 ORA-1092 : opitsk aborting process Mon Dec 15 14:39:18 2025
这种故障处理比较多,主要是bootstrap$基表损坏,后来为了解决这种问题方便,专门写了一个小工具(bootstrap$异常修复小工具)来一键修复该问题

通过bootstrap$异常修复小工具修复之后,然后直接启动数据库成功,完成本次恢复任务

