Oracle 10.2.0.3 Gap Resolution of Physical Standby Appears to Hang

Last week we’ve encountered the archived-log-gap-missing issue on Oracle 10.2.0.3 physical standby. Looking from V$MANAGED_STANDBY, it showed waiting for gap of the archived log sequence #53713. SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS ——— ———— ———- ———- ———- ———- ARCH      CONNECTED             0          0          0          0 ARCH      …

Oracle 10.2.0.3 Gap Resolution of Physical Standby Appears to Hang Read More »