asked on
SQL> select inst_id, process, status, thread#, sequence#, block#, blocks from gv$managed_standby where process in ('RFS','LNS','MRP0');
INST_ID PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
---------- --------- ------------ ---------- ---------- ---------- ----------
1 RFS IDLE 0 0 0 0
1 LNS CLOSING 1 39317 153237 22
1 MRP0 WAIT_FOR_LOG 1 39318 0 0
1 RFS IDLE 0 0 0 0
1 RFS IDLE 0 0 0 0
1 RFS IDLE 0 0 0 0
1 RFS IDLE 0 0 0 0
1 RFS IDLE 0 0 0 0
1 RFS IDLE 0 0 0 0
1 RFS IDLE 0 0 0 0
1 RFS IDLE 0 0 0 0
DB_UNIQUE_NAME THREAD# PRIMARY_DEST_ID STANDBY_DEST_ID PRIMARY_ARCHIVED_SEQUENCE STANDBY_APPLIED_SEQUENCE GAP
------------------------------ ---------- --------------- --------------- ------------------------- ------------------------ ----------
MMFP 1 1 2 39362 39316 46
I can see GAP is 46, How Can I fix a standby database gap?