ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle死進程報錯ORA-01012

oracle死進程報錯ORA-01012

原创 Linux操作系统 作者:deitylee 时间:2012-02-17 14:57:41 0 删除 编辑
oracle>rman target /

復原管理程序: Release 11.2.0.1.0 - Production on 星期五2月 17 14:25:36 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: 初始化內部復原管理程式套裝程式失敗
RMAN-04005:目標資料庫錯誤
ORA-01089: immediate shutdown in progress - no operations are permitted

oracle>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 2月 17 14:31:20 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

已連線
14:31:20 SYS@orcl>startup
ORA-01012: not logged on
14:32:35 SYS@orcl>shutdown immediate
ORA-24324: 服務處理未初始化
ORA-24323: 不允許數值
ORA-01089: immediate shutdown in progress - no operations are permitted
14:32:40 SYS@orcl>exit
已切斷連線

oracle>ps -ef|grep ora_dbw
oracle    8041     1  0 14:01 ?        00:00:00 ora_dbw0_orcl
oracle   10208  2792  0 14:32 pts/2    00:00:00 grep ora_dbw
oracle>kill -9 8041
oracle>ps -ef|grep ora_dbw
oracle   10211  2792  0 14:33 pts/2    00:00:00 grep ora_dbw
oracle>sqlplus / as sysdba
14:33:14 SYS@orcl>startup
ORACLE 執行處理已經啟動

Total System Global Area  497995776 bytes
Fixed Size                  1337464 bytes
Variable Size             411043720 bytes
Database Buffers           79691776 bytes
Redo Buffers                5922816 bytes
資料庫已掛載
資料庫已開啟
14:33:46 SYS@orcl>exit
oracle>rman target /

復原管理程式: Release 11.2.0.1.0 - Production on 星期五 2月 17 14:39:09 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

已連接到目標資料庫: ORCL (DBID=1292824484)


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16381228/viewspace-716670/,如需转载,请注明出处,否则将追究法律责任。

下一篇: LogMiner使用詳解
请登录后发表评论 登录
全部评论

注册时间:2011-10-27

  • 博文量
    74
  • 访问量
    360327