ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Standby数据库alert log报很多这样的错误: Restarting dead background process QMN0

Standby数据库alert log报很多这样的错误: Restarting dead background process QMN0

原创 Linux操作系统 作者:tolywang 时间:2007-09-05 00:00:00 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13172025