ORA-01092故障处理

一、故障现象：

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/