ORA-01092 ORA-00704 ORA-39700 bootstrap process failure

升级途中停电导致数据字典修改不一致，打开库后如下：
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 3332
Session ID: 233 Serial number: 1

 

/*

解决办法：
以STARTUP UPGRADE启动实例
执行@ORACLE_HOME/rdbms/admin/catupgrd.sql 修改数据字典即可

这步执行时间较长。

*/

 

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1406128128 bytes
Fixed Size                  1336484 bytes
Variable Size            1174408028 bytes
Database Buffers          218103808 bytes
Redo Buffers               12279808 bytes
Database mounted.
Database opened.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26143577/viewspace-722496/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26143577/viewspace-722496/