一、故障现象:
SYS@PROD>startup force;
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1219184 bytes
Variable Size 96470416 bytes
Database Buffers 213909504 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
二、查看故障日志:
1.Errors in file /u01/app/oracle/admin/PROD/udump/prod_ora_7768.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Sun Dec 22 23:52:38 2013
2. Errors in file /u01/app/oracle/admin/PROD/udump/prod_ora_7768.trc:
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
三、故障解决:
1.SYS@PROD>shut abort
ORACLE instance shut down.
2.SYS@PROD>startup UPGRADE
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1219184 bytes
Variable Size 96470416 bytes
Database Buffers 213909504 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
3. SYS@PROD>@?/rdbms/admin/catproc.sql
PL/SQL procedure successfully completed.
SYS@PROD>startup force;
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1219184 bytes
Variable Size 96470416 bytes
Database Buffers 213909504 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
向Secooler 致敬!
Johnson
13-12-23
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20985606/viewspace-1064009/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20985606/viewspace-1064009/