联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有朋友找到我们,他们数据库启动报ORA-01092 ORA-00704 ORA-00702错
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set SMON: enabling cache recovery Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_4868.trc: ORA-00704: 引导程序进程失败 ORA-00702: 引导程序版本 '' 与版本 '8.0.0.0.0' 不一致 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_4868.trc: ORA-00704: 引导程序进程失败 ORA-00702: 引导程序版本 '' 与版本 '8.0.0.0.0' 不一致 Error 704 happened during db open, shutting down database USER (ospid: 4868): terminating the instance due to error 704 Thu May 06 09:20:28 2021 Instance terminated by USER, pid = 4868 ORA-1092 signalled during: ALTER DATABASE OPEN...
以前有过类似恢复经历:
2019恢复第一单—ORA-704-ORA-702恢复
恶意删除bootstrap$导致数据库无法正常启动
ORA-00702: bootstrap verison ” inconsistent with version ’8.0.0.0.0′
这个问题本身相对比较简单,客户根据网上介绍,自行尝试恢复,经过客户一系列的处理之后,数据库启动报ORA-00704 ORA-00943错
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set SMON: enabling cache recovery Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_6600.trc: ORA-00704: 引导程序进程失败 ORA-00943: 簇不存在 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_6600.trc: ORA-00704: 引导程序进程失败 ORA-00943: 簇不存在 Error 704 happened during db open, shutting down database USER (ospid: 6600): terminating the instance due to error 704 Thu May 06 22:17:18 2021 Instance terminated by USER, pid = 6600 ORA-1092 signalled during: ALTER DATABASE OPEN... opiodr aborting process unknown ospid (6600) as a result of ORA-1092
因为根据最初的错误知道是bootstrap$异常,现在报该错误,应该是bootstrap$没有处理正确导致,我们通过对bootstrap$重新处理,数据库直接open成功