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

531968912發表於2016-06-13
bootAI
升級途中停電導致資料字典修改不一致，開啟庫後如下：
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/25462274/viewspace-2119596/，如需轉載，請註明出處，否則將追究法律責任。

相關文章