Standby資料庫alert log報很多這樣的錯誤: Restarting dead background process QMN0

tolywang發表於2007-09-05
Tue Sep 4 22:00:01 2007
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章