Standby資料庫alert log報很多這樣的錯誤: Restarting dead background process QMN0
Media Recovery Start
ORA-279 signalled during: ALTER DATABASE RECOVER standby database ...
Tue Sep 4 22:00:02 2007
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Sep 4 22:00:02 2007
Media Recovery Log /data/multidb/arch/1_2640.arc
Tue Sep 4 22:01:45 2007
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Sep 4 22:01:45 2007
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Sep 4 22:01:45 2007
Media Recovery Log /data/multidb/arch/1_2641.arc
Errors with log /data/multidb/arch/1_2641.arc
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Sep 4 22:01:45 2007
ALTER DATABASE RECOVER CANCEL
Tue Sep 4 22:01:45 2007
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL
Tue Sep 4 22:03:12 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:09:12 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:15:13 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:21:13 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:27:13 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:33:13 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:39:14 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:45:14 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:51:14 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:57:14 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 22:57:14 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 23:00:00 2007
ALTER DATABASE RECOVER standby database
Tue Sep 4 23:00:00 2007
Media Recovery Start
ORA-279 signalled during: ALTER DATABASE RECOVER standby database ...
Tue Sep 4 23:00:01 2007
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Sep 4 23:00:01 2007
Media Recovery Log /data/multidb/arch/1_2641.arc
Tue Sep 4 23:01:40 2007
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Sep 4 23:01:40 2007
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Sep 4 23:01:40 2007
Media Recovery Log /data/multidb/arch/1_2642.arc
Errors with log /data/multidb/arch/1_2642.arc
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Sep 4 23:01:40 2007
ALTER DATABASE RECOVER CANCEL
Tue Sep 4 23:01:41 2007
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL
Tue Sep 4 23:03:15 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 23:09:15 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 23:15:15 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 23:21:15 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 23:27:16 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 23:33:16 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Sep 4 23:39:16 2007
Restarting dead background process QMN0
------------------------------------------------------
可能不小心開啟了高階佇列 advanced Queueing 的引數
修改回來即可
SQL*Plus: Release 9.2.0.7.0 - Production on Wed Sep 5 11:56:57 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL>
SQL>
SQL> show parameter aq_tm_processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
SQL>
SQL>
SQL> alter system set aq_tm_processes=0 scope=both;
System altered.
SQL>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-84883/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Bug 3248886 - Continous 'restarting dead background process qmn0' message in alert.logREST
- Bug 3248886 - Continous 'restarting dead background process qmn0' message in aleREST
- 告警日誌頻繁出現Restarting dead background process QMNC資訊REST
- 物理Standby資料庫及邏輯Standby資料庫(Physical Standby & Logical Standby)資料庫
- RAC環境的STANDBY資料庫備份報錯資料庫
- STANDBY資料庫出ORA-1009錯誤資料庫
- 9.2 STANDBY資料庫出現ORA-16009錯誤資料庫
- ora-00020資料庫報錯,process程式爆滿資料庫
- 11g_測試kill殺死 background process後臺程式與alert
- 資料庫報ORA-01839的錯誤資料庫
- 做standby 資料庫時,出現ORA-12560 錯誤:資料庫
- 當很多連線到你的資料庫時,報這種錯誤“已超過了鎖請求超時時段” SqlServer資料庫正在還原的解決辦法...資料庫SQLServer
- alert檔案中出現:Auto-tuning: Shutting down background process GTXd
- 資料庫alert日誌報ORA-03137 TTC 協議內部錯誤故障分析處理資料庫協議
- ASM上恢復STANDBY資料庫出現ORA-15173錯誤ASM資料庫
- 解決Restarting死程式QMN0問題一例REST
- logical standby DG同步錯誤問題總結
- 資料庫資訊不能同步到CATALOG,報RMAN-20032 錯誤資料庫
- 我的postgresql資料庫報埠錯誤,連線失敗SQL資料庫
- standby資料庫的研究!資料庫
- Alert Log中“Fatal NI connect error 12170”錯誤問題Error
- oracle LOGICAL standby ORA-04030: out of process memoryOracle
- 資料庫報ORA-01110錯誤資料庫
- 物理data guard備standby庫的時候報錯。
- ORA-17629:rman建立 standby資料庫時報錯資料庫
- 從Alert_Log看Oracle資料庫啟動三階段Oracle資料庫
- Alert.log shows No Standby Redo Logfiles Of Size 153600 Blocks AvailableBloCAI
- 怎樣報表資料庫資料庫
- 複製資料庫的報錯資料庫
- 部署STANDBY資料庫資料庫
- 關於資料抓取很多新人的誤區
- 資料庫新手常犯的 5 個錯誤資料庫
- 【Redis】slaveof 報錯 Background transfer errorRedisError
- 很多人容易犯的面試錯誤面試
- 資料庫升級報錯資料庫
- oracle 817 ora_snp background processOracle
- Oracle Standby資料庫建立Oracle資料庫
- standby 資料庫的建立過程資料庫