升级途中停电导致数据字典修改不一致,打开库后如下:
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
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 修改数据字典即可
以STARTUP UPGRADE启动实例
执行@ORACLE_HOME/rdbms/admin/catupgrd.sql 修改数据字典即可
这步执行时间较长。
*/
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
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.
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/