ITPub博客

首页 > 数据库 > Oracle > ORA-01092故障处理

ORA-01092故障处理

原创 Oracle 作者:SDYTXM 时间:2013-12-23 00:55:18 0 删除 编辑

一、故障现象:

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博客 ” ,链接:https://blog.itpub.net/20985606/viewspace-1064009/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Vi命令实践
下一篇: vi宏使用
请登录后发表评论 登录
全部评论

注册时间:2012-04-02

  • 博文量
    41
  • 访问量
    217401