Lokeshaggarwal's DBA

Live the life you love. Love the life you live

Restarting dead background process qmn0


Hi,

I was facing one issue at the time of log applying to physical standby database.I am getting a message in alert log file “restarting dead background process qmn0 “.MRP is not able to applying the specific log to the standby database.

Tue May  3 13:18:38 2011
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process
MRP0 started with pid=15, OS id=29345
MRP0: Background Managed Standby Recovery process started
Media Recovery Waiting for thread 1 seq# 1641
Fetching gap sequence for thread 1, gap sequence 1641-1646
Trying FAL server: prim
Tue May  3 13:18:44 2011
Completed: alter database recover managed standby database di
Tue May  3 13:18:59 2011
Failed to request gap sequence. Thread #: 1, gap sequence: 1641-1646
All FAL server has been attempted.
Tue May  3 13:22:51 2011
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=29398
Tue May  3 13:28:54 2011
Restarting dead background process QMN0

QMN0 started with pid=14, OS id=29404
Tue May  3 13:34:57 2011
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=29406
Tue May  3 13:41:00 2011
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=29408
Tue May  3 13:47:03 2011
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=29410
Tue May  3 13:53:04 2011
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=29412
Tue May  3 13:59:07 2011
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=29414
Tue May  3 14:05:10 2011
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=29418
Tue May  3 14:11:13 2011
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=29420
Tue May  3 14:17:16 2011
Restarting dead background process QMN0

Solution:

If you don’t use Advanced Queueing you can set it to 0:

alter system set aq_tm_processes=0 scope=both;

Advertisements

May 3, 2011 - Posted by | Data Guard

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: