oracle死進程報錯ORA-01012

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16381228/viewspace-716670/