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/，如需轉載，請註明出處，否則將追究法律責任。