ORA-01092 ORA-00704 ORA-00942

xifenfei

数据库启动报错


alert日志报错
Mon Nov 25 17:56:44 2019
NSA2 started with pid=38, OS id=14800
Mon Nov 25 17:56:44 2019
SMON: enabling cache recovery
Errors in file /opt/oracle/diag/rdbms/standby/orcl/trace/orcl_ora_14723.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Errors in file /opt/oracle/diag/rdbms/standby/orcl/trace/orcl_ora_14723.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Error 704 happened during db open, shutting down database
USER (ospid: 14723): terminating the instance due to error 704
Instance terminated by USER, pid = 14723
ORA-1092 signalled during: ALTER DATABASE OPEN MIGRATE...
opiodr aborting process unknown ospid (14723) as a result of ORA-1092


10046跟踪报错


这类问题我们在以前的类似恢复
ORA-00704 ORA-00604 ORA-00942故障恢复
ORA-01092 ORA-00704 ORA-00942

对于这个恢复我们通过判断,确实是数据库启动的时候create unique index i_obj1的时候报ORA-00942(表或者视图不存在),从而引起一系列问题,主要是由于obj$异常导致,通过修复在数据库启动过程中创建正常,数据库完美启动

xifenfei

还有类似文档：Oracle 11g丢失access$恢复方法
11.1.0.7版本也会出现access$表丢失导致数据库无法启动