Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Guard - MRP stuck issues on a physical standby database

kooloracleJul 16 2012 — edited Jul 16 2012

Hi,

Oracle 11.2.0.3 DG running. When i do a switchover the physical standby database has error with following error

ARC0: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance <primaryDB> - Archival Error

On standby DB

SQL>select process, thread#, sequence#, status from v$managed_standby where process='MRP0';
PROCESS THREAD# SEQUENCE# STATUS
-------- --------- ---------- ------------

MRP0 1 548 APPLYING_LOG

So according to Oracle support link i executed following

SQL>recover managed standby database cancel;
SQL>recover automatic standby database;

The above seems to resolve the issue. What is causing is this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2012

Added on Jul 16 2012

#data-guard, #performance-availability

6 comments

4,370 views