Flapping standby database

From: Greg <greg.horie_at_telus.com>
Date: 9 Jun 2003 11:34:40 -0700
Message-ID: <3b3f4692.0306091034.1680e142@posting.google.com>

Hi,

I'm having problems where my physical standby server works for a certain period of time, then just stops applying the archived logs (MRP0 process fails). The logs are stilling being moved to the standby, but they just stop being applied. I can restart the standby, at which point the archived redo logs are applied and everything seems to work fine. However, after a few hours the MRP0 process fails again.

Here is what I see in the alert log when the standby stops applying the logs:
---

Fri Jun 6 23:19:55 2003

Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000310.log
Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000311.log
Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000312.log
Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000313.log

Media Recovery Waiting for thread 1 seq# 314 Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000314.log MRP0: Background Media Recovery failed with error 16145 Fri Jun 6 23:31:33 2003
Errors in file /opt/oracle/admin/oradb1/bdump/oradb1_mrp0_18423.trc: ORA-16145: archival for thread# 1 sequence# 314 in progress Recovery interrupted.
Recovered data files restored to a consistent state at change 1097364144124.
MRP0: Background Media Recovery process is now terminated
---

Here is the related trc file:
---

/opt/oracle/admin/oradb1/bdump/oradb1_mrp0_18423.trc Oracle9i Enterprise Edition Release 9.0.1.3.0 - 64bit Production With the Partitioning option
JServer Release 9.0.1.3.0 - Production
ORACLE_HOME = /opt/oracle/product/9.0.1.3 System name: SunOS

Node name:      oraserver01
Release:        5.8
Version:        Generic_108528-17
Machine:        sun4u

Instance name: oradb1
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 18423, image: oracle_at_oraserver01 (MRP0)

SESSION ID:(13.11) 2003-06-06 23:19:53.330 Detected dead process 18388; subsuming V$MANAGED_STANDBY slot Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000309.log Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000310.log Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000311.log Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000312.log Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000313.log
2003-06-06 23:31:33.633 Media Recovery Log /opt/oracle/arch/oradb1/arch_oradb1_0000000314.log ORA-16145: archival for thread# 1 sequence# 314 in progress
---

Does anyone know how I can get this process to work properly?

Thanks,

Greg.

Received on Mon Jun 09 2003 - 13:34:40 CDT