本文详细记录了使用Oracle数据库时遇到的强制关闭实例的问题，包括查看故障日志、解决过程和最终成功开启数据库的方法。通过执行一系列步骤，包括强制关闭实例、使用UPGRADE选项启动数据库并进行相关操作，最终问题得以解决。
一、故障现象：
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/
扫一扫
1905
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
