When I find the applied sequence# doesn’t increase from grid control for a standby database
When I find DR the applied arch sequence# doesn’t increase from grid control for a physical standby database, and MRP (Managed Recovery Process ) sticks and doesn’t apply more logs, what do you do to find the cause of the issue and resolve the issue to let physical standby database in-sync with primary database
select PROCESS,STATUS,THREAD#,SEQUENCE#,BLOCK#,BLOCKS from v$managed_standby
where process like '%MRP%';
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
MRP0 APPLYING_LOG 1 46213 1606017 2048000
SQL>select thread#, max(sequence#) "Last Standby Seq Received" from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1;