Skip to Main Content

Database Software

WAIT_FOR_GAP

RobeenAug 18 2020 — edited Sep 8 2020

Oracle DB 12.1.0.2

Hello Team,

i recently configured a DG from RAC to standalone. archivelogs are being shipped from RAC to the standby DB. Standby DB is receiving archivelogs from primary.

The issue is I noticed the MRP0 process is stuck.

select process, thread#, sequence#, status from v$managed_standby where process='MRP0';

PROCESS      THREAD#  SEQUENCE# STATUS

--------- ---------- ---------- ------------

MRP0               1          4 WAIT_FOR_GAP

How can I solve this?

Regards,

Joe

This post has been answered by Shaik Ahmed Ali Bajubair on Oct 13 2020
Jump to Answer
Comments
Post Details
Added on Aug 18 2020
11 comments
119 views