My Oracle Support Banner

Standby MRP is looking for very old archive log sequence even after restore new incremental backup at standby site. (Doc ID 1542907.1)

Last updated on MARCH 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***

Symptoms

Ct applied incremental backup, but still standby MRP is looking for very old sequence.

SQL>SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
  FROM (SELECT THREAD# ,SEQUENCE#
  FROM V$ARCHIVED_LOG
  WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME)
  FROM V$ARCHIVED_LOG
  GROUP BY THREAD#)) ARCH,
  (SELECT THREAD# ,SEQUENCE#
  FROM V$LOG_HISTORY
  WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME)
  FROM V$LOG_HISTORY
  GROUP BY THREAD#)) APPL
  WHERE ARCH.THREAD# = APPL.THREAD#
  ORDER BY 1;


  Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
  1 23861 23057 804
  2 8553 8259 294
  3 8542 8248 294

SQL>select process,status,sequence# from v$managed_standby where PROCESS ='MRP0';

PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 WAIT_FOR_GAP 17353

Changes

 Standby db has just been restored from incremental backup taken from primary.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.