Skip to Main Content

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!

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
671 views