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 »