Skip to Main Content

Gap Manager Does Not Give Privilege To Missing Sequence?

Umut TekinJan 28 2021

Hi,
There is a lag between my primary and standby databases.
Standby database is waiting for log #sequence 132005 and #thread 4 as you can see below.
RFS LGWR 202438 3 119444 32770 2048 RECEIVING
MRP0 N/A N/A 4 132005 0 0 WAIT_FOR_LOG
RFS UNKNOWN 55350 4 132005 3540993 2048 RECEIVING
As soon as it arrives MRP process apply it.
However, at the primary side, I have run the below query to see which sequences are being transported to standby according to the @ckpt at link: https://community.oracle.com/tech/apps-infra/discussion/2444112/rfs-not-running-on-my-1st-and-3rd-instances-physical-standby

SQL> select thread#,PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM GV$MANAGED_STANDBY where process='LNS';

THREAD# PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
---------- --------- ------------ ---------- ---------- ---------- ----------
1 LNS WRITING 1 130474 2850922 4
1 LNS WRITING 1 130474 2385321 2048
2 LNS WRITING 2 119177 2700681 8
2 LNS WRITING 2 119177 2298798 2048
3 LNS WRITING 3 119444 2894635 3
3 LNS WRITING 3 119444 520194 2048
4 LNS WRITING 4 132174 4214731 1
4 LNS WRITING 4 132174 2644764 2048
As you can see, waiting sequence are not being transported. It had been started to transport because 3540993 block was transferred. Then it ceased...
Should the gap manager request especially this particular sequence?
The gap is approximately 1 day. If you want to check configuration details I will post it.
Thanks in advance:)!

Comments
Post Details
Added on Jan 28 2021
1 comment
2 views